Меню

Размеры пирогов: SELECT msc.pagetitle, w.value AS length, h.value AS width, m.value AS mass FROM modx_site_content msc LEFT JOIN modx_site_tmplvar_contentvalues w ON w.contentid = msc.id AND w.tmplvarid = 63 LEFT JOIN modx_site_tmplvar_contentvalues h ON h.contentid = msc.id AND h.tmplvarid = 64 LEFT JOIN modx_site_tmplvar_contentvalues m ON m.contentid = msc.id AND m.tmplvarid = 62 WHERE msc.template = 8 AND w.value IS NOT null ORDER BY msc.parent, msc.menuindex