select * from products_to_categories p2c, products p where p.products_id=p2c.products_id and p2c.categories_id='723' and p.products_status='1'