SELECT trid AS value, CONCAT('[', t.language_code, '] ', (CASE p.post_title WHEN '' THEN CONCAT(LEFT(p.post_content, 30), '...') ELSE p.post_title END)) AS label
FROM wp_corr_posts p
INNER JOIN wp_corr_icl_translations t
ON p.ID = t.element_id
WHERE t.element_type = 'post_post'
SELECT trid AS value, CONCAT('[', t.language_code, '] ', (CASE p.post_title WHEN '' THEN CONCAT(LEFT(p.post_content, 30), '...') ELSE p.post_title END)) AS label
FROM wp_corr_posts p
INNER JOIN wp_icl_translations t
ON p.ID = t.element_id
WHERE t.element_type = 'post_post'