Refine results
Refine by job title Refine by salary Refine by locationHere sql:select * from locations where lo_id='1231' order by lo_sortorder,lo_title
-
select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Alabama' OR jo_location2 = 'Alabama')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Alaska' OR jo_location2 = 'Alaska')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Arizona' OR jo_location2 = 'Arizona')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Arkansas' OR jo_location2 = 'Arkansas')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'California' OR jo_location2 = 'California')
- California(1) select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Colorado' OR jo_location2 = 'Colorado')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Connecticut' OR jo_location2 = 'Connecticut')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Delaware' OR jo_location2 = 'Delaware')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Florida' OR jo_location2 = 'Florida')
- Florida(3) select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Georgia' OR jo_location2 = 'Georgia')
- Georgia(1) select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Hawaii' OR jo_location2 = 'Hawaii')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Idaho' OR jo_location2 = 'Idaho')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Illinois' OR jo_location2 = 'Illinois')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Indiana' OR jo_location2 = 'Indiana')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Iowa' OR jo_location2 = 'Iowa')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Kansas' OR jo_location2 = 'Kansas')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Kentucky' OR jo_location2 = 'Kentucky')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Louisiana' OR jo_location2 = 'Louisiana')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Maine' OR jo_location2 = 'Maine')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Maryland' OR jo_location2 = 'Maryland')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Michigan' OR jo_location2 = 'Michigan')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Minnesota' OR jo_location2 = 'Minnesota')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Mississippi' OR jo_location2 = 'Mississippi')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Missouri' OR jo_location2 = 'Missouri')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Montana' OR jo_location2 = 'Montana')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Nebraska' OR jo_location2 = 'Nebraska')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Nevada' OR jo_location2 = 'Nevada')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'New Jersey' OR jo_location2 = 'New Jersey')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'New Mexico' OR jo_location2 = 'New Mexico')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'New York' OR jo_location2 = 'New York')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'North Carolina' OR jo_location2 = 'North Carolina')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'North Dakota' OR jo_location2 = 'North Dakota')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Ohio' OR jo_location2 = 'Ohio')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Oregon' OR jo_location2 = 'Oregon')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'South Carolina' OR jo_location2 = 'South Carolina')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'South Dakota' OR jo_location2 = 'South Dakota')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Tennessee' OR jo_location2 = 'Tennessee')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Texas' OR jo_location2 = 'Texas')
- Texas(2) select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Utah' OR jo_location2 = 'Utah')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Vermont' OR jo_location2 = 'Vermont')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Virginia' OR jo_location2 = 'Virginia')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Washington' OR jo_location2 = 'Washington')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'West Virginia' OR jo_location2 = 'West Virginia')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin')select count(*) from jobs,sectors where jo_sector=se_id AND jo_expires>now() AND jo_sector=se_id AND se_section='12' and (jo_location = 'United States of America' OR jo_location2 = 'United States of America' or jo_location = 'Florida' OR jo_location2 = 'Florida' or jo_location = 'Alabama' OR jo_location2 = 'Alabama' or jo_location = 'Alaska' OR jo_location2 = 'Alaska' or jo_location = 'Arizona' OR jo_location2 = 'Arizona' or jo_location = 'Arkansas' OR jo_location2 = 'Arkansas' or jo_location = 'California' OR jo_location2 = 'California' or jo_location = 'Colorado' OR jo_location2 = 'Colorado' or jo_location = 'Connecticut' OR jo_location2 = 'Connecticut' or jo_location = 'Delaware' OR jo_location2 = 'Delaware' or jo_location = 'District of Columbia' OR jo_location2 = 'District of Columbia' or jo_location = 'Georgia' OR jo_location2 = 'Georgia' or jo_location = 'Hawaii' OR jo_location2 = 'Hawaii' or jo_location = 'Idaho' OR jo_location2 = 'Idaho' or jo_location = 'Illinois' OR jo_location2 = 'Illinois' or jo_location = 'Indiana' OR jo_location2 = 'Indiana' or jo_location = 'Iowa' OR jo_location2 = 'Iowa' or jo_location = 'Kansas' OR jo_location2 = 'Kansas' or jo_location = 'Kentucky' OR jo_location2 = 'Kentucky' or jo_location = 'Louisiana' OR jo_location2 = 'Louisiana' or jo_location = 'Maine' OR jo_location2 = 'Maine' or jo_location = 'Maryland' OR jo_location2 = 'Maryland' or jo_location = 'Massachusetts' OR jo_location2 = 'Massachusetts' or jo_location = 'Michigan' OR jo_location2 = 'Michigan' or jo_location = 'Minnesota' OR jo_location2 = 'Minnesota' or jo_location = 'Mississippi' OR jo_location2 = 'Mississippi' or jo_location = 'Missouri' OR jo_location2 = 'Missouri' or jo_location = 'Montana' OR jo_location2 = 'Montana' or jo_location = 'Nebraska' OR jo_location2 = 'Nebraska' or jo_location = 'Nevada' OR jo_location2 = 'Nevada' or jo_location = 'New Hampshire' OR jo_location2 = 'New Hampshire' or jo_location = 'New Jersey' OR jo_location2 = 'New Jersey' or jo_location = 'New Mexico' OR jo_location2 = 'New Mexico' or jo_location = 'New York' OR jo_location2 = 'New York' or jo_location = 'North Carolina' OR jo_location2 = 'North Carolina' or jo_location = 'North Dakota' OR jo_location2 = 'North Dakota' or jo_location = 'Ohio' OR jo_location2 = 'Ohio' or jo_location = 'Oklahoma' OR jo_location2 = 'Oklahoma' or jo_location = 'Oregon' OR jo_location2 = 'Oregon' or jo_location = 'Pennsylvania' OR jo_location2 = 'Pennsylvania' or jo_location = 'Puerto Rico' OR jo_location2 = 'Puerto Rico' or jo_location = 'Rhode Island' OR jo_location2 = 'Rhode Island' or jo_location = 'South Carolina' OR jo_location2 = 'South Carolina' or jo_location = 'South Dakota' OR jo_location2 = 'South Dakota' or jo_location = 'Tennessee' OR jo_location2 = 'Tennessee' or jo_location = 'Texas' OR jo_location2 = 'Texas' or jo_location = 'Utah' OR jo_location2 = 'Utah' or jo_location = 'Vermont' OR jo_location2 = 'Vermont' or jo_location = 'Virginia' OR jo_location2 = 'Virginia' or jo_location = 'Washington' OR jo_location2 = 'Washington' or jo_location = 'West Virginia' OR jo_location2 = 'West Virginia' or jo_location = 'Wisconsin' OR jo_location2 = 'Wisconsin' or jo_location = 'Wyoming' OR jo_location2 = 'Wyoming' ) AND (jo_location = 'Wyoming' OR jo_location2 = 'Wyoming')
