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.text, (SELECT pay_expire FROM oglo24_announcement_payments WHERE pay_ident = ogl.ident AND pay_type = 'MAIN' AND pay_expire>='2024-03-28' LIMIT 1) AS main_till, (MATCH (ogl.title) AGAINST ('227' IN NATURAL LANGUAGE MODE)) AS search_score, (MATCH (ogl.title) AGAINST ('227' IN BOOLEAN MODE)) AS search_score2 FROM oglo24_announcement AS ogl LEFT JOIN oglo24_announcement_payments AS pay ON ogl.ident=pay.pay_ident AND pay.pay_type='VIEW' LEFT JOIN oglo24_announcement_payments AS pay_promoted ON ogl.ident=pay_promoted.pay_ident AND pay_promoted.pay_type='PROMOTED' LEFT JOIN oglo24_company AS comp ON comp.company_id = ogl.company_id WHERE ogl.status='ACCEPT' AND ogl.display = 'TRUE' AND (((pay.pay_create <= '2024-03-28' OR pay.pay_create <= '2024-03-28' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-03-28') OR ogl.forever = 'TRUE') AND ((ogl.city LIKE '%dodaj-do-schowka%' OR ogl.city_rw LIKE '%dodaj-do-schowka%') OR (ogl.whole_country = 'TRUE')) AND ogl.category IN () AND REPLACE(ogl.title, '-', ' ') LIKE '%227%') AS x Caught exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND REPLACE(ogl.title, '-', ' ') LIKE '%227%') AS x' at line 1 array(5) { [0]=> array(7) { ["file"]=> string(73) "/home/platne/serwer257042/public_html/infopisz.pl/classes/mysql.class.php" ["line"]=> int(105) ["function"]=> string(7) "doQuery" ["class"]=> string(5) "MySQL" ["object"]=> object(Announcement)#19 (15) { ["value"]=> array(0) { } ["query"]=> object(mysqli_result)#116 (5) { ["current_field"]=> int(0) ["field_count"]=> int(1) ["lengths"]=> NULL ["num_rows"]=> int(0) ["type"]=> int(0) } ["row"]=> NULL ["logs"]=> bool(false) ["perpage"]=> string(2) "10" ["sqlTable"]=> NULL ["sqlWhere"]=> NULL ["sqlOrder"]=> NULL ["sqlFullQuery"]=> string(1805) "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.text, (SELECT pay_expire FROM oglo24_announcement_payments WHERE pay_ident = ogl.ident AND pay_type = 'MAIN' AND pay_expire>='2024-03-28' LIMIT 1) AS main_till, (SELECT GROUP_CONCAT(ph.photo_filename ORDER BY ph.photo_main = 'YES' DESC) FROM oglo24_announcement_photos AS ph WHERE ph.photo_announcement_id = ogl.id) AS photos, (MATCH (ogl.title) AGAINST ('227' IN NATURAL LANGUAGE MODE)) AS search_score, (MATCH (ogl.title) AGAINST ('227' IN BOOLEAN MODE)) AS search_score2 FROM oglo24_announcement AS ogl LEFT JOIN oglo24_announcement_payments AS pay ON ogl.ident=pay.pay_ident AND pay.pay_type='VIEW' LEFT JOIN oglo24_announcement_payments AS pay_promoted ON ogl.ident=pay_promoted.pay_ident AND pay_promoted.pay_type='PROMOTED' LEFT JOIN oglo24_company AS comp ON comp.company_id = ogl.company_id WHERE ogl.status='ACCEPT' AND ogl.display = 'TRUE' AND (((pay.pay_create <= '2024-03-28' OR pay.pay_create <= '2024-03-28' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-03-28') OR ogl.forever = 'TRUE') AND ((ogl.city LIKE '%dodaj-do-schowka%' OR ogl.city_rw LIKE '%dodaj-do-schowka%') OR (ogl.whole_country = 'TRUE')) AND ogl.category IN () AND REPLACE(ogl.title, '-', ' ') LIKE '%227%' ORDER BY (((pay.pay_create <= '2024-03-28' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-03-28') OR ogl.forever = 'TRUE') DESC, promoted_till >= '2024-03-28' DESC, search_score DESC, search_score2 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) "2024-03-28" ["type"]=> string(6) "basic2" } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(1434) "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.text, (SELECT pay_expire FROM oglo24_announcement_payments WHERE pay_ident = ogl.ident AND pay_type = 'MAIN' AND pay_expire>='2024-03-28' LIMIT 1) AS main_till, (MATCH (ogl.title) AGAINST ('227' IN NATURAL LANGUAGE MODE)) AS search_score, (MATCH (ogl.title) AGAINST ('227' IN BOOLEAN MODE)) AS search_score2 FROM oglo24_announcement AS ogl LEFT JOIN oglo24_announcement_payments AS pay ON ogl.ident=pay.pay_ident AND pay.pay_type='VIEW' LEFT JOIN oglo24_announcement_payments AS pay_promoted ON ogl.ident=pay_promoted.pay_ident AND pay_promoted.pay_type='PROMOTED' LEFT JOIN oglo24_company AS comp ON comp.company_id = ogl.company_id WHERE ogl.status='ACCEPT' AND ogl.display = 'TRUE' AND (((pay.pay_create <= '2024-03-28' OR pay.pay_create <= '2024-03-28' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-03-28') OR ogl.forever = 'TRUE') AND ((ogl.city LIKE '%dodaj-do-schowka%' OR ogl.city_rw LIKE '%dodaj-do-schowka%') OR (ogl.whole_country = 'TRUE')) AND ogl.category IN () AND REPLACE(ogl.title, '-', ' ') LIKE '%227%') AS x" } } [1]=> array(7) { ["file"]=> string(73) "/home/platne/serwer257042/public_html/infopisz.pl/classes/mysql.class.php" ["line"]=> int(308) ["function"]=> string(8) "sqlQuery" ["class"]=> string(5) "MySQL" ["object"]=> object(Announcement)#19 (15) { ["value"]=> array(0) { } ["query"]=> object(mysqli_result)#116 (5) { ["current_field"]=> int(0) ["field_count"]=> int(1) ["lengths"]=> NULL ["num_rows"]=> int(0) ["type"]=> int(0) } ["row"]=> NULL ["logs"]=> bool(false) ["perpage"]=> string(2) "10" ["sqlTable"]=> NULL ["sqlWhere"]=> NULL ["sqlOrder"]=> NULL ["sqlFullQuery"]=> string(1805) "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.text, (SELECT pay_expire FROM oglo24_announcement_payments WHERE pay_ident = ogl.ident AND pay_type = 'MAIN' AND pay_expire>='2024-03-28' LIMIT 1) AS main_till, (SELECT GROUP_CONCAT(ph.photo_filename ORDER BY ph.photo_main = 'YES' DESC) FROM oglo24_announcement_photos AS ph WHERE ph.photo_announcement_id = ogl.id) AS photos, (MATCH (ogl.title) AGAINST ('227' IN NATURAL LANGUAGE MODE)) AS search_score, (MATCH (ogl.title) AGAINST ('227' IN BOOLEAN MODE)) AS search_score2 FROM oglo24_announcement AS ogl LEFT JOIN oglo24_announcement_payments AS pay ON ogl.ident=pay.pay_ident AND pay.pay_type='VIEW' LEFT JOIN oglo24_announcement_payments AS pay_promoted ON ogl.ident=pay_promoted.pay_ident AND pay_promoted.pay_type='PROMOTED' LEFT JOIN oglo24_company AS comp ON comp.company_id = ogl.company_id WHERE ogl.status='ACCEPT' AND ogl.display = 'TRUE' AND (((pay.pay_create <= '2024-03-28' OR pay.pay_create <= '2024-03-28' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-03-28') OR ogl.forever = 'TRUE') AND ((ogl.city LIKE '%dodaj-do-schowka%' OR ogl.city_rw LIKE '%dodaj-do-schowka%') OR (ogl.whole_country = 'TRUE')) AND ogl.category IN () AND REPLACE(ogl.title, '-', ' ') LIKE '%227%' ORDER BY (((pay.pay_create <= '2024-03-28' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-03-28') OR ogl.forever = 'TRUE') DESC, promoted_till >= '2024-03-28' DESC, search_score DESC, search_score2 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) "2024-03-28" ["type"]=> string(6) "basic2" } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(1434) "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.text, (SELECT pay_expire FROM oglo24_announcement_payments WHERE pay_ident = ogl.ident AND pay_type = 'MAIN' AND pay_expire>='2024-03-28' LIMIT 1) AS main_till, (MATCH (ogl.title) AGAINST ('227' IN NATURAL LANGUAGE MODE)) AS search_score, (MATCH (ogl.title) AGAINST ('227' IN BOOLEAN MODE)) AS search_score2 FROM oglo24_announcement AS ogl LEFT JOIN oglo24_announcement_payments AS pay ON ogl.ident=pay.pay_ident AND pay.pay_type='VIEW' LEFT JOIN oglo24_announcement_payments AS pay_promoted ON ogl.ident=pay_promoted.pay_ident AND pay_promoted.pay_type='PROMOTED' LEFT JOIN oglo24_company AS comp ON comp.company_id = ogl.company_id WHERE ogl.status='ACCEPT' AND ogl.display = 'TRUE' AND (((pay.pay_create <= '2024-03-28' OR pay.pay_create <= '2024-03-28' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-03-28') OR ogl.forever = 'TRUE') AND ((ogl.city LIKE '%dodaj-do-schowka%' OR ogl.city_rw LIKE '%dodaj-do-schowka%') OR (ogl.whole_country = 'TRUE')) AND ogl.category IN () AND REPLACE(ogl.title, '-', ' ') LIKE '%227%') AS x" } } [2]=> array(7) { ["file"]=> string(74) "/home/platne/serwer257042/public_html/infopisz.pl/classes/avatec.class.php" ["line"]=> int(573) ["function"]=> string(14) "sqlCountSimple" ["class"]=> string(5) "MySQL" ["object"]=> object(Announcement)#19 (15) { ["value"]=> array(0) { } ["query"]=> object(mysqli_result)#116 (5) { ["current_field"]=> int(0) ["field_count"]=> int(1) ["lengths"]=> NULL ["num_rows"]=> int(0) ["type"]=> int(0) } ["row"]=> NULL ["logs"]=> bool(false) ["perpage"]=> string(2) "10" ["sqlTable"]=> NULL ["sqlWhere"]=> NULL ["sqlOrder"]=> NULL ["sqlFullQuery"]=> string(1805) "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.text, (SELECT pay_expire FROM oglo24_announcement_payments WHERE pay_ident = ogl.ident AND pay_type = 'MAIN' AND pay_expire>='2024-03-28' LIMIT 1) AS main_till, (SELECT GROUP_CONCAT(ph.photo_filename ORDER BY ph.photo_main = 'YES' DESC) FROM oglo24_announcement_photos AS ph WHERE ph.photo_announcement_id = ogl.id) AS photos, (MATCH (ogl.title) AGAINST ('227' IN NATURAL LANGUAGE MODE)) AS search_score, (MATCH (ogl.title) AGAINST ('227' IN BOOLEAN MODE)) AS search_score2 FROM oglo24_announcement AS ogl LEFT JOIN oglo24_announcement_payments AS pay ON ogl.ident=pay.pay_ident AND pay.pay_type='VIEW' LEFT JOIN oglo24_announcement_payments AS pay_promoted ON ogl.ident=pay_promoted.pay_ident AND pay_promoted.pay_type='PROMOTED' LEFT JOIN oglo24_company AS comp ON comp.company_id = ogl.company_id WHERE ogl.status='ACCEPT' AND ogl.display = 'TRUE' AND (((pay.pay_create <= '2024-03-28' OR pay.pay_create <= '2024-03-28' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-03-28') OR ogl.forever = 'TRUE') AND ((ogl.city LIKE '%dodaj-do-schowka%' OR ogl.city_rw LIKE '%dodaj-do-schowka%') OR (ogl.whole_country = 'TRUE')) AND ogl.category IN () AND REPLACE(ogl.title, '-', ' ') LIKE '%227%' ORDER BY (((pay.pay_create <= '2024-03-28' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-03-28') OR ogl.forever = 'TRUE') DESC, promoted_till >= '2024-03-28' DESC, search_score DESC, search_score2 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) "2024-03-28" ["type"]=> string(6) "basic2" } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(1434) "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.text, (SELECT pay_expire FROM oglo24_announcement_payments WHERE pay_ident = ogl.ident AND pay_type = 'MAIN' AND pay_expire>='2024-03-28' LIMIT 1) AS main_till, (MATCH (ogl.title) AGAINST ('227' IN NATURAL LANGUAGE MODE)) AS search_score, (MATCH (ogl.title) AGAINST ('227' IN BOOLEAN MODE)) AS search_score2 FROM oglo24_announcement AS ogl LEFT JOIN oglo24_announcement_payments AS pay ON ogl.ident=pay.pay_ident AND pay.pay_type='VIEW' LEFT JOIN oglo24_announcement_payments AS pay_promoted ON ogl.ident=pay_promoted.pay_ident AND pay_promoted.pay_type='PROMOTED' LEFT JOIN oglo24_company AS comp ON comp.company_id = ogl.company_id WHERE ogl.status='ACCEPT' AND ogl.display = 'TRUE' AND (((pay.pay_create <= '2024-03-28' OR pay.pay_create <= '2024-03-28' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-03-28') OR ogl.forever = 'TRUE') AND ((ogl.city LIKE '%dodaj-do-schowka%' OR ogl.city_rw LIKE '%dodaj-do-schowka%') OR (ogl.whole_country = 'TRUE')) AND ogl.category IN () AND REPLACE(ogl.title, '-', ' ') LIKE '%227%') AS x" } } [3]=> array(7) { ["file"]=> string(93) "/home/platne/serwer257042/public_html/infopisz.pl/modules/announcement/announcement.class.php" ["line"]=> int(2571) ["function"]=> string(8) "paginate" ["class"]=> string(6) "kernel" ["object"]=> object(Announcement)#19 (15) { ["value"]=> array(0) { } ["query"]=> object(mysqli_result)#116 (5) { ["current_field"]=> int(0) ["field_count"]=> int(1) ["lengths"]=> NULL ["num_rows"]=> int(0) ["type"]=> int(0) } ["row"]=> NULL ["logs"]=> bool(false) ["perpage"]=> string(2) "10" ["sqlTable"]=> NULL ["sqlWhere"]=> NULL ["sqlOrder"]=> NULL ["sqlFullQuery"]=> string(1805) "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.text, (SELECT pay_expire FROM oglo24_announcement_payments WHERE pay_ident = ogl.ident AND pay_type = 'MAIN' AND pay_expire>='2024-03-28' LIMIT 1) AS main_till, (SELECT GROUP_CONCAT(ph.photo_filename ORDER BY ph.photo_main = 'YES' DESC) FROM oglo24_announcement_photos AS ph WHERE ph.photo_announcement_id = ogl.id) AS photos, (MATCH (ogl.title) AGAINST ('227' IN NATURAL LANGUAGE MODE)) AS search_score, (MATCH (ogl.title) AGAINST ('227' IN BOOLEAN MODE)) AS search_score2 FROM oglo24_announcement AS ogl LEFT JOIN oglo24_announcement_payments AS pay ON ogl.ident=pay.pay_ident AND pay.pay_type='VIEW' LEFT JOIN oglo24_announcement_payments AS pay_promoted ON ogl.ident=pay_promoted.pay_ident AND pay_promoted.pay_type='PROMOTED' LEFT JOIN oglo24_company AS comp ON comp.company_id = ogl.company_id WHERE ogl.status='ACCEPT' AND ogl.display = 'TRUE' AND (((pay.pay_create <= '2024-03-28' OR pay.pay_create <= '2024-03-28' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-03-28') OR ogl.forever = 'TRUE') AND ((ogl.city LIKE '%dodaj-do-schowka%' OR ogl.city_rw LIKE '%dodaj-do-schowka%') OR (ogl.whole_country = 'TRUE')) AND ogl.category IN () AND REPLACE(ogl.title, '-', ' ') LIKE '%227%' ORDER BY (((pay.pay_create <= '2024-03-28' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-03-28') OR ogl.forever = 'TRUE') DESC, promoted_till >= '2024-03-28' DESC, search_score DESC, search_score2 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) "2024-03-28" ["type"]=> string(6) "basic2" } ["type"]=> string(2) "->" ["args"]=> array(3) { [0]=> array(4) { [0]=> string(370) "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, " [1]=> string(166) ", (SELECT GROUP_CONCAT(ph.photo_filename ORDER BY ph.photo_main = 'YES' DESC) FROM oglo24_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(234) " ORDER BY (((pay.pay_create <= '2024-03-28' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-03-28') OR ogl.forever = 'TRUE') DESC, promoted_till >= '2024-03-28' DESC, search_score DESC, search_score2 DESC, ogl.create_date DESC" } [1]=> array(4) { [0]=> string(393) "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, " [1]=> string(0) "" [2]=> string(0) "" [3]=> string(0) "" } [2]=> string(6) ") AS x" } } [4]=> array(7) { ["file"]=> string(87) "/home/platne/serwer257042/public_html/infopisz.pl/modules/announcement/announcement.php" ["line"]=> int(198) ["function"]=> string(30) "userSearchAnnouncementStandard" ["class"]=> string(12) "Announcement" ["object"]=> object(Announcement)#19 (15) { ["value"]=> array(0) { } ["query"]=> object(mysqli_result)#116 (5) { ["current_field"]=> int(0) ["field_count"]=> int(1) ["lengths"]=> NULL ["num_rows"]=> int(0) ["type"]=> int(0) } ["row"]=> NULL ["logs"]=> bool(false) ["perpage"]=> string(2) "10" ["sqlTable"]=> NULL ["sqlWhere"]=> NULL ["sqlOrder"]=> NULL ["sqlFullQuery"]=> string(1805) "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.text, (SELECT pay_expire FROM oglo24_announcement_payments WHERE pay_ident = ogl.ident AND pay_type = 'MAIN' AND pay_expire>='2024-03-28' LIMIT 1) AS main_till, (SELECT GROUP_CONCAT(ph.photo_filename ORDER BY ph.photo_main = 'YES' DESC) FROM oglo24_announcement_photos AS ph WHERE ph.photo_announcement_id = ogl.id) AS photos, (MATCH (ogl.title) AGAINST ('227' IN NATURAL LANGUAGE MODE)) AS search_score, (MATCH (ogl.title) AGAINST ('227' IN BOOLEAN MODE)) AS search_score2 FROM oglo24_announcement AS ogl LEFT JOIN oglo24_announcement_payments AS pay ON ogl.ident=pay.pay_ident AND pay.pay_type='VIEW' LEFT JOIN oglo24_announcement_payments AS pay_promoted ON ogl.ident=pay_promoted.pay_ident AND pay_promoted.pay_type='PROMOTED' LEFT JOIN oglo24_company AS comp ON comp.company_id = ogl.company_id WHERE ogl.status='ACCEPT' AND ogl.display = 'TRUE' AND (((pay.pay_create <= '2024-03-28' OR pay.pay_create <= '2024-03-28' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-03-28') OR ogl.forever = 'TRUE') AND ((ogl.city LIKE '%dodaj-do-schowka%' OR ogl.city_rw LIKE '%dodaj-do-schowka%') OR (ogl.whole_country = 'TRUE')) AND ogl.category IN () AND REPLACE(ogl.title, '-', ' ') LIKE '%227%' ORDER BY (((pay.pay_create <= '2024-03-28' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-03-28') OR ogl.forever = 'TRUE') DESC, promoted_till >= '2024-03-28' DESC, search_score DESC, search_score2 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) "2024-03-28" ["type"]=> string(6) "basic2" } ["type"]=> string(2) "->" ["args"]=> array(0) { } } }