SQL: SELECT DISTINCT sc.id, sc.menutitle, sc.pagetitle, sc.introtext, sc.menuindex, sc.published, sc.hidemenu, sc.parent, sc.isfolder, sc.description, sc.alias, sc.longtitle, sc.type,if(sc.type='reference',sc.content,'') as content, sc.template, sc.link_attributes FROM `commerx`.`modx_site_content` sc LEFT JOIN `commerx`.`modx_document_groups` dg ON dg.document = sc.id WHERE sc.published=1 AND sc.deleted=0 AND (sc.privateweb=0) AND sc.hidemenu=0 AND sc.id IN (1,76,74,58,75,8,15,18,24,34,38,45,46,47,56,65,57,86,79,96,5,4,6,7,95,9,10,11,12,13,14,49,61,64,50,51,60,16,19,20,63,21,23,83,66,67,28,84,80,27,81,82,30,53,17,33,97,87,35,36,69,68,39,70,71,72,73,48,85,78) GROUP BY sc.id ORDER BY sc.menuindex ASC ; [Copy SQL to ClipBoard]
|