FirePro W8000対GeForce GTX 760
パフォーマンス・スコア
スペックやパフォーマンスデータを含め、FirePro W8000とGeForce GTX 760を比較した。
GTX 760はFirePro W8000をベンチマーク集計結果に基づき、中程度の17%で上回る。
主な内容
FirePro W8000とGeForce GTX 760のタイプ（デスクトップまたはラップトップの）とアーキテクチャに関する情報及び販売の開始時間とその時点の値段に関する情報です。
| 性能のランキングでの位 | 405 | 373 |
| 人気順の場所 | トップ100圏外 | トップ100圏外 |
| 費用対効果評価 | 6.15 | 4.48 |
| アーキテクチャー | GCN 1.0 (2012−2020) | Kepler (2012−2018) |
| コードネーム | Tahiti | GK104 |
| タイプ | ワークショップ向けの | デスクトップの |
| 発売日 | 14 ６月 2012(12年 前) | 25 ６月 2013(11年 前) |
| 発売価格（MSRP） | $1,599 | $249 |
費用対効果評価
指標を得るためには、他のビデオカードのコストを考慮して、ビデオカードの性能とコストを比較します。
FirePro W8000はGTX 760より37%お得です。
詳細仕様
シェーダーの数、GPUコアクロック、製造プロセス、テクスチャリング、計算速度などのFirePro W8000とGeForce GTX 760の一般的な性能のパラメーターです。これらのパラメータは間接的にFirePro W8000とGeForce GTX 760の性能を表しますが、正確な評価のために、ベンチマークとゲームテストの結果を考慮する必要があります。
| シェーダープロセッサの数 | 1792 | 1152 |
| コア周波数 | 900 MHz | 980 MHz |
| Boost周波数 | データなし | 1033 MHz |
| トランジスタの数 | 4,313 million | 3,540 million |
| 技術プロセス | 28 nm | 28 nm |
| 消費電力（TDP） | 225 Watt | 170 Watt |
| テクスチャリングの速度 | 100.8 | 99.07 |
| 浮動小数点性能 | 3,226 gflops | 2,378 gflops |
フォームファクターと互換性
他のコンピューターコンポーネントとのFirePro W8000とGeForce GTX 760の互換性に関する情報です。 将来のコンピュータ構成を選択するとき、または既存の構成をアップグレードするときに役立ちます。 デスクトップのビデオカードのために、ビデオカードの物理的なサイズ（マザーボードとＰＣケースとの互換性）、インターフェイスとバス（マザーボードとの互換性）及び追加の電源コネクタ（電源との互換性）です。
| インターフェース | PCIe 3.0 x16 | PCIe 3.0 x16 |
| 長さ | 279 mm | 241 mm |
| 幅 | 2-slot | 2-slot |
| 補助電源コネクタ | 2x 6-pin | 2x 6-pin |
| SLIのサポート | データなし | + |
VRAMの容量とタイプ
FirePro W8000とGeForce GTX 760にインストールされているメモリーのパラメータは、そのタイプ、サイズ、バス、クロック、および結果として生じる帯域幅です。プロセッサーに統合されたビデオカードには専用メモリーがなく、システムRAMの共有部分を使用することに注意してください。
| メモリーのタイプ | GDDR5 | GDDR5 |
| 最大メモリー容量 | 4 ギガバイト | 2 ギガバイト |
| メモリーのバスの幅 | 256 Bit | 256 Bit |
| メモリー周波数 | 5500 MHz | 3000 MHz |
| メモリー帯域幅 | 176.0 ギガバイト/s | 192.3 ギガバイト/s |
| 共有メモリー | データなし | - |
接続性と出力
FirePro W8000とGeForce GTX 760で利用可能なビデオコネクタを一覧表示します。 原則として、このセクションはデスクトップ参照ビデオカードにのみ関連します。ノートブックの場合、特定のビデオ出力の可用性はラップトップモデルに依存するためです。
| ディスプレイコネクタ | 4x DisplayPort, 1x SDI | 2x DVI, 1x HDMI, 1x DisplayPort |
| HDMI | データなし | + |
API互換性
FirePro W8000とGeForce GTX 760にサポートされているAPIが、そのバージョンも含めてリストされています。
| DirectX | 12 (11_1) | 12 (11_0) |
| シェーダーモデル | 5.1 | 5.1 |
| OpenGL | 4.6 | 4.6 |
| OpenCL | 1.2 | 1.2 |
| Vulkan | 1.2.131 | 1.1.126 |
| CUDA | データなし | + |
合成ベンチマークのパフォーマンス
これらは、ゲーム以外のベンチマークで性能をレンダリングするためのFirePro W8000とGeForce GTX 760のテストの結果です。 合計スコアは0〜100の範囲で、100は現時点で最速のビデオカードに対応します。
合成ベンチマークの合計スコア
これは、当社のベンチマーク性能の総合評価です。私たちは定期的に結合アルゴリズムを改善していますが、もし何か矛盾を感じられた場合は、コメント欄で遠慮なくおっしゃってください、通常は問題を迅速に解決します。
GeForce GTX 760は、ベンチマークを合わせた結果、FirePro W8000を17%上回るパフォーマンスを発揮しています。
Passmark
Passmark PerformanceTestスイートの一部で、おそらく最もユビキタスなベンチマークです。Direct3Dのバージョン9、10、11、12の4つのベンチマーク（最後のベンチマークは可能な限り4K解像度で行う）と、DirectComputeの機能に関するいくつかのテストを行い、グラフィックスカードを徹底的に評価します。
ベンチマークのカバー率 25%
GeForce GTX 760は、PassmarkにおいてFirePro W8000を17%上回る。
ゲーミング・パフォーマンス
ゲームでのFirePro W8000およびGeForce GTX 760のテスト結果で、FPSで測定されます。
すべてのPCゲームの平均FPS
ここでは、さまざまな解像度で人気のあるゲームの大規模なセットにおける平均フレーム/秒を示しています。
| Full HD | 55−60
−18.2%
| 65
+18.2%
|
人気ゲームのFPSパフォーマンス
Full HD
Low Preset
| Cyberpunk 2077 | 18−20
+0%
|
18−20
+0%
|
Full HD
Medium Preset
| Assassin's Creed Odyssey | 27−30
+0%
|
27−30
+0%
|
| Assassin's Creed Valhalla | 18−20
+0%
|
18−20
+0%
|
| Battlefield 5 | 40−45
+0%
|
40−45
+0%
|
| Call of Duty: Modern Warfare | 24−27
+0%
|
24−27
+0%
|
| Cyberpunk 2077 | 18−20
+0%
|
18−20
+0%
|
| Far Cry 5 | 27−30
+0%
|
27−30
+0%
|
| Far Cry New Dawn | 30−35
+0%
|
30−35
+0%
|
| Forza Horizon 4 | 80−85
+0%
|
80−85
+0%
|
| Hitman 3 | 21−24
+0%
|
21−24
+0%
|
| Horizon Zero Dawn | 65−70
+0%
|
65−70
+0%
|
| Metro Exodus | 40−45
+0%
|
40−45
+0%
|
| Red Dead Redemption 2 | 30−35
+0%
|
30−35
+0%
|
| Shadow of the Tomb Raider | 40−45
+0%
|
40−45
+0%
|
| Watch Dogs: Legion | 70−75
+0%
|
70−75
+0%
|
Full HD
High Preset
| Assassin's Creed Odyssey | 27−30
+0%
|
27−30
+0%
|
| Assassin's Creed Valhalla | 18−20
+0%
|
18−20
+0%
|
| Battlefield 5 | 40−45
+0%
|
40−45
+0%
|
| Call of Duty: Modern Warfare | 24−27
+0%
|
24−27
+0%
|
| Cyberpunk 2077 | 18−20
+0%
|
18−20
+0%
|
| Far Cry 5 | 27−30
+0%
|
27−30
+0%
|
| Far Cry New Dawn | 30−35
+0%
|
30−35
+0%
|
| Forza Horizon 4 | 80−85
+0%
|
80−85
+0%
|
| Hitman 3 | 21−24
+0%
|
21−24
+0%
|
| Horizon Zero Dawn | 65−70
+0%
|
65−70
+0%
|
| Metro Exodus | 40−45
+0%
|
40−45
+0%
|
| Red Dead Redemption 2 | 30−35
+0%
|
30−35
+0%
|
| Shadow of the Tomb Raider | 40−45
+0%
|
40−45
+0%
|
| The Witcher 3: Wild Hunt | 30−35
+0%
|
30−35
+0%
|
| Watch Dogs: Legion | 70−75
+0%
|
70−75
+0%
|
Full HD
Ultra Preset
| Assassin's Creed Odyssey | 27−30
+0%
|
27−30
+0%
|
| Assassin's Creed Valhalla | 18−20
+0%
|
18−20
+0%
|
| Call of Duty: Modern Warfare | 24−27
+0%
|
24−27
+0%
|
| Cyberpunk 2077 | 18−20
+0%
|
18−20
+0%
|
| Far Cry 5 | 27−30
+0%
|
27−30
+0%
|
| Forza Horizon 4 | 80−85
+0%
|
80−85
+0%
|
| Hitman 3 | 21−24
+0%
|
21−24
+0%
|
| Horizon Zero Dawn | 65−70
+0%
|
65−70
+0%
|
| Shadow of the Tomb Raider | 40−45
+0%
|
40−45
+0%
|
| The Witcher 3: Wild Hunt | 30−35
+0%
|
30−35
+0%
|
| Watch Dogs: Legion | 70−75
+0%
|
70−75
+0%
|
Full HD
Epic Preset
| Red Dead Redemption 2 | 30−35
+0%
|
30−35
+0%
|
1440p
High Preset
| Battlefield 5 | 24−27
+0%
|
24−27
+0%
|
| Far Cry New Dawn | 18−20
+0%
|
18−20
+0%
|
1440p
Ultra Preset
| Assassin's Creed Odyssey | 12−14
+0%
|
12−14
+0%
|
| Assassin's Creed Valhalla | 9−10
+0%
|
9−10
+0%
|
| Call of Duty: Modern Warfare | 12−14
+0%
|
12−14
+0%
|
| Cyberpunk 2077 | 6−7
+0%
|
6−7
+0%
|
| Far Cry 5 | 14−16
+0%
|
14−16
+0%
|
| Forza Horizon 4 | 60−65
+0%
|
60−65
+0%
|
| Hitman 3 | 14−16
+0%
|
14−16
+0%
|
| Horizon Zero Dawn | 24−27
+0%
|
24−27
+0%
|
| Metro Exodus | 20−22
+0%
|
20−22
+0%
|
| Shadow of the Tomb Raider | 20−22
+0%
|
20−22
+0%
|
| The Witcher 3: Wild Hunt | 12−14
+0%
|
12−14
+0%
|
| Watch Dogs: Legion | 75−80
+0%
|
75−80
+0%
|
1440p
Epic Preset
| Red Dead Redemption 2 | 20−22
+0%
|
20−22
+0%
|
4K
High Preset
| Battlefield 5 | 12−14
+0%
|
12−14
+0%
|
| Far Cry New Dawn | 9−10
+0%
|
9−10
+0%
|
| Hitman 3 | 8−9
+0%
|
8−9
+0%
|
| Horizon Zero Dawn | 55−60
+0%
|
55−60
+0%
|
| Metro Exodus | 10−12
+0%
|
10−12
+0%
|
| The Witcher 3: Wild Hunt | 10−12
+0%
|
10−12
+0%
|
4K
Ultra Preset
| Assassin's Creed Odyssey | 7−8
+0%
|
7−8
+0%
|
| Assassin's Creed Valhalla | 6−7
+0%
|
6−7
+0%
|
| Call of Duty: Modern Warfare | 6−7
+0%
|
6−7
+0%
|
| Cyberpunk 2077 | 2−3
+0%
|
2−3
+0%
|
| Far Cry 5 | 7−8
+0%
|
7−8
+0%
|
| Forza Horizon 4 | 16−18
+0%
|
16−18
+0%
|
| Shadow of the Tomb Raider | 10−12
+0%
|
10−12
+0%
|
| Watch Dogs: Legion | 5−6
+0%
|
5−6
+0%
|
4K
Epic Preset
| Red Dead Redemption 2 | 10−12
+0%
|
10−12
+0%
|
これが人気ゲームでのFirePro W8000とGTX 760の競争である：
- GTX 760は1080pでは18%速い。
すべてにおいて、人気のあるゲームである：
- 72テスト（100%）は引き分け。
長所と短所のまとめ
| 性能評価 | 10.61 | 12.42 |
| ノベルティ | 14 ６月 2012 | 25 ６月 2013 |
| 最大メモリー容量 | 4 ギガバイト | 2 ギガバイト |
| 消費電力（TDP） | 225 ワット | 170 ワット |
FirePro W8000は100%高い最大VRAM量を持っています。
一方、GTX 760は 17.1% 高い総合パフォーマンススコアを持っている、1歳のアドバンテージがある、32.4%消費電力が低い。
GeForce GTX 760は、パフォーマンステストでFirePro W8000を凌駕しているので、我々の推奨する選択である。
FirePro W8000はワークステーション用で、GeForce GTX 760はパソコン用であることに注意してください。
FirePro W8000とGeForce GTX 760のどちらを選択するかについてまだ質問がある場合は、コメントで遠慮なくご質問ください。
類似GPUとの比較
ここでは、より多くの選択肢の中から、レビューに近い性能を持つグラフィックスカードをいくつか選んで比較しています。
Ошибка: Запрос select b.card_id from ss_benchmarks_results as b left join ss_cards as i on i._id=b.card_id and i._disabled=0 and i.redirect_to=0 left join ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0 left join ss_stat_exist as pop on pop.item_type="video" and pop.item1=i._id and pop.item2=2430 and pop.lang="11" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=2430 and pop2.item2=i._id and pop2.lang="11" where b.benchmark_id=-1 and i.type="" and i.prof="1" and i._disabled=0 and ( if(pop.visits,pop.visits,pop2.visits)>=1 OR ( to_days(now()) - to_days(replace("2012-06-14","-00","-01"))<=366/2 OR to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2 ) ) having !isnull(i._id) order by abs(10.61 - b.result) asc /* # 1 */ limit 6 вызвал ошибку Unknown column 'i._id' in 'having clause'
Array
(
[0] => Array
(
[file] => /var/www/web/data/www/technical.city/system/lib/db.php
[line] => 151
[function] => db_query
[args] => Array
(
[0] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=2430 and pop.lang="11"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2430 and pop2.item2=i._id and pop2.lang="11"
where b.benchmark_id=-1 and i.type="" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2012-06-14","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(10.61 - b.result) asc /* # 1 */ limit 6
)
)
[1] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/textblocks/text/85/85
[line] => 150
[function] => db_getItems
[args] => Array
(
[0] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=2430 and pop.lang="11"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2430 and pop2.item2=i._id and pop2.lang="11"
where b.benchmark_id=-1 and i.type="" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2012-06-14","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(10.61 - b.result) asc /* # 1 */ limit 6
)
)
[2] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/textblocks/text/22/222
[line] => 16525
[function] => db_cache
[args] => Array
(
[0] => nearest_video__1_2430_L11
[1] => db_getItems
[2] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=2430 and pop.lang="11"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2430 and pop2.item2=i._id and pop2.lang="11"
where b.benchmark_id=-1 and i.type="" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2012-06-14","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(10.61 - b.result) asc /* # 1 */ limit 6
[3] => Array
(
[0] => ss_benchmarks_results
[1] => ss_cards
)
)
)
[3] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/pages/text/23/323_1
[line] => 15
[args] => Array
(
[0] => /var/www/web/data/www/technical.city/_content/textblocks/text/22/222
)
[function] => include
)
[4] => Array
(
[file] => /var/www/web/data/www/technical.city/system/handler/index.php
[line] => 372
[args] => Array
(
[0] => /var/www/web/data/www/technical.city/_content/pages/text/23/323_1
)
[function] => require
)
)
Ошибка: Запрос select b.card_id from ss_benchmarks_results as b left join ss_cards as i on i._id=b.card_id and i._disabled=0 and i.redirect_to=0 left join ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0 left join ss_stat_exist as pop on pop.item_type="video" and pop.item1=i._id and pop.item2=331 and pop.lang="11" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=331 and pop2.item2=i._id and pop2.lang="11" where b.benchmark_id=-1 and i.type="" and i.prof="1" and i._disabled=0 and ( if(pop.visits,pop.visits,pop2.visits)>=1 OR ( to_days(now()) - to_days(replace("2013-06-25","-00","-01"))<=366/2 OR to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2 ) ) having !isnull(i._id) order by abs(12.42 - b.result) asc /* # 2 */ limit 6 вызвал ошибку Unknown column 'i._id' in 'having clause'
Array
(
[0] => Array
(
[file] => /var/www/web/data/www/technical.city/system/lib/db.php
[line] => 151
[function] => db_query
[args] => Array
(
[0] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=331 and pop.lang="11"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=331 and pop2.item2=i._id and pop2.lang="11"
where b.benchmark_id=-1 and i.type="" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2013-06-25","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(12.42 - b.result) asc /* # 2 */ limit 6
)
)
[1] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/textblocks/text/85/85
[line] => 150
[function] => db_getItems
[args] => Array
(
[0] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=331 and pop.lang="11"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=331 and pop2.item2=i._id and pop2.lang="11"
where b.benchmark_id=-1 and i.type="" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2013-06-25","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(12.42 - b.result) asc /* # 2 */ limit 6
)
)
[2] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/textblocks/text/22/222
[line] => 16525
[function] => db_cache
[args] => Array
(
[0] => nearest_video__1_331_L11
[1] => db_getItems
[2] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=331 and pop.lang="11"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=331 and pop2.item2=i._id and pop2.lang="11"
where b.benchmark_id=-1 and i.type="" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2013-06-25","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(12.42 - b.result) asc /* # 2 */ limit 6
[3] => Array
(
[0] => ss_benchmarks_results
[1] => ss_cards
)
)
)
[3] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/pages/text/23/323_1
[line] => 15
[args] => Array
(
[0] => /var/www/web/data/www/technical.city/_content/textblocks/text/22/222
)
[function] => include
)
[4] => Array
(
[file] => /var/www/web/data/www/technical.city/system/handler/index.php
[line] => 372
[args] => Array
(
[0] => /var/www/web/data/www/technical.city/_content/pages/text/23/323_1
)
[function] => require
)
)
Ошибка: Запрос select b.card_id from ss_benchmarks_results as b left join ss_cards as i on i._id=b.card_id and i._disabled=0 and i.redirect_to=0 left join ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0 left join ss_stat_exist as pop on pop.item_type="video" and pop.item1=i._id and pop.item2=2430 and pop.lang="11" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=2430 and pop2.item2=i._id and pop2.lang="11" where b.benchmark_id=-1 and i.type="" and i.prof="1" and i._disabled=0 and ( if(pop.visits,pop.visits,pop2.visits)>=1 OR ( to_days(now()) - to_days(replace("2012-06-14","-00","-01"))<=366/2 OR to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2 ) ) having !isnull(i._id) order by abs(10.61 - b.result) asc /* # 1 */ limit 6 вызвал ошибку Unknown column 'i._id' in 'having clause'
Array
(
[0] => Array
(
[file] => /var/www/web/data/www/technical.city/system/lib/db.php
[line] => 151
[function] => db_query
[args] => Array
(
[0] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=2430 and pop.lang="11"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2430 and pop2.item2=i._id and pop2.lang="11"
where b.benchmark_id=-1 and i.type="" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2012-06-14","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(10.61 - b.result) asc /* # 1 */ limit 6
)
)
[1] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/textblocks/text/85/85
[line] => 150
[function] => db_getItems
[args] => Array
(
[0] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=2430 and pop.lang="11"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2430 and pop2.item2=i._id and pop2.lang="11"
where b.benchmark_id=-1 and i.type="" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2012-06-14","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(10.61 - b.result) asc /* # 1 */ limit 6
)
)
[2] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/textblocks/text/22/222
[line] => 16525
[function] => db_cache
[args] => Array
(
[0] => nearest_video__1_2430_L11
[1] => db_getItems
[2] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=2430 and pop.lang="11"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2430 and pop2.item2=i._id and pop2.lang="11"
where b.benchmark_id=-1 and i.type="" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2012-06-14","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(10.61 - b.result) asc /* # 1 */ limit 6
[3] => Array
(
[0] => ss_benchmarks_results
[1] => ss_cards
)
)
)
[3] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/pages/text/23/323_1
[line] => 15
[args] => Array
(
[0] => /var/www/web/data/www/technical.city/_content/textblocks/text/22/222
)
[function] => include
)
[4] => Array
(
[file] => /var/www/web/data/www/technical.city/system/handler/index.php
[line] => 372
[args] => Array
(
[0] => /var/www/web/data/www/technical.city/_content/pages/text/23/323_1
)
[function] => require
)
)
