WordPress database error: [Unknown column 'tb.is_featured' in 'order clause']SELECT SQL_CALC_FOUND_ROWS kur_posts.*,CASE
WHEN tb.is_sale_schedule = 'on'
AND tb.discount != 0 AND tb.discount != ''
AND tb.sale_price_from <= CURDATE() AND tb.sale_price_to >= CURDATE()
THEN
CAST(tb.cars_price AS DECIMAL) - ( CAST(tb.cars_price AS DECIMAL) / 100 ) * CAST(tb.discount AS DECIMAL)
WHEN tb.is_sale_schedule != 'on' AND tb.discount != 0 AND tb.discount != ''
THEN
CAST(tb.cars_price AS DECIMAL) - ( CAST(tb.cars_price AS DECIMAL) / 100 ) * CAST(tb.discount AS DECIMAL)
ELSE tb.cars_price
END AS st_cars_price FROM kur_posts LEFT JOIN kur_postmeta ON ( kur_posts.ID = kur_postmeta.post_id ) LEFT JOIN kur_postmeta AS mt1 ON (kur_posts.ID = mt1.post_id AND mt1.meta_key = 'car_type' ) LEFT JOIN kur_postmeta AS mt2 ON ( kur_posts.ID = mt2.post_id ) INNER JOIN kur_st_cars as tb ON kur_posts.ID = tb.post_id INNER JOIN kur_postmeta as tb_postmeta ON kur_posts.ID = tb_postmeta.post_id WHERE 1=1 AND (
( kur_postmeta.meta_key = 'number_car' AND kur_postmeta.meta_value > '0' )
AND
(
mt1.post_id IS NULL
OR
( mt2.meta_key = 'car_type' AND mt2.meta_value = 'normal' )
)
) AND kur_posts.post_type = 'st_cars' AND ((kur_posts.post_status = 'publish')) AND tb_postmeta.meta_key = 'car_type' AND tb_postmeta.meta_value = 'normal' GROUP BY kur_posts.ID ORDER BY tb.is_featured desc LIMIT 0, 5
Thoughtful thoughts to your inbox
