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_basictravel = 'J' AND w.wontype_nr LIKE 'F%' GROUP BY w.wontype_nr ORDER BY pop_index DESC )