A Database Error Occurred

Error Number: 1052

Column 'created_date' in order clause is ambiguous

SELECT t1.name_tha as name, CONCAT(t1.url_alias,'-',t2.sku_id,'.html') as alias, t1.description_tha as description, t5.is_delete, t5.is_enable , t3.image_url, t2.price, t2.sale_price, t1.product_id, t1.review_score , t1.is_sales, t1.is_new, t1.is_best, t1.product_id, t2.quantity FROM `tb_seller_product_completed` t1 LEFT JOIN ( SELECT MIN(seller_sku) as seller_sku,product_id FROM `tb_seller_product_price` WHERE sale_start_date <= '2024-03-28' AND sale_end_date >= '2024-03-28' AND `review_status` = 'A' GROUP BY product_id ) tmp2 ON t1.product_id = tmp2.product_id LEFT JOIN `tb_seller_product_price` t2 ON tmp2.seller_sku = t2.seller_sku LEFT JOIN `tb_seller_product_image` t3 ON t1.product_id = t3.product_id LEFT JOIN `tb_product_brand` t4 ON t1.brand_id = t4.brand_id LEFT JOIN `tb_seller` t5 ON t1.seller_id = t5.seller_id WHERE t1.is_enable = 1 AND t1.is_delete = 0 AND t5.is_delete = 0 AND t5.is_enable = 1 AND t3.order_no = 1 AND t3.is_approve = 1 AND t2.sale_start_date <= '2024-03-28' AND t2.sale_end_date >= '2024-03-28' AND t4.url_alias = 'Fourteen' GROUP BY t1.product_id ORDER BY created_date DESC

Filename: /home/aplay/web/aplayshopping.com/public_html/models/product_model.php

Line Number: 789