select pd.*,p.products_price,p.products_image,c.categories_id,c.parent_id,p2c.categories_type_id,cd.categories_name from products_description pd,products p, products_to_categories p2c,categories c,categories_description cd where pd.products_id='57' and pd.products_id=p2c.products_id and pd.products_id=p.products_id and p2c.categories_id=c.categories_id and pd.language_id='1' and cd.categories_id=c.categories_id and p2c.categories_type_id=2 and cd.language_id=1