SELECT
p.id,
p.price,
f.id AS foto,
f.width,
f.height,
fl.name
FROM
`shop_products` AS p
LEFT JOIN `shop_table_photo` AS tf ON p.id=tf.shop_products_id
LEFT JOIN `shop_photo` AS f ON tf.id=f.table_photo_id
LEFT JOIN `shop_photo_lang` AS fl ON f.id=fl.photo_id AND fl.lang='1'
WHERE
p.id REGEXP ''
GROUP BY p.id
Metráž šíře 80cm
english
