SELECT DISTINCT sc.id, sc.pagetitle, sc.description, sc.content, sc.introtext, sc.longtitle FROM `modx_site_content` sc LEFT JOIN `modx_site_tmplvar_contentvalues` stc ON sc.id = stc.contentid WHERE ( sc.pagetitle LIKE '%card' OR sc.description LIKE '%card' OR sc.content LIKE '%card%' OR sc.introtext LIKE '%card%' OR stc.value LIKE '%card%');
SELECT DISTINCT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.introtext, sc.content FROM `mod2_site_content` sc LEFT JOIN `mod2_site_tmplvar_contentvalues` stc ON sc.id = stc.contentid WHERE (sc.pagetitle LIKE '%school%' OR sc.longtitle LIKE '%school%' OR sc.description LIKE '%school%' OR sc.introtext LIKE '%school%' OR sc.content LIKE '%school%' OR stc.value LIKE '%school%') OR (sc.pagetitle LIKE '%teacher%' OR sc.longtitle LIKE '%teacher%' OR sc.description LIKE '%teacher%' OR sc.introtext LIKE '%teacher%' OR sc.content LIKE '%teacher%' OR stc.value LIKE '%teacher%') AND sc.id IN (63,64,65,66,67,68,69,70,71,72,73,97) AND sc.privateweb=0 AND sc.published=1 AND sc.searchable=1 AND sc.deleted=0 AND sc.hidemenu=0;
SELECT DISTINCT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.introtext, sc.content FROM `mod2_site_content` sc LEFT JOIN `mod2_site_tmplvar_contentvalues` stc ON sc.id = stc.contentid WHERE (sc.pagetitle LIKE '%school%' OR sc.longtitle LIKE '%school%' OR sc.description LIKE '%school%' OR sc.introtext LIKE '%school%' OR sc.content LIKE '%school%' OR stc.value LIKE '%school%') AND (sc.pagetitle LIKE '%teacher%' OR sc.longtitle LIKE '%teacher%' OR sc.description LIKE '%teacher%' OR sc.introtext LIKE '%teacher%' OR sc.content LIKE '%teacher%' OR stc.value LIKE '%teacher%') AND sc.id IN (63,64,65,66,67,68,69,70,71,72,73,97) AND sc.privateweb=0 AND sc.published=1 AND sc.searchable=1 AND sc.deleted=0 AND sc.hidemenu=0;
SELECT DISTINCT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.introtext, sc.content FROM `mod2_site_content` sc LEFT JOIN `mod2_site_tmplvar_contentvalues` stc ON sc.id = stc.contentid WHERE (sc.pagetitle LIKE '%Gender equality%' OR sc.longtitle LIKE '%Gender equality%' OR sc.description LIKE '%Gender equality%' OR sc.introtext LIKE '%Gender equality%' OR sc.content LIKE '%Gender equality%' OR stc.value LIKE '%Gender equality%') AND sc.id IN (63,64,65,66,67,68,69,70,71,72,73,97) AND sc.privateweb=0 AND sc.published=1 AND sc.searchable=1 AND sc.deleted=0 AND sc.hidemenu=0;
SELECT DISTINCT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.introtext, sc.content FROM `mod2_site_content` sc LEFT JOIN `mod2_site_tmplvar_contentvalues` stc ON sc.id = stc.contentid WHERE (sc.pagetitle NOT LIKE '%education%' AND sc.longtitle NOT LIKE '%education%' AND sc.description NOT LIKE '%education%' AND sc.introtext NOT LIKE '%education%' AND sc.content NOT LIKE '%education%' AND stc.value NOT LIKE '%education%') AND sc.id IN (63,64,65,66,67,68,69,70,71,72,73,97) AND sc.privateweb=0 AND sc.published=1 AND sc.searchable=1 AND sc.deleted=0 AND sc.hidemenu=0;
This discussion is closed to further replies. Keep calm and carry on.