WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
GROUP BY T1.ID
ORDER BY CAST(REPLACE(REPLACE(T2.meta_value,'.',''),','' at line 10]
SELECT ID, T2.meta_value as price
FROM lvcorp_posts AS T1
LEFT JOIN lvcorp_postmeta AS T2 ON T1.ID = T2.post_id
LEFT JOIN lvcorp_term_relationships AS T3 ON T1.ID = T3.object_id
LEFT JOIN lvcorp_terms AS T4 ON T3.term_taxonomy_id = T4.term_id
WHERE 1 = 1
AND T1.post_type = 'tour'
AND (T1.post_status = 'publish' or T1.post_status = 'private')
AND T2.meta_key = 'gia_tour'
AND T4.term_id IN ()
GROUP BY T1.ID
ORDER BY CAST(REPLACE(REPLACE(T2.meta_value,'.',''),',','') AS DECIMAL) ASC, price DESC