SELECT a.product_id+10000 AS id,a.product_name AS name,b.category_id AS parent,c.product_price AS price FROM #__vm_product As a INNER JOIN #__vm_product_category_xref As b ON a.product_id=b.product_id LEFT JOIN #__vm_product_price AS c ON a.product_id=c.product_id GROUP BY (a.product_id) ORDER BY product_name COLLATE utf8_polish_ci ASC
i wszystko fajnie tylko jak mam produkty typu
rabat100E
rabat200E
rabat1000E
to mi mysql wyrzuca rabat1000E na sam początek a wolałbym na sam koniec
zna ktoś jakieś rozwiązanie co do tego problemu?