SELECT p.*,u.group_id,g.top_search_result, c.name company_name, c.logo company_image FROM `job_product` as p LEFT JOIN `job_companies` c on p.company_id = c.id LEFT JOIN `job_igsuser_lists` as u ON u.id = p.user_id LEFT JOIN `job_usergroups` as g ON g.group_id = u.group_id where p.status = 'active' AND p.hide = '0' AND p.xml_id= '0' and p.government_jobs = 0 AND ( (p.city in (select id from `job_cities` where name = 'Aberdeen Proving Ground') ) OR (p.state in (select code from `job_subadmin1` where name = 'Aberdeen Proving Ground') )) ORDER BY p.created_at DESC, (CASE WHEN g.top_search_result = 'yes' and p.featured = '1' and p.urgent = '1' and p.highlight = '1' THEN 1 WHEN g.top_search_result = 'yes' and p.urgent = '1' and p.featured = '1' THEN 2 WHEN g.top_search_result = 'yes' and p.urgent = '1' and p.highlight = '1' THEN 3 WHEN g.top_search_result = 'yes' and p.featured = '1' and p.highlight = '1' THEN 4 WHEN g.top_search_result = 'yes' and p.urgent = '1' THEN 5 WHEN g.top_search_result = 'yes' and p.featured = '1' THEN 6 WHEN g.top_search_result = 'yes' and p.highlight = '1' THEN 7 WHEN g.top_search_result = 'yes' THEN 8 WHEN p.featured = '1' and p.urgent = '1' and p.highlight = '1' THEN 9 WHEN p.urgent = '1' and p.featured = '1' THEN 10 WHEN p.urgent = '1' and p.highlight = '1' THEN 11 WHEN p.featured = '1' and p.highlight = '1' THEN 12 WHEN p.urgent = '1' THEN 13 WHEN p.featured = '1' THEN 14 WHEN p.highlight = '1' THEN 15 WHEN p.xml_id = '0' THEN 16 ELSE 17 END) DESC LIMIT 0,9 0 Job Listing

Browse Jobs

 

Advanced Search Advanced Search

Job Type

Salary Type

Salary

Qualification

Experience

Gender

Skills

This field is required.

Pin Code

This field is required.

Search Results

Sort by:
Job Search India-Jobs-Recruitment-Employment-Job Vacancies

image

"Inspire Global Solutions"


We "Inspire global solutions" provide solutions in determining your requirements and career needs that you dream for ever. A clear vision and a power of professional hands will give you platform to up hold your professional career.

  • Login
  • Register
  • Blog
  • About Us
  • Browse Jobs
  • Country
  • Sitemap
  • Help Center
  • Privacy Policy
  • Term and Condition

    • Connect with us


    • Facebook
    • Instagram
    • LinkedIn
    • Pinterest
    • Twitter
    © 2018-2025 Inspire Global Solutions, All right reserved
     
    image