Unknown column 'CD.desc_nl' in 'field list' Q=SELECT CP.ca, CP.ca2, CP.pack_gf, CP.ctv_id, CP.ctv_ppc, CP.ctv_ppc_url, CP.detailpage, CP.booklink_nl, CP.url_nl, CP.regio_selected, CP.regio, CP.regio2, CP.regio_id, CP.varprov, CP.urlprov, CP.merk, CP.merk_id, CP.campnaam, CP.klasse, CP.provincie, CP.plaats, CP.urlplaats, CP.lat, CP.lng, (((CP.lat-51.076)/-8.742)*65)+5 AS ver, (((CP.lng+4.856)/13.085)*63)+2 AS hor, CP.naturisten, substring(CD.desc_nl,1,240) 'desc', SR.score, CP.taal_nl, VK.v113, VK.v114, VK.v115, VK.v261, VK.v239, VK.v135, VK.v155, VK.v133, VK.v134, CP.oppervlakte, VK.v119, VK.v120, VK.v141, VK.v348 FROM camps AS CP LEFT JOIN camps_desc AS CD ON (CP.ca = CD.ca) LEFT JOIN score AS SR ON (CP.ca = SR.ca) LEFT JOIN voorzien_kruis AS VK ON (CP.ca=VK.vz_ca) WHERE CP.ca IN (101025,95556,105320,95682,105271,102669,103772,12027,96397) order by field(CP.ca,101025,95556,105320,95682,105271,102669,103772,12027,96397)