SELECT COUNT(id) FROM (SELECT ogl.id, ogl.ident, ogl.title, ogl.category, ogl.city, ogl.city_rw, ogl.district, ogl.state, ogl.country, ogl.cost, ogl.cost_notice, ogl.cost_currency, ogl.for_free, ogl.status, ogl.display, ogl.forever, ogl.urgent, ogl.create_date, ogl.whole_country, ogl.delivery_enabled, ogl.delivery_info, pay.pay_expire AS view_till, pay_promoted.pay_expire AS promoted_till, ogl.lat, ogl.lng, ogl.cost_unit FROM ogl24_announcement AS ogl LEFT JOIN ogl24_announcement_payments AS pay ON ogl.ident=pay.pay_ident AND pay.pay_type='VIEW' LEFT JOIN ogl24_announcement_payments AS pay_promoted ON ogl.ident=pay_promoted.pay_ident AND pay_promoted.pay_type='PROMOTED' LEFT JOIN ogl24_company AS comp ON comp.company_id = ogl.company_id WHERE ogl.status='ACCEPT' AND ogl.display = 'TRUE' AND (((pay.pay_create <= '2024-11-21' OR pay.pay_create <= '2025-05-21' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-11-21') OR ogl.forever = 'TRUE') HAVING main_till >= '2025-05-21') AS x Caught exception: Unknown column 'main_till' in 'having clause' array(6) { [0]=> array(7) { ["file"]=> string(24) "/classes/mysql.class.php" ["line"]=> int(110) ["function"]=> string(7) "doQuery" ["class"]=> string(5) "MySQL" ["object"]=> object(Announcement)#22 (15) { ["value"]=> array(0) { } ["query"]=> object(mysqli_result)#103 (5) { ["current_field"]=> int(0) ["field_count"]=> int(6) ["lengths"]=> NULL ["num_rows"]=> int(24) ["type"]=> int(0) } ["row"]=> NULL ["logs"]=> bool(false) ["perpage"]=> string(2) "10" ["sqlTable"]=> NULL ["sqlWhere"]=> NULL ["sqlOrder"]=> NULL ["sqlFullQuery"]=> string(1419) "SELECT ogl.id, ogl.ident, ogl.title, ogl.category, ogl.city, ogl.city_rw, ogl.district, ogl.state, ogl.country, ogl.cost, ogl.cost_notice, ogl.cost_currency, ogl.for_free, ogl.status, ogl.display, ogl.forever, ogl.urgent, ogl.create_date, ogl.whole_country, ogl.delivery_enabled, ogl.delivery_info, pay.pay_expire AS view_till, pay_promoted.pay_expire AS promoted_till, ogl.lat, ogl.lng, ogl.cost_unit, (SELECT pay_expire FROM ogl24_announcement_payments WHERE pay_ident = ogl.ident AND pay_type = 'MAIN' AND pay_expire>='2025-05-21' LIMIT 1) AS main_till, (SELECT GROUP_CONCAT(ph.photo_filename ORDER BY ph.photo_main = 'YES' DESC) FROM ogl24_announcement_photos AS ph WHERE ph.photo_announcement_id = ogl.id) AS photos FROM ogl24_announcement AS ogl LEFT JOIN ogl24_announcement_payments AS pay ON ogl.ident=pay.pay_ident AND pay.pay_type='VIEW' LEFT JOIN ogl24_announcement_payments AS pay_promoted ON ogl.ident=pay_promoted.pay_ident AND pay_promoted.pay_type='PROMOTED' LEFT JOIN ogl24_company AS comp ON comp.company_id = ogl.company_id WHERE ogl.status='ACCEPT' AND ogl.display = 'TRUE' AND (((pay.pay_create <= '2024-11-21' OR pay.pay_create <= '2025-05-21' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-11-21') OR ogl.forever = 'TRUE') HAVING main_till >= '2025-05-21' ORDER BY ((pay.pay_expire >= '2025-05-21') OR ogl.forever = 'TRUE') DESC, promoted_till >= '2025-05-21' DESC, ogl.create_date DESC" ["thumbWidth"]=> int(110) ["thumbHeight"]=> int(97) ["fieldWidth"]=> array(12) { [1]=> string(2) "8%" [2]=> string(3) "17%" [3]=> string(3) "25%" [4]=> string(3) "33%" [5]=> string(3) "42%" [6]=> string(3) "50%" [7]=> string(3) "58%" [8]=> string(3) "67%" [9]=> string(3) "75%" [10]=> string(3) "83%" [11]=> string(3) "92%" [12]=> string(4) "100%" } ["false"]=> bool(false) ["now"]=> string(10) "2025-05-21" ["type"]=> string(6) "basic2" } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(997) "SELECT COUNT(id) FROM (SELECT ogl.id, ogl.ident, ogl.title, ogl.category, ogl.city, ogl.city_rw, ogl.district, ogl.state, ogl.country, ogl.cost, ogl.cost_notice, ogl.cost_currency, ogl.for_free, ogl.status, ogl.display, ogl.forever, ogl.urgent, ogl.create_date, ogl.whole_country, ogl.delivery_enabled, ogl.delivery_info, pay.pay_expire AS view_till, pay_promoted.pay_expire AS promoted_till, ogl.lat, ogl.lng, ogl.cost_unit FROM ogl24_announcement AS ogl LEFT JOIN ogl24_announcement_payments AS pay ON ogl.ident=pay.pay_ident AND pay.pay_type='VIEW' LEFT JOIN ogl24_announcement_payments AS pay_promoted ON ogl.ident=pay_promoted.pay_ident AND pay_promoted.pay_type='PROMOTED' LEFT JOIN ogl24_company AS comp ON comp.company_id = ogl.company_id WHERE ogl.status='ACCEPT' AND ogl.display = 'TRUE' AND (((pay.pay_create <= '2024-11-21' OR pay.pay_create <= '2025-05-21' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-11-21') OR ogl.forever = 'TRUE') HAVING main_till >= '2025-05-21') AS x" } } [1]=> array(7) { ["file"]=> string(24) "/classes/mysql.class.php" ["line"]=> int(313) ["function"]=> string(8) "sqlQuery" ["class"]=> string(5) "MySQL" ["object"]=> object(Announcement)#22 (15) { ["value"]=> array(0) { } ["query"]=> object(mysqli_result)#103 (5) { ["current_field"]=> int(0) ["field_count"]=> int(6) ["lengths"]=> NULL ["num_rows"]=> int(24) ["type"]=> int(0) } ["row"]=> NULL ["logs"]=> bool(false) ["perpage"]=> string(2) "10" ["sqlTable"]=> NULL ["sqlWhere"]=> NULL ["sqlOrder"]=> NULL ["sqlFullQuery"]=> string(1419) "SELECT ogl.id, ogl.ident, ogl.title, ogl.category, ogl.city, ogl.city_rw, ogl.district, ogl.state, ogl.country, ogl.cost, ogl.cost_notice, ogl.cost_currency, ogl.for_free, ogl.status, ogl.display, ogl.forever, ogl.urgent, ogl.create_date, ogl.whole_country, ogl.delivery_enabled, ogl.delivery_info, pay.pay_expire AS view_till, pay_promoted.pay_expire AS promoted_till, ogl.lat, ogl.lng, ogl.cost_unit, (SELECT pay_expire FROM ogl24_announcement_payments WHERE pay_ident = ogl.ident AND pay_type = 'MAIN' AND pay_expire>='2025-05-21' LIMIT 1) AS main_till, (SELECT GROUP_CONCAT(ph.photo_filename ORDER BY ph.photo_main = 'YES' DESC) FROM ogl24_announcement_photos AS ph WHERE ph.photo_announcement_id = ogl.id) AS photos FROM ogl24_announcement AS ogl LEFT JOIN ogl24_announcement_payments AS pay ON ogl.ident=pay.pay_ident AND pay.pay_type='VIEW' LEFT JOIN ogl24_announcement_payments AS pay_promoted ON ogl.ident=pay_promoted.pay_ident AND pay_promoted.pay_type='PROMOTED' LEFT JOIN ogl24_company AS comp ON comp.company_id = ogl.company_id WHERE ogl.status='ACCEPT' AND ogl.display = 'TRUE' AND (((pay.pay_create <= '2024-11-21' OR pay.pay_create <= '2025-05-21' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-11-21') OR ogl.forever = 'TRUE') HAVING main_till >= '2025-05-21' ORDER BY ((pay.pay_expire >= '2025-05-21') OR ogl.forever = 'TRUE') DESC, promoted_till >= '2025-05-21' DESC, ogl.create_date DESC" ["thumbWidth"]=> int(110) ["thumbHeight"]=> int(97) ["fieldWidth"]=> array(12) { [1]=> string(2) "8%" [2]=> string(3) "17%" [3]=> string(3) "25%" [4]=> string(3) "33%" [5]=> string(3) "42%" [6]=> string(3) "50%" [7]=> string(3) "58%" [8]=> string(3) "67%" [9]=> string(3) "75%" [10]=> string(3) "83%" [11]=> string(3) "92%" [12]=> string(4) "100%" } ["false"]=> bool(false) ["now"]=> string(10) "2025-05-21" ["type"]=> string(6) "basic2" } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(997) "SELECT COUNT(id) FROM (SELECT ogl.id, ogl.ident, ogl.title, ogl.category, ogl.city, ogl.city_rw, ogl.district, ogl.state, ogl.country, ogl.cost, ogl.cost_notice, ogl.cost_currency, ogl.for_free, ogl.status, ogl.display, ogl.forever, ogl.urgent, ogl.create_date, ogl.whole_country, ogl.delivery_enabled, ogl.delivery_info, pay.pay_expire AS view_till, pay_promoted.pay_expire AS promoted_till, ogl.lat, ogl.lng, ogl.cost_unit FROM ogl24_announcement AS ogl LEFT JOIN ogl24_announcement_payments AS pay ON ogl.ident=pay.pay_ident AND pay.pay_type='VIEW' LEFT JOIN ogl24_announcement_payments AS pay_promoted ON ogl.ident=pay_promoted.pay_ident AND pay_promoted.pay_type='PROMOTED' LEFT JOIN ogl24_company AS comp ON comp.company_id = ogl.company_id WHERE ogl.status='ACCEPT' AND ogl.display = 'TRUE' AND (((pay.pay_create <= '2024-11-21' OR pay.pay_create <= '2025-05-21' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-11-21') OR ogl.forever = 'TRUE') HAVING main_till >= '2025-05-21') AS x" } } [2]=> array(7) { ["file"]=> string(25) "/classes/avatec.class.php" ["line"]=> int(585) ["function"]=> string(14) "sqlCountSimple" ["class"]=> string(5) "MySQL" ["object"]=> object(Announcement)#22 (15) { ["value"]=> array(0) { } ["query"]=> object(mysqli_result)#103 (5) { ["current_field"]=> int(0) ["field_count"]=> int(6) ["lengths"]=> NULL ["num_rows"]=> int(24) ["type"]=> int(0) } ["row"]=> NULL ["logs"]=> bool(false) ["perpage"]=> string(2) "10" ["sqlTable"]=> NULL ["sqlWhere"]=> NULL ["sqlOrder"]=> NULL ["sqlFullQuery"]=> string(1419) "SELECT ogl.id, ogl.ident, ogl.title, ogl.category, ogl.city, ogl.city_rw, ogl.district, ogl.state, ogl.country, ogl.cost, ogl.cost_notice, ogl.cost_currency, ogl.for_free, ogl.status, ogl.display, ogl.forever, ogl.urgent, ogl.create_date, ogl.whole_country, ogl.delivery_enabled, ogl.delivery_info, pay.pay_expire AS view_till, pay_promoted.pay_expire AS promoted_till, ogl.lat, ogl.lng, ogl.cost_unit, (SELECT pay_expire FROM ogl24_announcement_payments WHERE pay_ident = ogl.ident AND pay_type = 'MAIN' AND pay_expire>='2025-05-21' LIMIT 1) AS main_till, (SELECT GROUP_CONCAT(ph.photo_filename ORDER BY ph.photo_main = 'YES' DESC) FROM ogl24_announcement_photos AS ph WHERE ph.photo_announcement_id = ogl.id) AS photos FROM ogl24_announcement AS ogl LEFT JOIN ogl24_announcement_payments AS pay ON ogl.ident=pay.pay_ident AND pay.pay_type='VIEW' LEFT JOIN ogl24_announcement_payments AS pay_promoted ON ogl.ident=pay_promoted.pay_ident AND pay_promoted.pay_type='PROMOTED' LEFT JOIN ogl24_company AS comp ON comp.company_id = ogl.company_id WHERE ogl.status='ACCEPT' AND ogl.display = 'TRUE' AND (((pay.pay_create <= '2024-11-21' OR pay.pay_create <= '2025-05-21' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-11-21') OR ogl.forever = 'TRUE') HAVING main_till >= '2025-05-21' ORDER BY ((pay.pay_expire >= '2025-05-21') OR ogl.forever = 'TRUE') DESC, promoted_till >= '2025-05-21' DESC, ogl.create_date DESC" ["thumbWidth"]=> int(110) ["thumbHeight"]=> int(97) ["fieldWidth"]=> array(12) { [1]=> string(2) "8%" [2]=> string(3) "17%" [3]=> string(3) "25%" [4]=> string(3) "33%" [5]=> string(3) "42%" [6]=> string(3) "50%" [7]=> string(3) "58%" [8]=> string(3) "67%" [9]=> string(3) "75%" [10]=> string(3) "83%" [11]=> string(3) "92%" [12]=> string(4) "100%" } ["false"]=> bool(false) ["now"]=> string(10) "2025-05-21" ["type"]=> string(6) "basic2" } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(997) "SELECT COUNT(id) FROM (SELECT ogl.id, ogl.ident, ogl.title, ogl.category, ogl.city, ogl.city_rw, ogl.district, ogl.state, ogl.country, ogl.cost, ogl.cost_notice, ogl.cost_currency, ogl.for_free, ogl.status, ogl.display, ogl.forever, ogl.urgent, ogl.create_date, ogl.whole_country, ogl.delivery_enabled, ogl.delivery_info, pay.pay_expire AS view_till, pay_promoted.pay_expire AS promoted_till, ogl.lat, ogl.lng, ogl.cost_unit FROM ogl24_announcement AS ogl LEFT JOIN ogl24_announcement_payments AS pay ON ogl.ident=pay.pay_ident AND pay.pay_type='VIEW' LEFT JOIN ogl24_announcement_payments AS pay_promoted ON ogl.ident=pay_promoted.pay_ident AND pay_promoted.pay_type='PROMOTED' LEFT JOIN ogl24_company AS comp ON comp.company_id = ogl.company_id WHERE ogl.status='ACCEPT' AND ogl.display = 'TRUE' AND (((pay.pay_create <= '2024-11-21' OR pay.pay_create <= '2025-05-21' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-11-21') OR ogl.forever = 'TRUE') HAVING main_till >= '2025-05-21') AS x" } } [3]=> array(7) { ["file"]=> string(44) "/modules/announcement/announcement.class.php" ["line"]=> int(2636) ["function"]=> string(8) "paginate" ["class"]=> string(6) "kernel" ["object"]=> object(Announcement)#22 (15) { ["value"]=> array(0) { } ["query"]=> object(mysqli_result)#103 (5) { ["current_field"]=> int(0) ["field_count"]=> int(6) ["lengths"]=> NULL ["num_rows"]=> int(24) ["type"]=> int(0) } ["row"]=> NULL ["logs"]=> bool(false) ["perpage"]=> string(2) "10" ["sqlTable"]=> NULL ["sqlWhere"]=> NULL ["sqlOrder"]=> NULL ["sqlFullQuery"]=> string(1419) "SELECT ogl.id, ogl.ident, ogl.title, ogl.category, ogl.city, ogl.city_rw, ogl.district, ogl.state, ogl.country, ogl.cost, ogl.cost_notice, ogl.cost_currency, ogl.for_free, ogl.status, ogl.display, ogl.forever, ogl.urgent, ogl.create_date, ogl.whole_country, ogl.delivery_enabled, ogl.delivery_info, pay.pay_expire AS view_till, pay_promoted.pay_expire AS promoted_till, ogl.lat, ogl.lng, ogl.cost_unit, (SELECT pay_expire FROM ogl24_announcement_payments WHERE pay_ident = ogl.ident AND pay_type = 'MAIN' AND pay_expire>='2025-05-21' LIMIT 1) AS main_till, (SELECT GROUP_CONCAT(ph.photo_filename ORDER BY ph.photo_main = 'YES' DESC) FROM ogl24_announcement_photos AS ph WHERE ph.photo_announcement_id = ogl.id) AS photos FROM ogl24_announcement AS ogl LEFT JOIN ogl24_announcement_payments AS pay ON ogl.ident=pay.pay_ident AND pay.pay_type='VIEW' LEFT JOIN ogl24_announcement_payments AS pay_promoted ON ogl.ident=pay_promoted.pay_ident AND pay_promoted.pay_type='PROMOTED' LEFT JOIN ogl24_company AS comp ON comp.company_id = ogl.company_id WHERE ogl.status='ACCEPT' AND ogl.display = 'TRUE' AND (((pay.pay_create <= '2024-11-21' OR pay.pay_create <= '2025-05-21' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-11-21') OR ogl.forever = 'TRUE') HAVING main_till >= '2025-05-21' ORDER BY ((pay.pay_expire >= '2025-05-21') OR ogl.forever = 'TRUE') DESC, promoted_till >= '2025-05-21' DESC, ogl.create_date DESC" ["thumbWidth"]=> int(110) ["thumbHeight"]=> int(97) ["fieldWidth"]=> array(12) { [1]=> string(2) "8%" [2]=> string(3) "17%" [3]=> string(3) "25%" [4]=> string(3) "33%" [5]=> string(3) "42%" [6]=> string(3) "50%" [7]=> string(3) "58%" [8]=> string(3) "67%" [9]=> string(3) "75%" [10]=> string(3) "83%" [11]=> string(3) "92%" [12]=> string(4) "100%" } ["false"]=> bool(false) ["now"]=> string(10) "2025-05-21" ["type"]=> string(6) "basic2" } ["type"]=> string(2) "->" ["args"]=> array(3) { [0]=> array(4) { [0]=> string(403) "SELECT ogl.id, ogl.ident, ogl.title, ogl.category, ogl.city, ogl.city_rw, ogl.district, ogl.state, ogl.country, ogl.cost, ogl.cost_notice, ogl.cost_currency, ogl.for_free, ogl.status, ogl.display, ogl.forever, ogl.urgent, ogl.create_date, ogl.whole_country, ogl.delivery_enabled, ogl.delivery_info, pay.pay_expire AS view_till, pay_promoted.pay_expire AS promoted_till, ogl.lat, ogl.lng, ogl.cost_unit, " [1]=> string(165) ", (SELECT GROUP_CONCAT(ph.photo_filename ORDER BY ph.photo_main = 'YES' DESC) FROM ogl24_announcement_photos AS ph WHERE ph.photo_announcement_id = ogl.id) AS photos" [2]=> string(35) "ORDER BY ph.photo_main = 'YES' DESC" [3]=> string(132) " ORDER BY ((pay.pay_expire >= '2025-05-21') OR ogl.forever = 'TRUE') DESC, promoted_till >= '2025-05-21' DESC, ogl.create_date DESC" } [1]=> array(4) { [0]=> string(426) "SELECT COUNT(id) FROM (SELECT ogl.id, ogl.ident, ogl.title, ogl.category, ogl.city, ogl.city_rw, ogl.district, ogl.state, ogl.country, ogl.cost, ogl.cost_notice, ogl.cost_currency, ogl.for_free, ogl.status, ogl.display, ogl.forever, ogl.urgent, ogl.create_date, ogl.whole_country, ogl.delivery_enabled, ogl.delivery_info, pay.pay_expire AS view_till, pay_promoted.pay_expire AS promoted_till, ogl.lat, ogl.lng, ogl.cost_unit, " [1]=> string(0) "" [2]=> string(0) "" [3]=> string(0) "" } [2]=> string(6) ") AS x" } } [4]=> array(7) { ["file"]=> string(38) "/modules/announcement/announcement.php" ["line"]=> int(205) ["function"]=> string(30) "userSearchAnnouncementStandard" ["class"]=> string(12) "Announcement" ["object"]=> object(Announcement)#22 (15) { ["value"]=> array(0) { } ["query"]=> object(mysqli_result)#103 (5) { ["current_field"]=> int(0) ["field_count"]=> int(6) ["lengths"]=> NULL ["num_rows"]=> int(24) ["type"]=> int(0) } ["row"]=> NULL ["logs"]=> bool(false) ["perpage"]=> string(2) "10" ["sqlTable"]=> NULL ["sqlWhere"]=> NULL ["sqlOrder"]=> NULL ["sqlFullQuery"]=> string(1419) "SELECT ogl.id, ogl.ident, ogl.title, ogl.category, ogl.city, ogl.city_rw, ogl.district, ogl.state, ogl.country, ogl.cost, ogl.cost_notice, ogl.cost_currency, ogl.for_free, ogl.status, ogl.display, ogl.forever, ogl.urgent, ogl.create_date, ogl.whole_country, ogl.delivery_enabled, ogl.delivery_info, pay.pay_expire AS view_till, pay_promoted.pay_expire AS promoted_till, ogl.lat, ogl.lng, ogl.cost_unit, (SELECT pay_expire FROM ogl24_announcement_payments WHERE pay_ident = ogl.ident AND pay_type = 'MAIN' AND pay_expire>='2025-05-21' LIMIT 1) AS main_till, (SELECT GROUP_CONCAT(ph.photo_filename ORDER BY ph.photo_main = 'YES' DESC) FROM ogl24_announcement_photos AS ph WHERE ph.photo_announcement_id = ogl.id) AS photos FROM ogl24_announcement AS ogl LEFT JOIN ogl24_announcement_payments AS pay ON ogl.ident=pay.pay_ident AND pay.pay_type='VIEW' LEFT JOIN ogl24_announcement_payments AS pay_promoted ON ogl.ident=pay_promoted.pay_ident AND pay_promoted.pay_type='PROMOTED' LEFT JOIN ogl24_company AS comp ON comp.company_id = ogl.company_id WHERE ogl.status='ACCEPT' AND ogl.display = 'TRUE' AND (((pay.pay_create <= '2024-11-21' OR pay.pay_create <= '2025-05-21' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-11-21') OR ogl.forever = 'TRUE') HAVING main_till >= '2025-05-21' ORDER BY ((pay.pay_expire >= '2025-05-21') OR ogl.forever = 'TRUE') DESC, promoted_till >= '2025-05-21' DESC, ogl.create_date DESC" ["thumbWidth"]=> int(110) ["thumbHeight"]=> int(97) ["fieldWidth"]=> array(12) { [1]=> string(2) "8%" [2]=> string(3) "17%" [3]=> string(3) "25%" [4]=> string(3) "33%" [5]=> string(3) "42%" [6]=> string(3) "50%" [7]=> string(3) "58%" [8]=> string(3) "67%" [9]=> string(3) "75%" [10]=> string(3) "83%" [11]=> string(3) "92%" [12]=> string(4) "100%" } ["false"]=> bool(false) ["now"]=> string(10) "2025-05-21" ["type"]=> string(6) "basic2" } ["type"]=> string(2) "->" ["args"]=> array(0) { } } [5]=> array(4) { ["file"]=> string(12) "/content.php" ["line"]=> int(525) ["args"]=> array(1) { [0]=> string(38) "/modules/announcement/announcement.php" } ["function"]=> string(7) "include" } }