select * from products p left join products_in_categories c on c.p_id=p.id where 1 and p.active=1 and p.n24=1 and p.producer=17 and c.c_id in (380,381,382,383,384,385,386) group by p.id order by SIGN(quantity) desc, field (c.c_id, 380,381,382,383,384,385,386), p.name_2 limit 0,12
ECU's LPG - Other LPG ELPIGAZ | LPG / CNG Supplier N...
