SELECT
SQL_CALC_FOUND_ROWS
wp_pages.*,
pages.lang as hreflang,
pages.page_group as page_group,
page_groups.name as hreflang_group,
websites.live_url,
websites.beta_url,
meta.meta_value as page_group_disabled
FROM
wp_pages wp, website w, pages p,page_groups pg, meta m
WHERE wp.website_id = w.website_id
and wp.website_id = pages.id_websites
and wp.url = pages.url(+) <-- LEFT OUTER JOIN
and p.page_group = pg.id
and pg.id = m.object_id
and page_groups.id = meta.object_id
AND meta.object_type = 'group'
AND meta.meta_key = 'disabled';