SQL: | SELECT i.id AS id, title, v.virtlink AS virtlink FROM issues AS i LEFT JOIN issues_mutations AS m ON (m.issue_id=i.id AND m.lang='hu') LEFT JOIN virtlinks AS v ON (v.issue_id=i.id AND v.lang='hu') WHERE i.parent_id= AND m.title>'' ORDER BY i.ord_index |