Search Jobs

SET
NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'

SELECT
SQL_CALC_FOUND_ROWS employer_job_post.job_id, employer_job_post.job_code, employer_job_post.jb_slug, employer_job_post.job_status, employer_job_post.job_title, employer_job_post.job_type, employer_job_post.work_min, employer_job_post.work_max, employer_job_post.salary_min, employer_job_post.salary_max, employer_job_post.hide_salary, employer_job_post.job_keyword, employer_job_post.company_name, employer_job_post.job_post_dt, employer_job_post.job_live_dt, employer_job_post.job_post_tm, employer_job_post.job_post_by, employer_job_post.job_views, employer_job_post.jb_loc_nm, employer_job_post.job_exp_dt, employer_data.loginname
FROM
employer_job_post LEFT OUTER JOIN employer_data ON employer_job_post.job_post_super_id = employer_data.id
WHERE
employer_job_post.job_status ='Active' and ( ( employer_job_post.job_code LIKE ''Area sales manager'%' or employer_job_post.job_title LIKE '%'Area sales manager'%' or employer_job_post.job_keyword LIKE '%'Area sales manager'%' or employer_job_post.company_name LIKE '%'Area sales manager'%' ) )
ORDER BY
employer_job_post.job_post_dt DESC, employer_job_post.job_id DESC
LIMIT
0, 30

$_POST

array (
)

$_GET

array (
)

$_SESSION

array (
'website_settings' => 
array (
'status' => 'Active',
'WEB_domain_name' => 'JobsGlint.com',
'WEB_header_name' => 'JobsGlint.com',
'WEB_footer_name' => 'SAC Management India Private Limited',
'mail_server' => 'mail.jobsglint.com',
'mail_port' => '587',
'from_user' => 'info@jobsglint.com',
'from_pass' => 'atq9@6wl@im3',
'setfrom_nm' => 'SAC Management India Pvt. Ltd.',
'emp_tax_rate' => '18',
'employer_contacts' => '9235558886',
'employer_mails' => 'info<i class="fa fa-at"></i>jobsglint.com',
'pre_employer_code' => 'EP',
'pre_job_code' => 'JG',
'cand_contacts' => '(91) 9235558887',
'cand_mails' => 'info<i class="fa fa-at"></i>jobsglint.com',
'cand_sercontact' => '(91) 9235558887',
'cand_sermail' => 'sacmgt<i class="fa fa-at"></i>jobsglint.com',
'cmail_server' => 'mail.jobsglint.com',
'cmail_port' => '587',
'cfrom_user' => 'info@jobsglint.com',
'cfrom_pass' => 'atq9@6wl@im3',
'csetfrom_nm' => 'SAC Management India Pvt. Ltd.',
'cand_daily_job_limit' => '15',
'cand_month_job_limit' => '300',
'office_addresss' => '<strong>SAC Management India Private Limited </strong><br>
3rd, Floor SAS House,<br>
Sapru Marg,<br>
Hazratganj, Lucknow<br>
Uttar Pradesh - India (Pin: 226001)',
),
'jsearch' => 
array (
'job_keyword' => 
array (
0 => '\'Area sales manager\'',
),
'job_location' => '',
'job_exp' => '',
'job_salary' => '',
),
'str_job_search' => ' and ( ( employer_job_post.job_code LIKE \'\'Area sales manager\'%\' or employer_job_post.job_title LIKE \'%\'Area sales manager\'%\' or employer_job_post.job_keyword LIKE \'%\'Area sales manager\'%\' or employer_job_post.company_name LIKE \'%\'Area sales manager\'%\'  ) ) ',
'c_job_code' => '',
'pg_cjob_detail' => '',
)

$_COOKIE

array (
'PHPSESSID' => 'chdktqb2reb7nfj3lckqlecng5',
'care_did' => '0e993ede-62a6-4741-86ac-34e36716f89a',
)

$_FILES

array (
)

$_SERVER

array (
'REDIRECT_UNIQUE_ID' => 'Z0Bph2q76o7@b8bb86vrcwAAAAE',
'REDIRECT_HTTPS' => 'on',
'REDIRECT_SSL_TLS_SNI' => 'jobsglint.com',
'REDIRECT_STATUS' => '200',
'UNIQUE_ID' => 'Z0Bph2q76o7@b8bb86vrcwAAAAE',
'HTTPS' => 'on',
'SSL_TLS_SNI' => 'jobsglint.com',
'HTTP_ACCEPT' => '*/*',
'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate',
'HTTP_REFERER' => 'http://jobsglint.com/jobseeker/job-list',
'HTTP_COOKIE' => 'PHPSESSID=chdktqb2reb7nfj3lckqlecng5; care_did=0e993ede-62a6-4741-86ac-34e36716f89a',
'HTTP_HOST' => 'jobsglint.com',
'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin',
'SERVER_SIGNATURE' => '',
'SERVER_SOFTWARE' => 'Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips',
'SERVER_NAME' => 'jobsglint.com',
'SERVER_ADDR' => '162.222.33.49',
'SERVER_PORT' => '443',
'REMOTE_ADDR' => '3.21.12.88',
'DOCUMENT_ROOT' => '/home/www/jobsglint.com',
'REQUEST_SCHEME' => 'https',
'CONTEXT_PREFIX' => '',
'CONTEXT_DOCUMENT_ROOT' => '/home/www/jobsglint.com',
'SERVER_ADMIN' => 'admin@jobsglint.com',
'SCRIPT_FILENAME' => '/home/www/jobsglint.com/jobseeker/job-list.php',
'REMOTE_PORT' => '42660',
'REDIRECT_URL' => '/jobseeker/job-list',
'GATEWAY_INTERFACE' => 'CGI/1.1',
'SERVER_PROTOCOL' => 'HTTP/1.1',
'REQUEST_METHOD' => 'GET',
'QUERY_STRING' => '',
'REQUEST_URI' => '/jobseeker/job-list',
'SCRIPT_NAME' => '/jobseeker/job-list.php',
'PHP_SELF' => '/jobseeker/job-list.php',
'REQUEST_TIME_FLOAT' => 1732274567.8670001,
'REQUEST_TIME' => 1732274567,
)