Catched error 40642000: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND tb.active = '1' GROUP BY tb.id  ORDER BY tb.`sort` ASC,tb.id DESC' at line 14
in /home/immagine/immagine.com.ua/www/protected/classes/DataBase.php on line 71.
Query: 'SELECT tb.id,tb.url,tb.brend_id,tb.photo,tb.colors,tb_lang.name,tb_price.id as price_id,tb_price.price as price,GROUP_CONCAT('', tb_price.price_type_id) as price_type_id,tb_price.basePrice,tb_price.discount,tb_price.stock,tb_price.unit,GROUP_CONCAT(DISTINCT params_lang.name ORDER BY params_lang.name ASC SEPARATOR ',') AS sizes,
GROUP_CONCAT(DISTINCT tbpss.status_id SEPARATOR '|') AS statuses,
brend.name AS brend,
tb_price.price-tb_price.price*(tb_price.discount/100) AS price_sort,
tb_lang.body_m,tb_lang.body2,tb_lang.body4,
tb4.status_id,
tb5.name AS status FROM `product` `tb` LEFT JOIN `ru_product` tb_lang ON tb.id=tb_lang.product_id  LEFT JOIN product_status_set tb4 ON tb4.product_id=tb.id
LEFT JOIN product_status_set tbpss ON tbpss.product_id=tb.id
LEFT JOIN ru_product_status tb5 ON tb4.status_id=tb5.product_status_id
LEFT JOIN ru_brend brend ON brend.brend_id=tb.brend_id
LEFT JOIN params_product ON params_product.product_id=tb.id
LEFT JOIN params ON params.id=params_product.params_id AND params.sub='77'
LEFT JOIN ru_params params_lang ON params_lang.params_id=params.id
LEFT JOIN `price` tb_price ON `tb_price`.product_id=tb.id AND tb_price.price_type_id='1' WHERE tb.id!='0'  AND tb.id IN () AND tb.active = '1' GROUP BY tb.id  ORDER BY tb.`sort` ASC,tb.id DESC '
Catched error 40642000: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND tb.active = '1' GROUP BY tb.id  ORDER BY tb.`sort` ASC,tb.id DESC LIMIT 0,' at line 14
in /home/immagine/immagine.com.ua/www/protected/classes/DataBase.php on line 72.
Query: 'SELECT tb.id,tb.url,tb.brend_id,tb.photo,tb.colors,tb_lang.name,tb_price.id as price_id,tb_price.price as price,GROUP_CONCAT('', tb_price.price_type_id) as price_type_id,tb_price.basePrice,tb_price.discount,tb_price.stock,tb_price.unit,GROUP_CONCAT(DISTINCT params_lang.name ORDER BY params_lang.name ASC SEPARATOR ',') AS sizes,
GROUP_CONCAT(DISTINCT tbpss.status_id SEPARATOR '|') AS statuses,
brend.name AS brend,
tb_price.price-tb_price.price*(tb_price.discount/100) AS price_sort,
tb_lang.body_m,tb_lang.body2,tb_lang.body4,
tb4.status_id,
tb5.name AS status FROM `product` `tb` LEFT JOIN `ru_product` tb_lang ON tb.id=tb_lang.product_id  LEFT JOIN product_status_set tb4 ON tb4.product_id=tb.id
LEFT JOIN product_status_set tbpss ON tbpss.product_id=tb.id
LEFT JOIN ru_product_status tb5 ON tb4.status_id=tb5.product_status_id
LEFT JOIN ru_brend brend ON brend.brend_id=tb.brend_id
LEFT JOIN params_product ON params_product.product_id=tb.id
LEFT JOIN params ON params.id=params_product.params_id AND params.sub='77'
LEFT JOIN ru_params params_lang ON params_lang.params_id=params.id
LEFT JOIN `price` tb_price ON `tb_price`.product_id=tb.id AND tb_price.price_type_id='1' WHERE tb.id!='0'  AND tb.id IN () AND tb.active = '1' GROUP BY tb.id  ORDER BY tb.`sort` ASC,tb.id DESC LIMIT 0,60'
Immagine - женская одежда опт и розница Скидки!