SELECT `DB`.* , MATCH(`kop`, `keywords`) AGAINST ('+actueel*') AS `scorehigh`, MATCH(`kop`, `inleiding`, `inhoud` ,`nav_alt`, `description`, `keywords`) AGAINST ('+actueel*') AS `score` FROM `polijstbedrijf_database` `DB` LEFT JOIN `polijstbedrijf_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('+actueel*' IN BOOLEAN MODE) OR CONCAT_WS(' ',`kop`, `inleiding`, `inhoud` ,`nav_alt`, `description`, `keywords`) LIKE '%actueel%') ORDER BY `scorehigh` DESC, `score` DESC Column 'kop' in field list is ambiguousError in function:get_list