Blog
WordPress database error: [Not unique table/alias: 'icltr2']
SELECT SQL_CALC_FOUND_ROWS qtw_comments.comment_ID
FROM qtw_comments JOIN qtw_icl_translations icltr2
ON icltr2.element_id = qtw_comments.comment_post_ID
JOIN qtw_posts ON qtw_posts.ID = icltr2.element_id
AND CONCAT('post_', qtw_posts.post_type) = icltr2.element_type
LEFT JOIN qtw_icl_translations icltr_comment
ON icltr_comment.element_id = qtw_comments.comment_ID
AND icltr_comment.element_type = 'comment'
JOIN qtw_icl_translations icltr2
ON icltr2.element_id = qtw_comments.comment_post_ID
AND qtw_posts.ID = icltr2.element_id
AND CONCAT('post_', qtw_posts.post_type) = icltr2.element_type
LEFT JOIN qtw_icl_translations icltr_comment
ON icltr_comment.element_id = qtw_comments.comment_ID
AND icltr_comment.element_type = 'comment'
WHERE ( comment_approved = '1' ) AND comment_post_ID = 6681 AND comment_parent = 0 AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
) AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code
)
ORDER BY qtw_comments.comment_date_gmt ASC, qtw_comments.comment_ID ASC