- Job Seekers
- Home
- Candidate Login
- Candidate Register
- Employers
- Employers Login
- Employers Register
- Search
- Advanced Search
- Search by Sector
- Search by Job Type
- Search by Location
- Employer Directory
- Recruiter Directory
- About Us
- About Us
- Terms & Conditions
- Privacy Policy
- How to Advertise
- Useful Links
- Contact Us
- Find Us
- on Facebook
- Site Search
Search Results
Want to find out more? Register for free - click here to get full access to these and other jobs.MYSQL ERROR:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Supermarkets, Inc.') order by match(job_freetext) against ('Shaw's Supermarket' at line 1
select * from jobs where job_deleted=0 and ( job_loc_id='798' or job_loc_id='5958' or job_loc_id='5993' or job_loc_id='5992' or job_loc_id='5991' or job_loc_id='5990' or job_loc_id='5989' or job_loc_id='5988' or job_loc_id='5987' or job_loc_id='5986' or job_loc_id='5985' or job_loc_id='5984' or job_loc_id='5983' or job_loc_id='5982' or job_loc_id='5981' or job_loc_id='5980' or job_loc_id='5979' or job_loc_id='5978' or job_loc_id='5977' or job_loc_id='5976' or job_loc_id='5975' or job_loc_id='5974' or job_loc_id='5973' or job_loc_id='5972' or job_loc_id='5994' or job_loc_id='5995' or job_loc_id='5996' or job_loc_id='5997' or job_loc_id='5998' or job_loc_id='5999' or job_loc_id='6000' or job_loc_id='6001' or job_loc_id='6002' or job_loc_id='6003' or job_loc_id='6004' or job_loc_id='6005' or job_loc_id='6006' or job_loc_id='6007' or job_loc_id='6008' or job_loc_id='6009' or job_loc_id='6010' or job_loc_id='6011' or job_loc_id='6012' or job_loc_id='6013' or job_loc_id='6014' or job_loc_id='6015' or job_loc_id='6016' or job_loc_id='6017' or job_loc_id='6018' or job_loc_id='6019' or job_loc_id='6020' or job_loc_id='6021' or job_loc_id='6022' or job_loc_id='6023' or job_loc_id='6024' or job_loc_id='6025' or job_loc_id='6026' or job_loc_id='6027' or job_loc_id='5971' or job_loc_id='6381' or job_loc_id='6382' or job_loc_id='6383' or job_loc_id='6384' or job_loc_id='6385' or job_loc_id='6386' or job_loc_id='6387' or job_loc_id='6388' or job_loc_id='6389' or job_loc_id='6390' or job_loc_id='6391' or job_loc_id='6392' or job_loc_id='6393' or job_loc_id='6394' or job_loc_id='6395' or job_loc_id='6396' or job_loc_id='6397' or job_loc_id='6398' or job_loc_id='6399' or job_loc_id='6400' or job_loc_id='6401' or job_loc_id='6402' or job_loc_id='6403' or job_loc_id='6404' or job_loc_id='6405' or job_loc_id='6406' or job_loc_id='6407' or job_loc_id='6408' or job_loc_id='6409' or job_loc_id='6410' or job_loc_id='6411' or job_loc_id='6412' or job_loc_id='6413' or job_loc_id='6414' or job_loc_id='6415' or job_loc_id='6416' or job_loc_id='6417' or job_loc_id='6418' or job_loc_id='6419' or job_loc_id='6420' or job_loc_id='6421' or job_loc_id='6422' or job_loc_id='6423' or job_loc_id='6424' or job_loc_id='6425' or job_loc_id='6426' or job_loc_id='6427' or job_loc_id='6428' or job_loc_id='6429' or job_loc_id='6430' or job_loc_id='6431' or job_loc_id='6432' or job_loc_id='6433' or job_loc_id='6434' or job_loc_id='6435' or job_loc_id='6436' or job_loc_id='6437' or job_loc_id='6438' or job_loc_id='6439' or job_loc_id='6440' or job_loc_id='6441' or job_loc_id='6442' or job_loc_id='6443' or job_loc_id='6444' or job_loc_id='6445' or job_loc_id='6446' or job_loc_id='6447' or job_loc_id='6448' or job_loc_id='6449' or job_loc_id='6450' or job_loc_id='5970' or job_loc_id='6376' or job_loc_id='52678' or job_loc_id='52679' or job_loc_id='52680' or job_loc_id='52681' or job_loc_id='52682' or job_loc_id='52683' or job_loc_id='52684' or job_loc_id='52685' or job_loc_id='52686' or job_loc_id='52687' or job_loc_id='52688' or job_loc_id='52689' or job_loc_id='52690' or job_loc_id='52691' or job_loc_id='52692' or job_loc_id='52693' or job_loc_id='52694' or job_loc_id='52695' or job_loc_id='52696' or job_loc_id='52697' or job_loc_id='52698' or job_loc_id='52699' or job_loc_id='52700' or job_loc_id='52701' or job_loc_id='52702' or job_loc_id='52703' or job_loc_id='52704' or job_loc_id='6377' or job_loc_id='6378' or job_loc_id='6379' or job_loc_id='6380' or job_loc_id='5969' or job_loc_id='6333' or job_loc_id='6334' or job_loc_id='6335' or job_loc_id='6336' or job_loc_id='6337' or job_loc_id='6338' or job_loc_id='6339' or job_loc_id='6340' or job_loc_id='6341' or job_loc_id='6342' or job_loc_id='6343' or job_loc_id='6344' or job_loc_id='6345' or job_loc_id='6346' or job_loc_id='6347' or job_loc_id='6348' or job_loc_id='6349' or job_loc_id='6350' or job_loc_id='6351' or job_loc_id='6352' or job_loc_id='6353' or job_loc_id='6354' or job_loc_id='6355' or job_loc_id='6356' or job_loc_id='6357' or job_loc_id='6358' or job_loc_id='6359' or job_loc_id='6360' or job_loc_id='6361' or job_loc_id='6362' or job_loc_id='6363' or job_loc_id='6364' or job_loc_id='6365' or job_loc_id='6366' or job_loc_id='6367' or job_loc_id='6368' or job_loc_id='6369' or job_loc_id='6370' or job_loc_id='6371' or job_loc_id='6372' or job_loc_id='6373' or job_loc_id='6374' or job_loc_id='6375' or job_loc_id='5968' or job_loc_id='6304' or job_loc_id='6305' or job_loc_id='6306' or job_loc_id='6307' or job_loc_id='6308' or job_loc_id='6309' or job_loc_id='6310' or job_loc_id='6311' or job_loc_id='6312' or job_loc_id='6313' or job_loc_id='6314' or job_loc_id='6315' or job_loc_id='6316' or job_loc_id='6317' or job_loc_id='6318' or job_loc_id='6319' or job_loc_id='6320' or job_loc_id='6321' or job_loc_id='6322' or job_loc_id='6323' or job_loc_id='6324' or job_loc_id='6325' or job_loc_id='6326' or job_loc_id='6327' or job_loc_id='6328' or job_loc_id='6329' or job_loc_id='6330' or job_loc_id='6331' or job_loc_id='6332' or job_loc_id='5967' or job_loc_id='5966' or job_loc_id='6232' or job_loc_id='6233' or job_loc_id='6234' or job_loc_id='6235' or job_loc_id='6236' or job_loc_id='6237' or job_loc_id='6238' or job_loc_id='6239' or job_loc_id='6240' or job_loc_id='6241' or job_loc_id='6242' or job_loc_id='6243' or job_loc_id='6244' or job_loc_id='6245' or job_loc_id='6246' or job_loc_id='6247' or job_loc_id='6248' or job_loc_id='6249' or job_loc_id='6250' or job_loc_id='6251' or job_loc_id='6252' or job_loc_id='6253' or job_loc_id='6254' or job_loc_id='6255' or job_loc_id='6256' or job_loc_id='6257' or job_loc_id='6258' or job_loc_id='6259' or job_loc_id='6260' or job_loc_id='6261' or job_loc_id='6262' or job_loc_id='6263' or job_loc_id='6264' or job_loc_id='6265' or job_loc_id='6266' or job_loc_id='6267' or job_loc_id='6268' or job_loc_id='6269' or job_loc_id='6270' or job_loc_id='6271' or job_loc_id='6272' or job_loc_id='6273' or job_loc_id='6274' or job_loc_id='6275' or job_loc_id='6276' or job_loc_id='6277' or job_loc_id='6278' or job_loc_id='6279' or job_loc_id='6280' or job_loc_id='6281' or job_loc_id='6282' or job_loc_id='6283' or job_loc_id='6284' or job_loc_id='6285' or job_loc_id='6286' or job_loc_id='6287' or job_loc_id='6288' or job_loc_id='6289' or job_loc_id='6290' or job_loc_id='6291' or job_loc_id='6292' or job_loc_id='6293' or job_loc_id='6294' or job_loc_id='6295' or job_loc_id='6296' or job_loc_id='6297' or job_loc_id='6298' or job_loc_id='6299' or job_loc_id='6300' or job_loc_id='6301' or job_loc_id='6302' or job_loc_id='6303' or job_loc_id='5965' or job_loc_id='6203' or job_loc_id='6204' or job_loc_id='6205' or job_loc_id='6206' or job_loc_id='6207' or job_loc_id='6208' or job_loc_id='6209' or job_loc_id='6210' or job_loc_id='6211' or job_loc_id='6212' or job_loc_id='6213' or job_loc_id='6214' or job_loc_id='6215' or job_loc_id='6216' or job_loc_id='6217' or job_loc_id='6218' or job_loc_id='6219' or job_loc_id='6220' or job_loc_id='6221' or job_loc_id='6222' or job_loc_id='6223' or job_loc_id='6224' or job_loc_id='6225' or job_loc_id='6226' or job_loc_id='6227' or job_loc_id='6228' or job_loc_id='6229' or job_loc_id='6230' or job_loc_id='6231' or job_loc_id='5964' or job_loc_id='6174' or job_loc_id='6175' or job_loc_id='6176' or job_loc_id='6177' or job_loc_id='6178' or job_loc_id='6179' or job_loc_id='6180' or job_loc_id='6181' or job_loc_id='6182' or job_loc_id='6183' or job_loc_id='6184' or job_loc_id='6185' or job_loc_id='6186' or job_loc_id='6187' or job_loc_id='6188' or job_loc_id='6189' or job_loc_id='6190' or job_loc_id='6191' or job_loc_id='6192' or job_loc_id='6193' or job_loc_id='6194' or job_loc_id='6195' or job_loc_id='6196' or job_loc_id='6197' or job_loc_id='6198' or job_loc_id='6199' or job_loc_id='6200' or job_loc_id='6201' or job_loc_id='6202' or job_loc_id='5963' or job_loc_id='6144' or job_loc_id='6145' or job_loc_id='6146' or job_loc_id='6147' or job_loc_id='6148' or job_loc_id='6149' or job_loc_id='6150' or job_loc_id='6151' or job_loc_id='6152' or job_loc_id='6153' or job_loc_id='6154' or job_loc_id='6155' or job_loc_id='6156' or job_loc_id='6157' or job_loc_id='6158' or job_loc_id='6159' or job_loc_id='6160' or job_loc_id='6161' or job_loc_id='6162' or job_loc_id='6163' or job_loc_id='6164' or job_loc_id='6165' or job_loc_id='6166' or job_loc_id='6167' or job_loc_id='6168' or job_loc_id='6169' or job_loc_id='6170' or job_loc_id='6171' or job_loc_id='6172' or job_loc_id='6173' or job_loc_id='5962' or job_loc_id='6108' or job_loc_id='6109' or job_loc_id='6110' or job_loc_id='6111' or job_loc_id='6112' or job_loc_id='6113' or job_loc_id='6114' or job_loc_id='6115' or job_loc_id='6116' or job_loc_id='6117' or job_loc_id='6118' or job_loc_id='6119' or job_loc_id='6120' or job_loc_id='6121' or job_loc_id='6122' or job_loc_id='6123' or job_loc_id='6124' or job_loc_id='6125' or job_loc_id='6126' or job_loc_id='6127' or job_loc_id='6128' or job_loc_id='6129' or job_loc_id='6130' or job_loc_id='6131' or job_loc_id='6132' or job_loc_id='6133' or job_loc_id='6134' or job_loc_id='6135' or job_loc_id='6136' or job_loc_id='6137' or job_loc_id='6138' or job_loc_id='6139' or job_loc_id='6140' or job_loc_id='6141' or job_loc_id='6142' or job_loc_id='6143' or job_loc_id='5961' or job_loc_id='6097' or job_loc_id='6098' or job_loc_id='6099' or job_loc_id='6100' or job_loc_id='6101' or job_loc_id='6102' or job_loc_id='6103' or job_loc_id='6104' or job_loc_id='6105' or job_loc_id='6106' or job_loc_id='6107' or job_loc_id='5960' or job_loc_id='6061' or job_loc_id='6062' or job_loc_id='6063' or job_loc_id='6064' or job_loc_id='6065' or job_loc_id='6066' or job_loc_id='6067' or job_loc_id='6068' or job_loc_id='6069' or job_loc_id='6070' or job_loc_id='6071' or job_loc_id='6072' or job_loc_id='6073' or job_loc_id='6074' or job_loc_id='6075' or job_loc_id='6076' or job_loc_id='6077' or job_loc_id='6078' or job_loc_id='6079' or job_loc_id='6080' or job_loc_id='6081' or job_loc_id='6082' or job_loc_id='6083' or job_loc_id='6084' or job_loc_id='6085' or job_loc_id='6086' or job_loc_id='6087' or job_loc_id='6088' or job_loc_id='6089' or job_loc_id='6090' or job_loc_id='6091' or job_loc_id='6092' or job_loc_id='6093' or job_loc_id='6094' or job_loc_id='6095' or job_loc_id='6096' or job_loc_id='5959' or job_loc_id='6028' or job_loc_id='6029' or job_loc_id='6030' or job_loc_id='6031' or job_loc_id='6032' or job_loc_id='6033' or job_loc_id='6034' or job_loc_id='6035' or job_loc_id='6036' or job_loc_id='6037' or job_loc_id='6038' or job_loc_id='6039' or job_loc_id='6040' or job_loc_id='6041' or job_loc_id='6042' or job_loc_id='6043' or job_loc_id='6044' or job_loc_id='6045' or job_loc_id='6046' or job_loc_id='6047' or job_loc_id='6048' or job_loc_id='6049' or job_loc_id='6050' or job_loc_id='6051' or job_loc_id='6052' or job_loc_id='6053' or job_loc_id='6054' or job_loc_id='6055' or job_loc_id='6056' or job_loc_id='6057' or job_loc_id='6058' or job_loc_id='6059' or job_loc_id='6060' ) and ( job_typ_id='1' or job_typ_id='3' or job_typ_id='101' or job_typ_id='100' or job_typ_id='144' or job_typ_id='102' or job_typ_id='103' or job_typ_id='123' or job_typ_id='124' or job_typ_id='125' or job_typ_id='126' or job_typ_id='127' or job_typ_id='128' or job_typ_id='130' or job_typ_id='131' or job_typ_id='132' or job_typ_id='4' or job_typ_id='246' or job_typ_id='240' or job_typ_id='241' or job_typ_id='242' or job_typ_id='243' or job_typ_id='245' or job_typ_id='257' or job_typ_id='292' or job_typ_id='293' or job_typ_id='294' or job_typ_id='295' or job_typ_id='296' or job_typ_id='297' or job_typ_id='299' or job_typ_id='300' or job_typ_id='303' or job_typ_id='307' or job_typ_id='308' or job_typ_id='34' or job_typ_id='76' or job_typ_id='77' or job_typ_id='78' or job_typ_id='79' or job_typ_id='80' or job_typ_id='256' or job_typ_id='29' or job_typ_id='234' or job_typ_id='229' or job_typ_id='235' or job_typ_id='226' or job_typ_id='227' or job_typ_id='228' or job_typ_id='230' or job_typ_id='231' or job_typ_id='232' or job_typ_id='31' or job_typ_id='276' or job_typ_id='277' or job_typ_id='278' or job_typ_id='279' or job_typ_id='280' or job_typ_id='281' or job_typ_id='282' or job_typ_id='283' or job_typ_id='284' or job_typ_id='33' or job_typ_id='145' or job_typ_id='266' or job_typ_id='267' or job_typ_id='38' or job_typ_id='172' or job_typ_id='171' or job_typ_id='173' or job_typ_id='175' or job_typ_id='176' or job_typ_id='40' or job_typ_id='104' or job_typ_id='129' or job_typ_id='105' or job_typ_id='45' or job_typ_id='208' or job_typ_id='209' or job_typ_id='210' or job_typ_id='212' or job_typ_id='215' or job_typ_id='217' or job_typ_id='218' or job_typ_id='46' or job_typ_id='169' or job_typ_id='285' or job_typ_id='286' or job_typ_id='287' or job_typ_id='288' or job_typ_id='289' or job_typ_id='290' or job_typ_id='291' or job_typ_id='302' or job_typ_id='51' or job_typ_id='179' or job_typ_id='180' or job_typ_id='182' or job_typ_id='184' or job_typ_id='186' or job_typ_id='187' or job_typ_id='52' or job_typ_id='260' or job_typ_id='259' or job_typ_id='258' or job_typ_id='261' or job_typ_id='262' or job_typ_id='263' or job_typ_id='264' or job_typ_id='265' or job_typ_id='54' or job_typ_id='236' or job_typ_id='157' or job_typ_id='133' or job_typ_id='134' or job_typ_id='135' or job_typ_id='136' or job_typ_id='137' or job_typ_id='138' or job_typ_id='139' or job_typ_id='160' or job_typ_id='237' or job_typ_id='239' or job_typ_id='247' or job_typ_id='55' or job_typ_id='315' or job_typ_id='316' or job_typ_id='317' or job_typ_id='318' or job_typ_id='56' or job_typ_id='193' or job_typ_id='198' or job_typ_id='189' or job_typ_id='191' or job_typ_id='194' or job_typ_id='195' or job_typ_id='196' or job_typ_id='197' or job_typ_id='199' or job_typ_id='200' or job_typ_id='201' or job_typ_id='59' or job_typ_id='82' or job_typ_id='83' or job_typ_id='84' or job_typ_id='85' or job_typ_id='86' or job_typ_id='87' or job_typ_id='88' or job_typ_id='89' or job_typ_id='90' or job_typ_id='91' or job_typ_id='92' or job_typ_id='93' or job_typ_id='94' or job_typ_id='95' or job_typ_id='96' or job_typ_id='97' or job_typ_id='98' or job_typ_id='99' or job_typ_id='1855' or job_typ_id='1856' or job_typ_id='1857' or job_typ_id='1858' or job_typ_id='1859' or job_typ_id='1860' or job_typ_id='1861' or job_typ_id='1862' or job_typ_id='67' or job_typ_id='106' or job_typ_id='107' or job_typ_id='108' or job_typ_id='109' or job_typ_id='110' or job_typ_id='111' or job_typ_id='112' or job_typ_id='68' or job_typ_id='143' or job_typ_id='203' or job_typ_id='204' or job_typ_id='205' or job_typ_id='206' or job_typ_id='207' or job_typ_id='211' or job_typ_id='213' or job_typ_id='214' or job_typ_id='216' or job_typ_id='298' or job_typ_id='69' or job_typ_id='140' or job_typ_id='141' or job_typ_id='142' or job_typ_id='233' or job_typ_id='250' or job_typ_id='163' or job_typ_id='164' or job_typ_id='165' or job_typ_id='166' or job_typ_id='167' or job_typ_id='72' or job_typ_id='252' or job_typ_id='253' or job_typ_id='255' or job_typ_id='74' or job_typ_id='113' or job_typ_id='114' or job_typ_id='115' or job_typ_id='116' or job_typ_id='117' or job_typ_id='118' or job_typ_id='119' or job_typ_id='120' or job_typ_id='121' or job_typ_id='122' or job_typ_id='75' or job_typ_id='158' or job_typ_id='151' or job_typ_id='153' or job_typ_id='154' or job_typ_id='159' or job_typ_id='248' or job_typ_id='2127' or job_typ_id='146' or job_typ_id='148' or job_typ_id='149' or job_typ_id='170' or job_typ_id='174' or job_typ_id='177' or job_typ_id='178' or job_typ_id='181' or job_typ_id='183' or job_typ_id='185' or job_typ_id='188' or job_typ_id='190' or job_typ_id='192' or job_typ_id='244' or job_typ_id='249' or job_typ_id='251' or job_typ_id='254' or job_typ_id='202' or job_typ_id='219' or job_typ_id='220' or job_typ_id='221' or job_typ_id='222' or job_typ_id='223' or job_typ_id='224' or job_typ_id='225' or job_typ_id='268' or job_typ_id='269' or job_typ_id='270' or job_typ_id='271' or job_typ_id='272' or job_typ_id='273' or job_typ_id='274' or job_typ_id='275' or job_typ_id='301' or job_typ_id='304' or job_typ_id='305' or job_typ_id='306' or job_typ_id='309' or job_typ_id='310' or job_typ_id='311' or job_typ_id='312' or job_typ_id='313' or job_typ_id='314' ) and (job_timestamp<'2012-05-24 00:00:00' or job_featured=1) and job_closingdate>now() and match(job_freetext) against ('Shaw's Supermarkets, Inc.') order by match(job_freetext) against ('Shaw's Supermarkets, Inc.') desc, job_featured desc,job_id desc