selectcount(*) as aggregate from `saqlain_tr_turkey`.`jobs` leftjoin `saqlain_tr_turkey`.`cities` on `saqlain_tr_turkey`.`jobs`.`city` = `saqlain_tr_turkey`.`cities`.`id` leftjoin `saqlain_fratres_accounts`.`recruiters` on `saqlain_tr_turkey`.`jobs`.`recruiter_id` = `saqlain_fratres_accounts`.`recruiters`.`id` leftjoin `saqlain_tr_turkey`.`industries` on `saqlain_tr_turkey`.`jobs`.`job_industry` = `saqlain_tr_turkey`.`industries`.`id` where ( (industries.industry_slug ='leisure-tourism') ANDLOWER(cities.name) LIKELOWER('%beylikduzu istanbul %') ORLOWER(jobs.location_string) LIKELOWER('%beylikduzu istanbul %') ) AND (jobs.job_status ='active')