O`Green AG1688.25R16
|
|
Характеристики
Базовые характеристики
Другие размеры модели O`Green AG168 в Уссурийске
|
|
O`Green AG168 | |
|
|
O`Green AG168 | |
|
|
O`Green AG168 | |
|
|
O`Green AG168 | |
|
|
O`Green AG168 |
MySQL server has gone away, query:
SELECT
DISTINCT
(SELECT COUNT(*) FROM `study` WHERE mark=c.brand AND model=c.marking AND `size`= CONCAT (s.sizestr,'R',s.d) AND `side`=2) isstatistics,
(
SELECT COUNT(*) FROM dataarden.`study_data` sd
LEFT JOIN dataarden.`study` st ON st.id=sd.study_id
WHERE sd.status=2 AND sd.brand_id=cat.`brand_id` AND sd.model_id=cat.`id_model` AND sd.`d`=s.d AND sd.`sizestr`=s.`sizestr` AND st.`side`=2) indata_,
cat.*,
c.type_fit,
c.name,
c.image1,
c.image2,
c.image3,
c.image4,
c.image5,
c.image6,
c.rate,
c.rate2,
c.brand,
c.marking,
c.drive drive_,
c.front front_,
c.free free_,
c.town town_,
c.regional regional_,
c.magistral magistral_,
c.universal universal_,
c.offroad offroad_,
c.bus bus_,
c.truck truck_,
c.trailer trailer_,
c.specteh specteh_,
c.selhoz selhoz_,
(
SELECT COUNT(*) FROM `catalog_price`
WHERE id_good IN ( SELECT id FROM `catalog` c1 WHERE id_group=c.id AND id IN (SELECT id_good FROM `catalog_sizes` WHERE w='210' )
AND (SELECT SUM(avail) FROM `catalog_deposits` WHERE id_good=c1.id AND id_shop IN ( SELECT id FROM catalog_shops WHERE `id_city`=821 ))>0
) AND id_shop IN ( SELECT id FROM catalog_shops WHERE `id_city`=821 ) AND id_discount_group=1
) total,
(
SELECT MIN(price) FROM `catalog_price`
WHERE price > 0 AND
(
id_good IN ( SELECT id FROM `catalog` WHERE id_group=c.id AND id IN (SELECT id_good FROM `catalog_sizes` WHERE w='210' ) )
AND id_good IN (SELECT id_good FROM `catalog_deposits` WHERE avail>0 AND id_shop IN ( SELECT id FROM catalog_shops WHERE `id_city`=821 AND is_show=1 ))
)
AND id_shop IN ( SELECT id FROM catalog_shops WHERE `id_city`=821 AND is_show=1 ) AND id_discount_group=1
) minimalprie,
(SELECT SUM(avail) FROM `catalog_deposits` WHERE id_size=s.id AND id_good=cat.id AND id_shop IN ( SELECT id FROM catalog_shops WHERE `id_city`=821 )) av,
cp.oldprice,
cat.id idgood,
cp.price,
s.id idsize,
s.w,
s.h,
s.d,
s.sizestr
FROM `catalog` cat
LEFT JOIN `catalog_groups` c ON cat.id_group=c.id
LEFT JOIN `catalog_price` cp ON cp.id_good=cat.id
LEFT JOIN `catalog_sizes` s ON s.id_good=cat.id
WHERE
(c.image1!='' OR c.image2!='' OR c.image3!='') AND
c.is_delete=0 AND c.view=1
AND cp.price>0 AND cp. id_shop IN ( SELECT id FROM catalog_shops WHERE `id_city`=821 AND is_show=1 )
AND cp.id_discount_group=1
AND (SELECT SUM(avail) FROM `catalog_deposits` WHERE id_size=s.id AND id_good=cat.id AND id_shop IN ( SELECT id FROM catalog_shops WHERE `id_city`=821 ))>0
AND c.typeitem=1 AND s.w='210' AND cat.id !=4803 ORDER BY c.name,c.id LIMIT 3