Заказать обратный звонок

Ваш город:


SELECT c1.id, c1.price, c1.html_code, c1.name, c1.kolvo, c1.tip, (SELECT IF(COUNT(*)>0,GROUP_CONCAT(s_struktura.id SEPARATOR ','),'') FROM s_struktura, s_cat_s_struktura WHERE s_cat_s_struktura.id2=s_struktura.id AND s_cat_s_struktura.id1=c1.id) AS struktura_id ,'' AS chk_sklad FROM s_cat AS c1 WHERE c1.name IN (SELECT c2.name FROM s_cat AS c2 WHERE c2.id='1315') AND c1.chk_active='1'