Fatal error: Uncaught Exception: Problem preparing query (SELECT DISTINCT rand() as rand, eid, title, subtitle_es, persons, persons_min, bedrooms, bathrooms, description_small_es, daysmin, lid, tid, comid, pvid, gmap_lat, gmap_lng FROM establiments WHERE published = 1 AND pvid = 4 AND eid IN ( SELECT eid FROM ( SELECT eid, COUNT( eid ) AS c FROM establiments_serveis WHERE (serid = 11) GROUP BY eid HAVING c = 1 ) AS taula3 ) ORDER BY reserva_inmediata DESC, persons ASC, rand) Expression #1 of ORDER BY clause is not in SELECT list, references column 'somrurals.establiments.reserva_inmediata' which is not in SELECT list; this is incompatible with DISTINCT in /home/mttb/somrurals/administrador/includes/MysqliDb.php:1228 Stack trace: #0 /home/mttb/somrurals/administrador/includes/MysqliDb.php(325): MysqliDb->_prepareQuery() #1 /home/mttb/somrurals/includes/landing.php(204): MysqliDb->rawQuery('SELECT DISTINCT...') #2 /home/mttb/somrurals/landing.php(10): include('/home/mttb/somr...') in /home/mttb/somrurals/administrador/includes/MysqliDb.php on line 1228