No products have been entered for this category yet.
Please contact us directly to find out about these productsselect product.*, manufacturer.name man_name, manufacturer.website manwebsite, eq_cat.cat_id ecat_id, eq_cat.cat_name ecat_name, sub_cat.cat_id scat_id, sub_cat.cat_name scat_name from product left join manufacturer on product.man_id = manufacturer.man_id, prod_cat_res, category eq_cat left join category sub_cat on eq_cat.cat_id = sub_cat.super_cat_id where eq_cat.cat_id = '127' and ( ( product.product_id = prod_cat_res.product_id and prod_cat_res.cat_id = eq_cat.cat_id) or (product.product_id = prod_cat_res.product_id and prod_cat_res.cat_id = sub_cat.cat_id )) order by name, model_name