SELECT `DB`.* , MATCH(`kop`, `keywords`) AGAINST ('+cms/foto* +onder/.klein/groot* +fb* +1.png*') AS `scorehigh`, MATCH(`kop`, `inleiding`, `inhoud` ,`nav_alt`, `description`, `keywords`) AGAINST ('+cms/foto* +onder/.klein/groot* +fb* +1.png*') AS `score` FROM `langeberg_database` `DB` LEFT JOIN `langeberg_namen` `NAME` ON `NAME`.`naam`= LEFT(`DB`.`type_ordennr`,length(`DB`.`type_ordennr`)-length(SUBSTRING_INDEX(`DB`.`type_ordennr`, '-', -1))-1) WHERE `activeren` = 1 AND `DB`.`type_ordennr` LIKE 'nl-%' AND `NAME`.`type` NOT LIKE 'cms%' AND `NAME`.`type` NOT LIKE 'dummy%' AND `NAME`.`type` NOT LIKE 'restricted%' AND `NAME`.`type` NOT LIKE 'search%' AND `NAME`.`type` NOT LIKE 'mailing' AND `NAME`.`type` NOT LIKE 'sms' AND `NAME`.`type` NOT LIKE 'guestbook' AND `NAME`.`type` NOT LIKE 'respond' AND (MATCH(`kop`, `inleiding`, `inhoud` ,`nav_alt`, `description`, `keywords`) AGAINST('+cms/foto* +onder/.klein/groot* +fb* +1.png*' IN BOOLEAN MODE) OR  CONCAT_WS(' ',`kop`, `inleiding`, `inhoud` ,`nav_alt`, `description`, `keywords`) LIKE '%cms/foto%onder/.klein/groot%fb%1.png%') ORDER BY `scorehigh` DESC, `score` DESC
Column 'kop' in field list is ambiguousError in function:get_list