SELECT COUNT(id) FROM (SELECT ogl.id, ogl.ident, ogl.title, ogl.category, ogl.city, ogl.state, ogl.country, ogl.cost, ogl.cost_max, ogl.cost_notice, ogl.cost_currency, ogl.for_free, ogl.status, ogl.display, ogl.forever, ogl.urgent, ogl.create_date, ogl.whole_country, DATEDIFF(CURDATE(), ogl.create_date) AS 'datediff', ogl.lat, ogl.lng, ogl.cost_tax, ogl.company_id, MAX(CASE WHEN pay.pay_type = 'VIEW' THEN pay.pay_expire ELSE NULL END) AS view_till, MAX(CASE WHEN pay.pay_type = 'PROMOTED' THEN pay.pay_expire ELSE NULL END) AS promoted_till FROM oglo2023_announcement AS ogl LEFT JOIN oglo2023_professions_list_pl AS professions ON professions.id = ogl.profession LEFT JOIN oglo2023_announcement_payments AS pay ON pay.pay_ident = ogl.ident AND pay.pay_expire >= '2026-04-27' WHERE
			ogl.status='ACCEPT'
			AND ogl.display = 'TRUE'
			AND (((pay.pay_create <= '2026-04-27' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2026-04-27') OR ogl.forever = 'TRUE') AND comp.company_subdomain='powiatowy-urzad-pracy-w-ostrowie-wielkopolskim'  AND ogl.company_id='1427'  GROUP BY ogl.id ) AS x 
Caught exception: Unknown column 'comp.company_subdomain' in 'where clause'
array(6) {
  [0]=>
  array(5) {
    ["file"]=>
    string(64) "/home/users/opengo/public_html/opraca.pl/classes/mysql.class.php"
    ["line"]=>
    int(281)
    ["function"]=>
    string(7) "doQuery"
    ["class"]=>
    string(5) "MySQL"
    ["type"]=>
    string(2) "->"
  }
  [1]=>
  array(5) {
    ["file"]=>
    string(64) "/home/users/opengo/public_html/opraca.pl/classes/mysql.class.php"
    ["line"]=>
    int(625)
    ["function"]=>
    string(8) "sqlQuery"
    ["class"]=>
    string(5) "MySQL"
    ["type"]=>
    string(2) "->"
  }
  [2]=>
  array(5) {
    ["file"]=>
    string(65) "/home/users/opengo/public_html/opraca.pl/classes/avatec.class.php"
    ["line"]=>
    int(567)
    ["function"]=>
    string(14) "sqlCountSimple"
    ["class"]=>
    string(5) "MySQL"
    ["type"]=>
    string(2) "->"
  }
  [3]=>
  array(5) {
    ["file"]=>
    string(84) "/home/users/opengo/public_html/opraca.pl/modules/announcement/announcement.class.php"
    ["line"]=>
    int(2554)
    ["function"]=>
    string(8) "paginate"
    ["class"]=>
    string(6) "kernel"
    ["type"]=>
    string(2) "->"
  }
  [4]=>
  array(5) {
    ["file"]=>
    string(76) "/home/users/opengo/public_html/opraca.pl/modules/company/catalog.website.php"
    ["line"]=>
    int(177)
    ["function"]=>
    string(30) "userSearchAnnouncementStandard"
    ["class"]=>
    string(12) "Announcement"
    ["type"]=>
    string(2) "->"
  }
  [5]=>
  array(4) {
    ["file"]=>
    string(52) "/home/users/opengo/public_html/opraca.pl/content.php"
    ["line"]=>
    int(227)
    ["args"]=>
    array(1) {
      [0]=>
      string(76) "/home/users/opengo/public_html/opraca.pl/modules/company/catalog.website.php"
    }
    ["function"]=>
    string(7) "include"
  }
}