
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 (796) group by p.id order by SIGN(quantity) desc, field (c.c_id, 796), p.name_2 limit 0,12
Type of connect: | pins |
---|---|
Coil wattage: | 17 W |
Type of part: | original |
For electrovalve: | ELPIGAZ |
product code: | 55.LRE.906 |
---|---|
manufacturer: | ELPIGAZ |
manufacturer code: | 240005301 |
approval number: | E13-67R-010233 |