Грузовые шины в Хабаровске

SELECT command denied to user 'arden_usr'@'localhost' for table 'study_data', 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 (SELECT SUM(avail) FROM `catalog_deposits` WHERE id_good=c1.id AND id_shop IN ( SELECT id FROM catalog_shops WHERE `id_city`=1177 ))>0 ) AND id_shop IN ( SELECT id FROM catalog_shops WHERE `id_city`=1177 ) 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_good IN ( SELECT id_good FROM `catalog_deposits` WHERE avail>0 AND id_shop IN ( SELECT id FROM catalog_shops WHERE `id_city`=1177 AND is_show=1 )) ) AND id_shop IN ( SELECT id FROM catalog_shops WHERE `id_city`=1177 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`=1177 )) 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`=1177 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`=1177 ))>0 AND c.id IN ( SELECT DISTINCT `id_group` FROM `catalog` WHERE `type`=1) ORDER BY cp.id LIMIT 0,24

Выбранные товары	Цена	Количество	Удалить	Стоимость
В связи с переходом на систему «Честный Знак», отгрузка товара производится в течении 3-х рабочих дней с момента оплаты.	Итого:	руб.

Грузовые шины в Хабаровске

Контакты

Информация

Вакансии

Контакты

Марки