Посмотреть все товары

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 = 'ru-RU' AND p.published = 1 GROUP BY p.id ORDER BY p.ordering ASC