Categories
- Galvanized Steel Pipe (151)
- Galvanized Steel Coil (104)
- Tinplate (22)
- Seamless Steel Pipe (142)
- Roofing Sheet (29)
- Square Steel Pipe (42)
- Angle Steel Bar (103)
- Deformed Steel Bar (68)
- PPGI Coil (29)
- Spiral Steel Pipe (14)
- Welded Pipe (36)
- Rectangular Steel Pipe (24)
- API Steel Pipe (15)
- Steel Sheet (32)
- Galvanized Aluminum Coil (15)
- Cold Roll Steel (20)
- Stainless Steel (20)
- Galvanized Steel Nails (27)
- Steel Wire Rope (29)
- Scaffolding Accessories (16)
- Prefabricated House / Steel... (8)
1146 - Table 'segsteel.TABLE_PRODUCTS_TO_MANUFACTURERS' doesn't exist
SELECT ptm.manufacturers_id, COUNT(DISTINCT ptm.products_id) as pcount FROM TABLE_PRODUCTS_TO_MANUFACTURERS ptm JOIN products p ON ptm.products_id = p.products_id WHERE p.products_status = 1 GROUP BY ptm.manufacturers_id
[TEP STOP]
SELECT ptm.manufacturers_id, COUNT(DISTINCT ptm.products_id) as pcount FROM TABLE_PRODUCTS_TO_MANUFACTURERS ptm JOIN products p ON ptm.products_id = p.products_id WHERE p.products_status = 1 GROUP BY ptm.manufacturers_id
[TEP STOP]