Products
- Cartridge Heaters-Lead Configurations, Exits, Mounting Styles and Lead Protection Options
- Bolt Cartridge Heaters
- Small Diameter Miniature Pencil Heaters
- Square Cartridge Heaters
- Split Sheath Cartridge Heaters
- Heat Calculations Watt Density Cartridge Heaters 2
- Tolerances-Cartridge Heaters
- More Products ...
-
select i.* , ii.image_name FROM items AS i JOIN items_to_categories AS i2c ON ( i2c.items_id = i.id ) LEFT JOIN items_images AS ii ON ( ii.items_id = i.id AND primary_img = '1' ) WHERE i2c.categories_id = 4 AND i.status_product_page = '1' GROUP BY i.id order by i.sort_order ASC
[TEP STOP]
select i.* , ii.image_name FROM items AS i JOIN items_to_categories AS i2c ON ( i2c.items_id = i.id ) LEFT JOIN items_images AS ii ON ( ii.items_id = i.id AND primary_img = '1' ) WHERE i2c.categories_id = 4 AND i.status_product_page = '1' GROUP BY i.id order by i.sort_order ASC
[TEP STOP]