select job_title_kword,remove_search_kword FROM log_file

Jobs By Category

select slno, disp_catg_name, flnm from category_tbl where ref_id = '0' and catg_type='1'

select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100001' group by b1.subcategory_id having cnt>5 limit 0, 21

Academic



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100002' group by b1.subcategory_id having cnt>5 limit 0, 21

ITES/BPO/KPO



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100003' group by b1.subcategory_id having cnt>5 limit 0, 21

IT-Software/Hardware



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100004' group by b1.subcategory_id having cnt>5 limit 0, 21

Engineering



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100005' group by b1.subcategory_id having cnt>5 limit 0, 21

Export/Import/Merchandising



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100006' group by b1.subcategory_id having cnt>5 limit 0, 21

Finance/Stock Market



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100007' group by b1.subcategory_id having cnt>5 limit 0, 21

Hotel/Travel/Airlines



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100009' group by b1.subcategory_id having cnt>5 limit 0, 21

Insurance Services



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100010' group by b1.subcategory_id having cnt>5 limit 0, 21

Content Writing/Journalism



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100011' group by b1.subcategory_id having cnt>5 limit 0, 21

Legal/Law Services



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100012' group by b1.subcategory_id having cnt>5 limit 0, 21

Medical/Health Care/Hospitals



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100013' group by b1.subcategory_id having cnt>5 limit 0, 21

Real Estate/Construction



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100014' group by b1.subcategory_id having cnt>5 limit 0, 21

Sales/Marketing



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100015' group by b1.subcategory_id having cnt>5 limit 0, 21

Technical



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100016' group by b1.subcategory_id having cnt>5 limit 0, 21

HR/Administration



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100042' group by b1.subcategory_id having cnt>5 limit 0, 21

Telecom/ISP



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100043' group by b1.subcategory_id having cnt>5 limit 0, 21

Media/Entertainment



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100044' group by b1.subcategory_id having cnt>5 limit 0, 21

Banking



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100045' group by b1.subcategory_id having cnt>5 limit 0, 21

Accounting/Tax



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100046' group by b1.subcategory_id having cnt>5 limit 0, 21

Cargo/Freight/Transportation



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100047' group by b1.subcategory_id having cnt>5 limit 0, 21

Public Relation



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100048' group by b1.subcategory_id having cnt>5 limit 0, 21

Manufacturing/Production/Quality



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100049' group by b1.subcategory_id having cnt>5 limit 0, 21

Oil/Gas/Petroleum



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100050' group by b1.subcategory_id having cnt>5 limit 0, 21

Security/Law Enforcement



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100051' group by b1.subcategory_id having cnt>5 limit 0, 21

Pharma/R&D/Biotech



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100052' group by b1.subcategory_id having cnt>5 limit 0, 21

Fresher/Trainee



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '100053' group by b1.subcategory_id having cnt>5 limit 0, 21

Trade/Practitioner



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '103268' group by b1.subcategory_id having cnt>5 limit 0, 21

Application Programming



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '103269' group by b1.subcategory_id having cnt>5 limit 0, 21

Analytic and Business Intelligence



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '103270' group by b1.subcategory_id having cnt>5 limit 0, 21

Corporate Planning and Consultancy



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '103271' group by b1.subcategory_id having cnt>5 limit 0, 21

Merchandising / Fashion



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '103272' group by b1.subcategory_id having cnt>5 limit 0, 21

IT - Client Server Software/Programming



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '103273' group by b1.subcategory_id having cnt>5 limit 0, 21

IT - Mainframe Software/Programming



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '103274' group by b1.subcategory_id having cnt>5 limit 0, 21

IT - Middleware Software/Programming



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '103275' group by b1.subcategory_id having cnt>5 limit 0, 21

IT - Mobile Software/Application



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '103276' group by b1.subcategory_id having cnt>5 limit 0, 21

IT Software - System Programming



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '103277' group by b1.subcategory_id having cnt>5 limit 0, 21

IT Software - Telecom



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '103278' group by b1.subcategory_id having cnt>5 limit 0, 21

IT - DBA/Database Management



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '103279' group by b1.subcategory_id having cnt>5 limit 0, 21

IT - Ecommerce/Internet Marketing



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '103280' group by b1.subcategory_id having cnt>5 limit 0, 21

IT - Web Designing/Programming



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '103281' group by b1.subcategory_id having cnt>5 limit 0, 21

Advertisement and Marketing



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '103282' group by b1.subcategory_id having cnt>5 limit 0, 21

IT - QA/Testing/Documentation



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '103283' group by b1.subcategory_id having cnt>5 limit 0, 21

IT Software- ERP/CRM/EDP/MIS



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '103285' group by b1.subcategory_id having cnt>5 limit 0, 21

Purchase / Supply Chain



select c1.flnm, c1.disp_catg_name, c1.cat_file_nm, c1.catg_type, count(*) as cnt from job_posting as a1, job_posting_category as b1, category_tbl as c1 where a1.slno=b1.job_id && c1.slno=b1.subcategory_id && a1.active_status in ('Y', 'E') && a1.job_posting_status='Y' and c1.ref_id = '103286' group by b1.subcategory_id having cnt>5 limit 0, 21

Front Office