SELECT pages.*, wmg_sites.userid, wmg_sites.subdomain, IF(sorting.order, sorting.order, 9999) as sorting_order, wmg_domains.*, wmg_sites.subdomain as subdomain
FROM (pages, wmg_domains)
JOIN wmg_page_links ON pages.id = wmg_page_links.pageid
LEFT JOIN wmg_page_types ON wmg_page_links.type = wmg_page_types.id
JOIN wmg_sites ON wmg_page_links.siteid = wmg_sites.id
LEFT JOIN wmg_templates ON wmg_templates.id = wmg_sites.templates_id
LEFT JOIN sorting ON sorting.plugin = CONCAT('site:',wmg_page_links.siteid) AND sorting.itemid = wmg_page_links.pageid
LEFT JOIN wmg_sites ON wmg_domains.siteid = wmg_sites.id
WHERE domain = 'blog.fixphoto.biz'
ORDER BY sorting_order asc, wmg_page_links.pageid asc