Greška na bazi je nastupila

Error Number: 1052

Column 'name' in order clause is ambiguous

SELECT `pcms_mdlshop_products`.`id` FROM (`pcms_mdlshop_products_variants`) LEFT JOIN `pcms_mdlshop_products` ON `pcms_mdlshop_products_variants`.`product_id`=`pcms_mdlshop_products`.`id` WHERE `pcms_mdlshop_products_variants`.`price` > 201 AND `pcms_mdlshop_products_variants`.`price` <= 500 AND `pcms_mdlshop_products`.`disabled` = 0 GROUP BY `pcms_mdlshop_products_variants`.`product_id` ORDER BY name asc