SELECT * FROM product_class WHERE classCategory = 'hot-rolled' AND classStatus = 'A' ORDER BY classOrder ASC SELECT * FROM product_class WHERE classCategory = 'cold-finished' AND classStatus = 'A' ORDER BY classOrder ASC SELECT * FROM product_class WHERE classCategory = 'beams-angles' AND classStatus = 'A' ORDER BY classOrder ASC SELECT * FROM product_class WHERE classCategory = 'plate-grating' AND classStatus = 'A' ORDER BY classOrder ASC SELECT * FROM product_class WHERE classCategory = 'tubular' AND classStatus = 'A' ORDER BY classOrder ASC SELECT * FROM product_class WHERE classCategory = 'misc' AND classStatus = 'A' ORDER BY classOrder ASC