SELECT * FROM tbm_product as p, tbm_product_categories as c, tbm_product_manufactures as m WHERE 1 AND p.cat_id = c.cat_id AND p.manuf_id = m.manuf_id AND p.pro_id = AND p.pro_status = '1'