Topic: left ir count
SELECT im.id_image,
COUNT(b.id_block) AS count_p
FROM product p
LEFT JOIN image im ON im.cover = 1
LEFT JOIN blocks b ON p.id_product = b.id_block
Sveiki,
kodel man atvaizduoja tik tuos produktus, kuriu kiekis daugiau nei 0.