GeForce 8800 GT vs. HD Graphics 5600
Puntuación agregada de rendimiento
Hemos comparado GeForce 8800 GT con HD Graphics 5600, incluyendo especificaciones y datos de rendimiento.
HD Graphics 5600 supera a 8800 GT en un impresionante 60% según nuestros resultados de referencia agregados.
Detalles principales
Información sobre el tipo (para desktops o computadoras portátiles) y la arquitectura de GeForce 8800 GT y HD Graphics 5600, así como el momento de las ventas y el costo en el momento.
| Lugar en el rankng de rendimiento | 1005 | 855 |
| Lugar por popularidad | no en el top-100 | no en el top-100 |
| Evaluación coste-eficacia | 0.02 | 0.40 |
| Arquitectura | Tesla (2006−2010) | Gen. 8 Broadwell (2014−2015) |
| Nombre de código | G92 | Broadwell GT2 |
| Tipo | de escritorio | para los portátiles |
| Fecha de lanzamiento | 29 de Octubre 2007 (16 años hace) | 2 de Junio 2015 (9 años hace) |
| El precio en el momento del lanzamiento | $349 | sin datos |
Evaluación coste-eficacia
Para obtener un índice, comparamos el rendimiento de las tarjetas de vídeo y su coste, teniendo en cuenta el coste de otras tarjetas de vídeo.
La relación calidad-precio de HD Graphics 5600 es un 1900% mejor que la de 8800 GT.
Especificaciones detalladas
Parámetros generales del GeForce 8800 GT y HD Graphics 5600: el número de sombreadores, la frecuencia del núcleo de video, la tecnología de proceso, la velocidad de texturizado y computación. Indirectamente respaldan el rendimiento del GeForce 8800 GT y HD Graphics 5600, aunque para una evaluación precisa es necesario considerar los resultados de los benchmarks y las pruebas del juego.
| La cantidad de los procesadores de sombreado | 112 | 24 |
| La frecuencia del núcleo | 600 MHz | 300 MHz |
| La frecuencia de modo Boost | sin datos | 1050 MHz |
| Cantidad de los transistores | 754 million | 1,300 million |
| El proceso tecnológico de fabricación | 65 nm | 14 nm |
| El consumo de energia (TDP) | 125 Watt | 15 Watt |
| La velocidad de textura | 33.60 | 25.20 |
| El rendimiento con el punto flotante | 336.0 gflops | sin datos |
Factor de forma y compatibilidad
Parámetros responsables de la compatibilidad de GeForce 8800 GT y HD Graphics 5600 con otros componentes de la computadora. Útil por ejemplo, al elegir una configuración de computadora futura o para actualizar una configuración existente. Para las tarjetas de video de desktops es una interfaz de bus de conexión (compatibilidad con la placa base), el tamaño físico de la tarjeta de video (placa base y cuerpo compatible), más conectores de alimentación (compatible con la fuente de alimentación) de alimentación). Para las tarjetas de video para computadoras portátiles, este es el tamaño estimado de la computadora portátil, el bus y el conector de conexión si la tarjeta de video está conectada a través del conector y no está soldada a la placa base.
| Interfaz | PCIe 2.0 x16 | PCIe 2.0 x1 |
| Longitud | 229 mm | sin datos |
| Ancho | 1-slot | sin datos |
| Conectores de alimentación adicionales | 1x 6-pin | sin datos |
Capacidad y tipo de VRAM
Parámetros de memoria instalada en GeForce 8800 GT y HD Graphics 5600 - tipo, tamaño, bus, frecuencia y capacidad del canal. Para las tarjetas de video integradas en el procesador que no tienen su propia memoria, se utiliza una porción compartida de RAM.
| Tipo de memoria | GDDR3 | sin datos |
| La capacidad máxima de RAM | 512 MB | Sistema compartido |
| El ancho del bus de memoria | 256 Bit | 64/128 Bit |
| La frecuencia de la memoria | 1800 MHz | sin datos |
| El ancho de banda de memoria | 57.6 GB/s | sin datos |
| La memoria compartida | sin datos | + |
Conectividad y salidas
Se enumeran los conectores de video disponibles en GeForce 8800 GT y HD Graphics 5600. Como regla general, esta sección es relevante solo para tarjetas de video de referencia de escritorio, ya que para las portátiles la disponibilidad de ciertas salidas de video depende del modelo de computadora portátil.
| Conectores de vídeo | 2x DVI, 1x S-Video | No outputs |
Tecnologías compatibles
Aquí se enumeran las soluciones tecnológicas y las API compatibles con GeForce 8800 GT y HD Graphics 5600. Esta información es necesaria si su tarjeta de video requiere soporte para tecnologías específicas.
| Quick Sync | sin datos | + |
Compatibilidad API
Se enumeran GeForce 8800 GT y HD Graphics 5600 las APIs compatibles incluyendo sus versiones.
| DirectX | 11.1 (10_0) | 12 (11_1) |
| El modelo de sombreado | 4.0 | 5.1 |
| OpenGL | 3.3 | 4.4 |
| OpenCL | 1.1 | 2.0 |
| Vulkan | N/A | 1.1.80 |
| CUDA | 1.1 | sin datos |
Rendimiento sintético de referencia
Estos son los resultados de las pruebas GeForce 8800 GT y HD Graphics 5600 sobre el rendimiento de renderización en los puntos de referencia no relacionados en los juegos. La puntuación total se establece de 0 a 100, donde 100 es la tarjeta de video más rápida en este momento.
Puntuación sintética combinada de los puntos de referencia
Esta es nuestra clasificación de rendimiento de referencia combinada. Estamos mejorando regularmente nuestros algoritmos de combinación, pero si encuentras algunas inconsistencias percibidas, no dudes en hablar en la sección de comentarios, solemos solucionar los problemas rápidamente.
HD Graphics 5600 supera a GeForce 8800 GT en un 60% en nuestros resultados de referencia combinados.
Passmark
Este es probablemente el benchmark más omnipresente, parte de la suite Passmark PerformanceTest. Ofrece una evaluación exhaustiva de la tarjeta gráfica, proporcionando cuatro pruebas separadas para las versiones 9, 10, 11 y 12 de Direct3D (la última se realiza en resolución 4K si es posible), y algunas pruebas más que involucran las capacidades de DirectCompute.
Cobertura de referencia: 25%
HD Graphics 5600 supera a GeForce 8800 GT en un 371% en Passmark.
Rendimiento de juego
Los resultados de GeForce 8800 GT y HD Graphics 5600 en juegos, los valores se miden en FPS.
FPS medios de todos los juegos de PC
Aquí se muestra la media de fotogramas por segundo en un amplio conjunto de juegos populares en diferentes resoluciones:
| Full HD | 7−8
−71.4%
| 12
+71.4%
|
Rendimiento de FPS en juegos populares
Full HD
Low Preset
| Cyberpunk 2077 | 4−5
+0%
|
4−5
+0%
|
Full HD
Medium Preset
| Assassin's Creed Odyssey | 7−8
+0%
|
7−8
+0%
|
| Battlefield 5 | 1−2
+0%
|
1−2
+0%
|
| Call of Duty: Modern Warfare | 5−6
+0%
|
5−6
+0%
|
| Cyberpunk 2077 | 4−5
+0%
|
4−5
+0%
|
| Far Cry 5 | 3−4
+0%
|
3−4
+0%
|
| Far Cry New Dawn | 5−6
+0%
|
5−6
+0%
|
| Forza Horizon 4 | 8−9
+0%
|
8−9
+0%
|
| Hitman 3 | 7−8
+0%
|
7−8
+0%
|
| Horizon Zero Dawn | 18−20
+0%
|
18−20
+0%
|
| Red Dead Redemption 2 | 4−5
+0%
|
4−5
+0%
|
| Shadow of the Tomb Raider | 10−11
+0%
|
10−11
+0%
|
| Watch Dogs: Legion | 35−40
+0%
|
35−40
+0%
|
Full HD
High Preset
| Assassin's Creed Odyssey | 7−8
+0%
|
7−8
+0%
|
| Battlefield 5 | 1−2
+0%
|
1−2
+0%
|
| Call of Duty: Modern Warfare | 5−6
+0%
|
5−6
+0%
|
| Cyberpunk 2077 | 4−5
+0%
|
4−5
+0%
|
| Far Cry 5 | 3−4
+0%
|
3−4
+0%
|
| Far Cry New Dawn | 5−6
+0%
|
5−6
+0%
|
| Forza Horizon 4 | 8−9
+0%
|
8−9
+0%
|
| Hitman 3 | 7−8
+0%
|
7−8
+0%
|
| Horizon Zero Dawn | 18−20
+0%
|
18−20
+0%
|
| Red Dead Redemption 2 | 4−5
+0%
|
4−5
+0%
|
| Shadow of the Tomb Raider | 10−11
+0%
|
10−11
+0%
|
| The Witcher 3: Wild Hunt | 13
+0%
|
13
+0%
|
| Watch Dogs: Legion | 35−40
+0%
|
35−40
+0%
|
Full HD
Ultra Preset
| Assassin's Creed Odyssey | 7−8
+0%
|
7−8
+0%
|
| Call of Duty: Modern Warfare | 5−6
+0%
|
5−6
+0%
|
| Cyberpunk 2077 | 4−5
+0%
|
4−5
+0%
|
| Far Cry 5 | 3−4
+0%
|
3−4
+0%
|
| Forza Horizon 4 | 8−9
+0%
|
8−9
+0%
|
| Hitman 3 | 7−8
+0%
|
7−8
+0%
|
| Horizon Zero Dawn | 18−20
+0%
|
18−20
+0%
|
| Shadow of the Tomb Raider | 10−11
+0%
|
10−11
+0%
|
| The Witcher 3: Wild Hunt | 3
+0%
|
3
+0%
|
| Watch Dogs: Legion | 35−40
+0%
|
35−40
+0%
|
Full HD
Epic Preset
| Red Dead Redemption 2 | 4−5
+0%
|
4−5
+0%
|
1440p
High Preset
| Battlefield 5 | 3−4
+0%
|
3−4
+0%
|
| Far Cry New Dawn | 3−4
+0%
|
3−4
+0%
|
1440p
Ultra Preset
| Assassin's Creed Odyssey | 2−3
+0%
|
2−3
+0%
|
| Call of Duty: Modern Warfare | 1−2
+0%
|
1−2
+0%
|
| Cyberpunk 2077 | 1−2
+0%
|
1−2
+0%
|
| Far Cry 5 | 2−3
+0%
|
2−3
+0%
|
| Hitman 3 | 7−8
+0%
|
7−8
+0%
|
| Horizon Zero Dawn | 6−7
+0%
|
6−7
+0%
|
| The Witcher 3: Wild Hunt | 1−2
+0%
|
1−2
+0%
|
| Watch Dogs: Legion | 10−12
+0%
|
10−12
+0%
|
1440p
Epic Preset
| Red Dead Redemption 2 | 5−6
+0%
|
5−6
+0%
|
4K
High Preset
| Far Cry New Dawn | 1−2
+0%
|
1−2
+0%
|
4K
Ultra Preset
| Assassin's Creed Odyssey | 2−3
+0%
|
2−3
+0%
|
| Assassin's Creed Valhalla | 1−2
+0%
|
1−2
+0%
|
| Call of Duty: Modern Warfare | 0−1 | 0−1 |
| Far Cry 5 | 1−2
+0%
|
1−2
+0%
|
| Watch Dogs: Legion | 0−1 | 0−1 |
4K
Epic Preset
| Red Dead Redemption 2 | 3−4
+0%
|
3−4
+0%
|
Así compiten 8800 GT y HD Graphics 5600 en los juegos populares:
- HD Graphics 5600 es 71% más rápido en 1080p
En definitiva, en juegos populares:
- hay un empate en 53 pruebas (100%)
Resumen de pros y contras
| Clasificación de las prestaciones | 1.24 | 1.99 |
| Novedad | 29 de Octubre 2007 | 2 de Junio 2015 |
| El proceso tecnológico | 65 nm | 14 nm |
| El consumo de energia (TDP) | 125 Vatio | 15 Vatio |
HD Graphics 5600 tiene un 60.5% más de puntuación agregada de rendimiento, una ventaja de edad de 7 años, un proceso litográfico 364.3% más avanzado, y 733.3% menor consumo de energía.
El HD Graphics 5600 es nuestra opción recomendada, ya que supera al GeForce 8800 GT en las pruebas de rendimiento.
Tenga en cuenta que GeForce 8800 GT esta destinada para los ordenadores de sobremesa es HD Graphics 5600 - para portátiles.
Para cualquier duda sobre que elegir GeForce 8800 GT y HD Graphics 5600 deja tus preguntas en los Comentarios. Las responderemos lo antes posible.
Comparaciones con GPU similares
Hemos seleccionado varias comparaciones de tarjetas gráficas con un rendimiento más o menos cercano a las revisadas, lo que le proporciona más opciones probables a considerar.
Ошибка: Запрос 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=2926 and pop.lang="4" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=2926 and pop2.item2=i._id and pop2.lang="4" where b.benchmark_id=-1 and i.type="" and i.prof="0" and i._disabled=0 and ( if(pop.visits,pop.visits,pop2.visits)>=1 OR ( to_days(now()) - to_days(replace("2007-10-29","-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(1.24 - 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=2926 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2926 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2007-10-29","-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(1.24 - 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=2926 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2926 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2007-10-29","-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(1.24 - 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__0_2926_L4
[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=2926 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2926 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2007-10-29","-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(1.24 - 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=165 and pop.lang="4" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=165 and pop2.item2=i._id and pop2.lang="4" where b.benchmark_id=-1 and i.type="" and i.prof="0" and i._disabled=0 and ( if(pop.visits,pop.visits,pop2.visits)>=1 OR ( to_days(now()) - to_days(replace("2015-06-02","-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(1.99 - 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=165 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=165 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2015-06-02","-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(1.99 - 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=165 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=165 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2015-06-02","-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(1.99 - 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__0_165_L4
[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=165 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=165 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2015-06-02","-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(1.99 - 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=2926 and pop.lang="4" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=2926 and pop2.item2=i._id and pop2.lang="4" where b.benchmark_id=-1 and i.type="" and i.prof="0" and i._disabled=0 and ( if(pop.visits,pop.visits,pop2.visits)>=1 OR ( to_days(now()) - to_days(replace("2007-10-29","-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(1.24 - 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=2926 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2926 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2007-10-29","-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(1.24 - 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=2926 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2926 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2007-10-29","-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(1.24 - 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__0_2926_L4
[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=2926 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2926 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2007-10-29","-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(1.24 - 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
)
)
