|
0.4389 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_wpml_inactive' LIMIT 1;
|
|
2.0580 [ms]
|
SELECT option_value
FROM wp_options
WHERE option_name = 'home'
LIMIT 1;
|
|
0.2820 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'active_sitewide_plugins' LIMIT 1;
|
|
0.7110 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'updraft_restore_in_progress' LIMIT 1;
|
|
0.0970 [ms]
|
SELECT code, locale FROM wp_icl_locale_map;
|
|
0.3829 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'WpFastestCacheCDN' LIMIT 1;
|
|
0.1690 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'WpFastestCacheExclude' LIMIT 1;
|
|
0.2351 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;
|
|
0.3161 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'redirection_database_stage' LIMIT 1;
|
|
0.1380 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'revslider_change_database' LIMIT 1;
|
|
0.7041 [ms]
|
SHOW FULL COLUMNS FROM `wp_options`;
|
|
0.2081 [ms]
|
UPDATE `wp_options` SET `option_value` = '1' WHERE `option_name` = 'rs_tables_created';
|
|
0.1638 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpforms_settings' LIMIT 1;
|
|
0.4539 [ms]
|
SELECT option_name, option_value FROM wp_options WHERE option_name LIKE 'widget\_%';
|
|
1.0459 [ms]
|
SELECT DISTINCT
s.id,
s.name,
s.context,
st.status,
s.gettext_context,
st.value AS tra,
s.value AS orig
FROM wp_icl_string_pages sp
INNER JOIN wp_icl_string_urls su
ON su.id = sp.url_id
INNER JOIN wp_icl_strings s
ON s.id = sp.string_id
LEFT JOIN wp_icl_string_translations st
ON s.id=st.string_id
AND st.language=su.language
AND s.language!=su.language
WHERE (su.language='en' and su.url='(.?.+?)(?:/([0-9]+))?/?$') or (su.language='en' and su.url IS NULL)
;
|
|
0.0949 [ms]
|
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('nav_menu') ORDER BY t.name
ASC ;
|
|
0.0460 [ms]
|
SELECT term_id, meta_key, meta_value FROM wp_termmeta WHERE term_id IN (3,5) ORDER BY meta_id ASC;
|
|
0.0529 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM wp_icl_translations t
JOIN wp_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN wp_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM wp_icl_translations t
JOIN wp_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 3 LIMIT 1);
|
|
0.0470 [ms]
|
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.term_taxonomy_id = 5 LIMIT 1;
|
|
0.7770 [ms]
|
SHOW COLUMNS FROM wp_revslider_sliders LIKE 'type';
|
|
0.0930 [ms]
|
SELECT * FROM wp_revslider_sliders WHERE type != 'template' ORDER BY title ASC;
|
|
0.0460 [ms]
|
SELECT * FROM wp_layerslider WHERE flag_hidden = '0' AND flag_deleted = '0' ORDER BY name ASC;
|
|
0.2661 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'revSliderAsTheme' LIMIT 1;
|
|
0.3979 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wpml_language_switcher_template_objects' LIMIT 1;
|
|
0.1872 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_wpml_language_switcher_template_objects' LIMIT 1;
|
|
0.2460 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpseo-premium-redirects-base' LIMIT 1;
|
|
0.1929 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'can_compress_scripts' LIMIT 1;
|
|
5.9168 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpforms_debug' LIMIT 1;
|
|
0.1450 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpb_js_less_version' LIMIT 1;
|
|
0.4601 [ms]
|
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN wp_icl_translations icl_t
ON icl_t.element_id = tt.term_taxonomy_id
AND icl_t.element_type IN ('tax_category') WHERE tt.taxonomy IN ('category') AND ( ( icl_t.element_type IN
('tax_category') AND icl_t.language_code = 'en' )
OR icl_t.element_type NOT IN ('tax_category') OR icl_t.element_type IS NULL ) ORDER BY t.name ASC ;
|
|
0.0479 [ms]
|
SELECT term_id, meta_key, meta_value FROM wp_termmeta WHERE term_id IN (6,2) ORDER BY meta_id ASC;
|
|
0.9050 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM wp_icl_translations t
JOIN wp_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN wp_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM wp_icl_translations t
JOIN wp_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE element_id = 6 LIMIT 1);
|
|
0.2189 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'vc_automapped_shortcodes' LIMIT 1;
|
|
0.0741 [ms]
|
SELECT a.action_id FROM wp_actionscheduler_actions a WHERE a.hook='wpforms_process_entry_emails_meta_cleanup' AND a.status='in-progress' ORDER BY
scheduled_date_gmt DESC LIMIT 1;
|
|
0.0441 [ms]
|
SELECT a.action_id FROM wp_actionscheduler_actions a WHERE a.hook='wpforms_process_entry_emails_meta_cleanup' AND a.status='pending' ORDER BY
scheduled_date_gmt ASC LIMIT 1;
|
|
0.0520 [ms]
|
SELECT a.*, g.slug AS `group` FROM wp_actionscheduler_actions a LEFT JOIN wp_actionscheduler_groups g ON a.group_id=g.group_id WHERE a.action_id=3410;
|
|
0.0911 [ms]
|
SELECT * FROM wp_redirection_items WHERE match_url='/en/activity' OR match_url='regex';
|
|
0.1121 [ms]
|
SELECT * FROM wp_users WHERE ID = '1' LIMIT 1;
|
|
0.0811 [ms]
|
SELECT ID, post_name, post_parent, post_type
FROM wp_posts
WHERE post_name IN ('activity')
AND post_type IN ('page','attachment')
;
|
|
0.3958 [ms]
|
SELECT * FROM wp_posts WHERE ID = 1115 LIMIT 1;
|
|
0.0510 [ms]
|
SELECT element_id, language_code
FROM wp_icl_translations
WHERE trid =
(SELECT trid
FROM wp_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM wp_options
WHERE option_name='page_for_posts'
LIMIT 1))
;
|
|
0.0541 [ms]
|
SELECT post_type, post_name
FROM wp_posts p
LEFT JOIN wp_icl_translations t
ON t.element_id = p.ID
AND CONCAT('post_', p.post_type) = t.element_type
AND p.post_type IN ('post','page','wp_block','slide' )
WHERE post_name = 'activity' AND post_type IN ('post', 'page', 'attachment', 'uig_image', 'slide')
AND ( post_status = 'publish'
OR ( post_type = 'attachment'
AND post_status = 'inherit' ) )
ORDER BY CASE t.language_code WHEN 'en' THEN 3 WHEN 'th' THEN 1 ELSE 0 END DESC , CASE p.post_type WHEN 'page' THEN 2 WHEN 'post'
THEN 1 ELSE 0 END DESC
LIMIT 1;
|
|
0.0460 [ms]
|
SELECT ID
FROM wp_posts p
JOIN wp_icl_translations t
ON p.ID = t.element_id
AND t.element_type = CONCAT('post_', p.post_type ) WHERE p.post_type = 'page' AND p.post_name = 'activity'
ORDER BY p.post_parent = 0 DESC
;
|
|
0.0460 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN wp_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 1115 LIMIT 1);
|
|
0.0391 [ms]
|
SELECT ID
FROM wp_posts p
JOIN wp_icl_translations t
ON p.ID = t.element_id
AND t.element_type = CONCAT('post_', p.post_type ) WHERE p.post_type = 'page' AND p.post_name = 'activity'
ORDER BY p.post_parent = 0 DESC
;
|
|
0.0441 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1115) ORDER BY meta_id ASC;
|
|
0.0570 [ms]
|
SELECT wp_posts.* FROM wp_posts JOIN wp_icl_translations t
ON wp_posts.ID = t.element_id
AND t.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND (wp_posts.ID = '1115') AND wp_posts.post_type = 'page' AND ( (
t.language_code = 'en' AND wp_posts.post_type IN ('post','page','wp_block','slide' ) ) OR wp_posts.post_type NOT IN
('post','page','wp_block','slide' ) ) ORDER BY wp_posts.post_date DESC ;
|
|
0.0510 [ms]
|
SELECT element_id, language_code
FROM wp_icl_translations
WHERE trid =
(SELECT trid
FROM wp_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM wp_options
WHERE option_name='page_on_front'
LIMIT 1))
;
|
|
1.3368 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpb_js_use_custom' LIMIT 1;
|
|
0.2661 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls_conditional_script_loading' LIMIT 1;
|
|
0.1330 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls_include_at_footer' LIMIT 1;
|
|
0.1311 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls_use_custom_jquery' LIMIT 1;
|
|
0.1550 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'layerslider_custom_capability' LIMIT 1;
|
|
0.1271 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls_gsap_sandboxing' LIMIT 1;
|
|
0.1261 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls-google-fonts' LIMIT 1;
|
|
0.1242 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'ls-google-font-scripts' LIMIT 1;
|
|
0.1500 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'revslider-static-css' LIMIT 1;
|
|
0.4742 [ms]
|
SELECT t.translation_id, t.language_code, t.element_id, t.source_language_code, t.element_type, NULLIF(t.source_language_code, '') IS NULL AS
original
, p.post_title, p.post_status
FROM wp_icl_translations t
LEFT JOIN wp_posts p ON t.element_id=p.ID
WHERE 1 AND ( p.post_status = 'publish' OR p.post_status = 'pending' ) AND t.trid=243
;
|
|
0.5989 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN wp_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 142 LIMIT 1);
|
|
0.0660 [ms]
|
SELECT * FROM wp_users WHERE ID = '6' LIMIT 1;
|
|
0.0682 [ms]
|
SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (6) ORDER BY umeta_id ASC;
|
|
0.0629 [ms]
|
SELECT code, tag FROM wp_icl_languages;
|
|
0.0811 [ms]
|
SELECT * FROM wp_posts WHERE ID = 854 LIMIT 1;
|
|
0.0498 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (854) ORDER BY meta_id ASC;
|
|
0.4699 [ms]
|
SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') AND post_parent = 1115 ORDER BY wp_posts.post_title ASC LIMIT 0,1;
|
|
0.1578 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wpb_js_not_responsive_css' LIMIT 1;
|
|
0.1731 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_otgs_twig_cache_disabled' LIMIT 1;
|
|
0.0758 [ms]
|
SELECT ID FROM wp_posts WHERE guid='http://maipromthai.com/wp-content/uploads/2017/07/logo-new-2.svg';;
|
|
0.0720 [ms]
|
SELECT * FROM wp_posts WHERE ID = 476 LIMIT 1;
|
|
0.0470 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (476) ORDER BY meta_id ASC;
|
|
0.0560 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN wp_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 476 LIMIT 1);
|
|
0.7980 [ms]
|
SHOW FULL COLUMNS FROM `wp_posts`;
|
|
0.0520 [ms]
|
SELECT ID FROM wp_posts WHERE guid='http://maipromthai.com/wp-content/uploads/2017/07/logo-new-02-แก้ไข-01.svg';;
|
|
0.0620 [ms]
|
SELECT * FROM wp_posts WHERE ID = 478 LIMIT 1;
|
|
0.0679 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (478) ORDER BY meta_id ASC;
|
|
0.0560 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN wp_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 478 LIMIT 1);
|
|
0.0529 [ms]
|
SELECT ID FROM wp_posts WHERE guid='http://maipromthai.com/wp-content/uploads/2017/07/logo-new-2.svg';;
|
|
0.0510 [ms]
|
SELECT ID FROM wp_posts WHERE guid='http://maipromthai.com/wp-content/uploads/2017/07/logo-new-2.svg';;
|
|
0.0510 [ms]
|
SELECT t.element_id, tax.term_id, tax.taxonomy
FROM wp_icl_translations t
JOIN wp_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN wp_terms terms
ON terms.term_id = tax.term_id
WHERE tax.term_id != tax.term_taxonomy_id;
|
|
0.4220 [ms]
|
SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy
IN ('nav_menu') AND tt.term_id IN ('5') ORDER BY tr.object_id ASC;
|
|
0.6309 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN wp_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.element_id IN (154,155,156,219,405,834,835,836,965,1121);
|
|
0.6030 [ms]
|
SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (154,155,156,219,405,834,835,836,965,1121) AND wp_posts.post_type = 'nav_menu_item'
AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.menu_order ASC ;
|
|
0.7930 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (154,155,1121,219,405,834,835,836,965,156) ORDER BY meta_id ASC;
|
|
0.5870 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN wp_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.element_id IN (148,217,399,577,561,429,961,152);
|
|
0.3901 [ms]
|
SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (142,148,1115,217,399,577,561,429,961,152) AND wp_posts.post_type = 'page' AND
((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC ;
|
|
1.4861 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (961,577,561,429,399,217,152,148,142) ORDER BY meta_id ASC;
|
|
0.5710 [ms]
|
SELECT t.translation_id, t.language_code, t.element_id, t.source_language_code, t.element_type, NULLIF(t.source_language_code, '') IS NULL AS
original
, tm.name, tm.term_id, COUNT(tr.object_id) AS instances
FROM wp_icl_translations t
LEFT JOIN wp_term_taxonomy tt ON t.element_id=tt.term_taxonomy_id
LEFT JOIN wp_terms tm ON tt.term_id = tm.term_id
LEFT JOIN wp_term_relationships tr ON tr.term_taxonomy_id=tt.term_taxonomy_id
WHERE 1 AND t.trid=140
GROUP BY tm.term_id
;
|
|
0.2940 [ms]
|
SELECT wp_posts.* FROM wp_posts WHERE ID IN (1116,1117,1118);
|
|
1.2670 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1116,1117,1118) ORDER BY meta_id ASC;
|
|
0.0601 [ms]
|
SELECT COUNT(id) FROM wp_icl_strings WHERE context = 'Widgets';
|
|
13.3600 [ms]
|
SELECT
s.id,
st.status,
s.domain_name_context_md5 AS ctx ,
st.value AS translated,
s.value AS original,
s.gettext_context
FROM wp_icl_strings s
LEFT JOIN wp_icl_string_translations st
ON s.id=st.string_id
AND st.language='en'
AND s.language!='en'
WHERE s.context = 'Widgets'
LIMIT 1000 OFFSET 0;
|
|
0.5810 [ms]
|
SELECT wp_posts.ID FROM wp_posts JOIN wp_icl_translations t
ON wp_posts.ID = t.element_id
AND t.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish'))
AND ( ( t.language_code = 'en' AND wp_posts.post_type IN ('post','page','wp_block','slide' ) ) OR wp_posts.post_type NOT IN
('post','page','wp_block','slide' ) ) ORDER BY wp_posts.post_date DESC LIMIT 0, 5;
|
|
0.2921 [ms]
|
SELECT wp_posts.* FROM wp_posts WHERE ID IN (205,190);
|
|
0.7730 [ms]
|
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr
ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (190, 205) ORDER BY
t.name ASC ;
|
|
0.4048 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (190,205) ORDER BY meta_id ASC;
|
|
0.3939 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN wp_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.element_id IN (205,190);
|
|
0.0598 [ms]
|
SELECT ID FROM wp_posts WHERE guid='http://maipromthai.com/wp-content/uploads/2017/07/เช็คอิน..png';;
|
|
0.0641 [ms]
|
SELECT * FROM wp_posts WHERE ID = 463 LIMIT 1;
|
|
0.0439 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (463) ORDER BY meta_id ASC;
|
|
0.0548 [ms]
|
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type)
JOIN wp_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.trid = (SELECT trid FROM wp_icl_translations t
JOIN wp_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 463 LIMIT 1);
|
