SELECT p.id, p.titolo, p.alias, p.lingua, p.webcode, p.main_image, p.list_image, p.meta_title, p.meta_description, p.meta_keywords
FROM #__products AS p
LEFT JOIN #__products_categories_map AS pcm ON pcm.webcode = p.webcode AND pcm.lang = p.lingua
LEFT JOIN #__products_categories AS pc ON pcm.category = pc.id
WHERE p.lingua = 'es-ES' AND p.published = 1
GROUP BY p.id
ORDER BY p.ordering ASC