Advertisement
psi_mmobile

Untitled

May 13th, 2022
507
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.     SQL_CALC_FOUND_ROWS
  3.     wp_pages.*,
  4.     pages.lang as hreflang,
  5.     pages.page_group as page_group,
  6.     page_groups.name as hreflang_group,
  7.     websites.live_url,
  8.     websites.beta_url,
  9.     meta.meta_value as page_group_disabled
  10. FROM
  11.     wp_pages wp, website w, pages p,page_groups pg, meta m
  12. WHERE wp.website_id = w.website_id
  13. and wp.website_id = pages.id_websites
  14. and (wp.url = pages.url or pages.url is null)
  15. and p.page_group = pg.id
  16. and pg.id = m.object_id
  17. and page_groups.id = meta.object_id
  18. AND meta.object_type = 'group'
  19. AND meta.meta_key = 'disabled';
Advertisement
RAW Paste Data Copied
Advertisement