---

Error No: 0 - MySQL error 3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'lumalme_arsluna_trgovina.pgd.sort' which is not in SELECT list; this is incompatible with DISTINCT
Query:
SELECT DISTINCT d.product_data_pk ,d.name data_name FROM web_artikli a ,web_artikli_data ad ,web_product_data d ,arsluna_product_data_group_data pgd ,web_product_data_group g WHERE a.artikli_pk = 40 AND ad.artikli_pk =a.artikli_pk AND d.product_data_pk = ad.product_data_pk AND d.product_data_pk_parent IS NULL AND NOT EXISTS (SELECT 1 FROM web_product_data d2 WHERE d2.product_data_pk_parent = d.product_data_pk) AND d.type = 13 AND d.visible > 0 AND pgd.product_data_group_pk = a.product_data_group_pk AND pgd.product_data_pk = d.product_data_pk AND g.product_data_group_pk = pgd.product_data_group_pk AND g.position = 1 ORDER BY COALESCE(pgd.sort, d.sort) ,d.id
#0 /home/lumalme/public_html/shop.lumal.me/app/classes/database.php(1403): MySQLDB->fMyQuery('SELECT\r\n ...')
#1 /home/lumalme/public_html/shop.lumal.me/app/content/ecommerce/class.ecommerce.product.data.php(2464): MySQLDB->query('SELECT\r\n ...')
#2 /home/lumalme/public_html/shop.lumal.me/app/content/ecommerce/class.ecommerce.product.data.php(2155): classEcommerceProductData->product_data_single_with_multiple_icons('40', 1)
#3 /home/lumalme/public_html/shop.lumal.me/app/content/widgets/ecommerce/product-detail/product-detail-030-03.php(119): classEcommerceProductData->pProductData('40', 1)
#4 /home/lumalme/public_html/shop.lumal.me/app/content/ecommerce/class.ecommerce.content.php(4581): require_once('/home/lumalme/p...')
#5 /home/lumalme/public_html/shop.lumal.me/app/content/class.content.php(718): clEcommerceContent->pPageProductDetails()
#6 /home/lumalme/public_html/shop.lumal.me/app/content/index.php(282): clContent->pPageContent()
#7 /home/lumalme/public_html/shop.lumal.me/app/content/index_switch.php(43): include('/home/lumalme/p...')
#8 /home/lumalme/public_html/shop.lumal.me/index.php(37): include('/home/lumalme/p...')
#9 {main}