ID BIGINT UNSIGNED,

post_title MEDIUMTEXT

);

INSERT INTO wp_posts(ID, post_title) VALUES (897, 'Lavender');

INSERT INTO wp_posts(ID, post_title) VALUES (899, 'Prince White Download');

INSERT INTO wp_posts(ID, post_title) VALUES (902, 'test');

INSERT INTO wp_posts(ID, post_title) VALUES (1019, 'تست');

INSERT INTO wp_posts(ID, post_title) VALUES (1034, 'kk');

INSERT INTO wp_posts(ID, post_title) VALUES (1035, 'کک');

(

element_id bigint null,

trid bigint not null,

language_code varchar(7) not null,

source_language_code varchar(7) null

)

collate = utf8mb4_unicode_520_ci;

INSERT INTO wp_icl_translations (element_id, trid, language_code, source_language_code) VALUES (897, 897, 'en', null);

INSERT INTO wp_icl_translations (element_id, trid, language_code, source_language_code) VALUES (899, 899, 'en', null);

INSERT INTO wp_icl_translations (element_id, trid, language_code, source_language_code) VALUES (902, 902, 'en', null);

INSERT INTO wp_icl_translations (element_id, trid, language_code, source_language_code) VALUES (1019, 902, 'fa', 'en');

INSERT INTO wp_icl_translations (element_id, trid, language_code, source_language_code) VALUES (1034, 2844, 'en', null);

INSERT INTO wp_icl_translations (element_id, trid, language_code, source_language_code) VALUES (1035, 2844, 'fa', 'en');

select * from wp_icl_translations;

FROM wp_icl_translations t1

JOIN wp_posts p1 ON t1.element_id = p1.id

LEFT JOIN wp_icl_translations t2 ON t1.trid = t2.trid AND t2.language_code = 'fa'

LEFT JOIN wp_posts p2 ON t2.element_id = p2.id

WHERE t1.language_code = 'en'

ORDER BY id