Query ErrorSELECT a.id,a.name,a.alias,a.category_alias, a.category_id,a.category_id_wrapper,a.image,a.price,a.price_old,a.is_new,a.alias,a.discount,a.is_installment,a.is_gift,a.text_sale,a.products_same,a.status_prd,a.promotion_start_time,a.promotion_end_time,a.tablename,a.image_land,a.product_set,a.sale_brief,
                    b.discount AS discount_sale, b.discount_unit AS discount_unit_sale,
                    b.total, b.ordered, b.date_end AS sale_date_end,
                    CASE WHEN b.product_id IS NOT NULL THEN 1 ELSE 0 END AS is_on_flash_sale
     	FROM fs_products as a
                   
        LEFT JOIN fs_flash_sale_detail AS b
        ON a.id = b.product_id
        AND b.published = 1
        AND b.date_end >= '2025-12-08 03:13:41'
     WHERE (a.published = 1 AND a.status_prd < 4 
                      and ( a.category_id_wrapper like '%,39,%' or a.multi_categories like '%,39,%'  )     )  ORDER BY ordering , ABS(price) ASC  LIMIT 0,25 <hr/>Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'ordering' in order clause is ambiguous
)