Unknown column 'prijs' in 'field list'
The query you issued was: (SELECT DISTINCT w.*,prijs FROM woningen AS w, aandacht AS a WHERE w.wontype_nr = a.wontype_nr AND w.tonen_soleara = 'J' AND w.wontype_nr LIKE '%' GROUP BY w.wontype_nr ORDER BY w.wontype_nr DESC)