Advertisement
Plepzz

Untitled

Mar 27th, 2012
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.23 KB | None | 0 0
  1. SELECT
  2.     cms_admin_sections.*,
  3.     COUNT(cms_admin_pages.pageID) AS attached_pages
  4. FROM cms_admin_sections
  5. LEFT JOIN cms_admin_pages ON cms_admin_pages.sectionID = cms_admin_sections.sectionID
  6. ORDER BY
  7.     cms_admin_sections.identifier
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement