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';