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