SQL Statement failed on preparation: SELECT p.id, p.internal_number, c2.gps_lo AS category_gps_lo, c2.gps_la AS category_gps_la, cl.name AS category, t.name AS type, p.ad_type, p.top, p.link, p.enquiry_type, living_space, lot_size, rooms, bedrooms, bathrooms, beds, p.term_of_lease, stars, stars_type, p.arrival_day, p.name, p.street, p.zip_code, p.city, p.quarter, showaddress, p.gps_lo, p.gps_la, p.occupancy_lastmod, p.creation, p.lastmod, p.activation, extra_1, extra_2, extra_3, pl.html_title, pl.title, pl.url, pl.description_short, pl.description_long, pr.id AS price_id, pr.price, s_filename, s_width, s_height, s_filename, s_width, s_height, g_filename, g_width, g_height, g_filename, g_width, g_height, m_filename, m_width, m_height, l_filename, l_width, l_height, il.name AS image_name, o_filename, o_width, o_height, o_filename, rl.name AS region FROM mycms_property AS p INNER JOIN mycms_category AS c1 INNER JOIN mycms_category AS c2 ON c2.id = p.category_id AND c2.lft BETWEEN c1.lft AND c1.rgt LEFT JOIN mycms_price_season AS pr ON pr.id = price_id INNER JOIN mycms_price_season AS lm ON (lm.property_id = p.id AND lm.type = ? AND lm.begin <= ? AND lm.end >= ? AND lm.end - lm.begin < ? AND lm.valid_to = 2147483647 AND lm.begin = (SELECT MIN(lm.begin) FROM mycms_price_season AS lm WHERE lm.property_id = p.id AND lm.type = ? AND lm.begin <= ? AND lm.end >= ? AND lm.end - lm.begin < ? AND lm.valid_to = 2147483647)) INNER JOIN mycms_property_language AS pl ON pl.property_id = p.id AND pl.language_id = ? INNER JOIN mycms_user AS u ON u.id = p.user_id AND u.status = ? INNER JOIN mycms_category_language AS cl ON cl.category_id = p.category_id AND cl.language_id = ? INNER JOIN mycms_type AS t ON t.id = p.type_id AND t.language_id = ? LEFT JOIN mycms_image AS i ON i.id = p.image_gallery LEFT JOIN mycms_image_language AS il ON il.image_id = i.id AND il.language_id = ? LEFT JOIN mycms_region_language AS rl ON rl.region_id = p.region_id AND rl.language_id = ? WHERE p.activated = 1 AND p.status = ? AND (p.extra_2 & ?) = 0 GROUP BY p.id, pr.id, pl.html_title, pl.title, pl.url, pl.description_short, pl.description_long, cl.name, t.name, il.name, rl.name ORDER BY p.ad_type, IF(p.enquiry_type = 'D', 0, 1) , lm.begin, p.priority DESC, (extra_2 & 0x00200000), RAND(1733524412), p.occupancy_lastmod DESC, pl.title LIMIT 0,15'
Fatal error: mysqli error: [1055: Expression #3 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'db1159658-myfewo.lm.begin' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by] in EXECUTE("SELECT p.id, p.internal_number, c2.gps_lo AS category_gps_lo, c2.gps_la AS category_gps_la, cl.name AS category, t.name AS type, p.ad_type, p.top, p.link, p.enquiry_type, living_space, lot_size, rooms, bedrooms, bathrooms, beds, p.term_of_lease, stars, stars_type, p.arrival_day, p.name, p.street, p.zip_code, p.city, p.quarter, showaddress, p.gps_lo, p.gps_la, p.occupancy_lastmod, p.creation, p.lastmod, p.activation, extra_1, extra_2, extra_3, pl.html_title, pl.title, pl.url, pl.description_short, pl.description_long, pr.id AS price_id, pr.price, s_filename, s_width, s_height, s_filename, s_width, s_height, g_filename, g_width, g_height, g_filename, g_width, g_height, m_filename, m_width, m_height, l_filename, l_width, l_height, il.name AS image_name, o_filename, o_width, o_height, o_filename, rl.name AS region FROM mycms_property AS p INNER JOIN mycms_category AS c1 INNER JOIN mycms_category AS c2 ON c2.id = p.category_id AND c2.lft BETWEEN c1.lft AND c1.rgt LEFT JOIN mycms_price_season AS pr ON pr.id = price_id INNER JOIN mycms_price_season AS lm ON (lm.property_id = p.id AND lm.type = ? AND lm.begin <= ? AND lm.end >= ? AND lm.end - lm.begin < ? AND lm.valid_to = 2147483647 AND lm.begin = (SELECT MIN(lm.begin) FROM mycms_price_season AS lm WHERE lm.property_id = p.id AND lm.type = ? AND lm.begin <= ? AND lm.end >= ? AND lm.end - lm.begin < ? AND lm.valid_to = 2147483647)) INNER JOIN mycms_property_language AS pl ON pl.property_id = p.id AND pl.language_id = ? INNER JOIN mycms_user AS u ON u.id = p.user_id AND u.status = ? INNER JOIN mycms_category_language AS cl ON cl.category_id = p.category_id AND cl.language_id = ? INNER JOIN mycms_type AS t ON t.id = p.type_id AND t.language_id = ? LEFT JOIN mycms_image AS i ON i.id = p.image_gallery LEFT JOIN mycms_image_language AS il ON il.image_id = i.id AND il.language_id = ? LEFT JOIN mycms_region_language AS rl ON rl.region_id = p.region_id AND rl.language_id = ? WHERE p.activated = 1 AND p.status = ? AND (p.extra_2 & ?) = 0 GROUP BY p.id, pr.id, pl.html_title, pl.title, pl.url, pl.description_short, pl.description_long, cl.name, t.name, il.name, rl.name ORDER BY p.ad_type, IF(p.enquiry_type = 'D', 0, 1) , lm.begin, p.priority DESC, (extra_2 & 0x00200000), RAND(1733524412), p.occupancy_lastmod DESC, pl.title LIMIT 0,15")
in /is/htdocs/wp1159658_ZODHA7L2OS/ostsee-und-nordsee.de/cms/libs/adodb/adodb-errorhandler.inc.php on line 84