selectcount(*) as aggregate from `saqlain_pt_portugal`.`jobs` leftjoin `saqlain_pt_portugal`.`cities` on `saqlain_pt_portugal`.`jobs`.`city` = `saqlain_pt_portugal`.`cities`.`id` leftjoin `saqlain_fratres_accounts`.`recruiters` on `saqlain_pt_portugal`.`jobs`.`recruiter_id` = `saqlain_fratres_accounts`.`recruiters`.`id` leftjoin `saqlain_pt_portugal`.`industries` on `saqlain_pt_portugal`.`jobs`.`job_industry` = `saqlain_pt_portugal`.`industries`.`id` where ( (industries.industry_slug ='Automotive/Aerospace') ANDLOWER(cities.name) LIKELOWER('%queijada viana do castelo fornelos viana do castelo%') ORLOWER(jobs.location_string) LIKELOWER('%queijada viana do castelo fornelos viana do castelo%')AND (jobs.contract_type ='temporary') ) AND (jobs.job_status ='active')