(mysqlt): select p1.cID, pt.ctHandle , match(psi.cName, psi.cDescription, psi.content) against ('campers aanbod caravans kroon camper') as cIndexScore from Pages p1 left join Pages p2 on (p1.cPointerID = p2.cID) left join PagePaths on (PagePaths.cID = p1.cID and PagePaths.ppIsCanonical = 1) left join PageSearchIndex psi on (psi.cID = if(p2.cID is null, p1.cID, p2.cID)) inner join CollectionVersions cv on (cv.cID = if(p2.cID is null, p1.cID, p2.cID) and cvID = (select cvID from CollectionVersions where cvIsApproved = 1 and cID = cv.cID)) left join PageTypes pt on pt.ctID = cv.ctID inner join Collections c on (c.cID = if(p2.cID is null, p1.cID, p2.cID)) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = if (p2.cID is null, p1.cID, p2.cID)) where 1=1 and (p1.cID!='132') and ((match(psi.cName, psi.cDescription, psi.content) against ('campers aanbod caravans kroon camper')) OR ak_meta_title like '%campers aanbod caravans kroon camper%' OR ak_meta_description like '%campers aanbod caravans kroon camper%' OR ak_meta_keywords like '%campers aanbod caravans kroon camper%' OR ak_icon_dashboard like '%campers aanbod caravans kroon camper%' OR ak_exclude_nav like '%campers aanbod caravans kroon camper%' OR ak_exclude_page_list like '%campers aanbod caravans kroon camper%' OR ak_header_extra_content like '%campers aanbod caravans kroon camper%' OR ak_exclude_search_index like '%campers aanbod caravans kroon camper%' OR ak_exclude_sitemapxml like '%campers aanbod caravans kroon camper%' OR ak_bedrag like '%campers aanbod caravans kroon camper%' OR ak_merk like '%campers aanbod caravans kroon camper%' OR ak_nieuwgebruikt like '%campers aanbod caravans kroon camper%' OR ak_tags like '%campers aanbod caravans kroon camper%' OR ak_bouwjaar like '%campers aanbod caravans kroon camper%' OR ak_kilometerstand like '%campers aanbod caravans kroon camper%' OR ak_brandstof like '%campers aanbod caravans kroon camper%' OR ak_cceigenschappen like '%campers aanbod caravans kroon camper%' OR ak_type like '%campers aanbod caravans kroon camper%' OR ak_kleur like '%campers aanbod caravans kroon camper%' OR ak_Garantie like '%campers aanbod caravans kroon camper%' OR ak_transmissie like '%campers aanbod caravans kroon camper%' OR ak_motorinhoud like '%campers aanbod caravans kroon camper%' OR ak_vermogen like '%campers aanbod caravans kroon camper%' OR ak_titel like '%campers aanbod caravans kroon camper%' ) and cvName != '' and pt.ctID = '5' and (ak_exclude_page_list = 0 OR ak_exclude_page_list is null) and cvIsApproved = '1' and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and p1.cIsActive = '1' order by p1.cDisplayOrder asc, p1.cDisplayOrder asc limit 0,10