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 or pages.url is null)
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';