Search Jobs

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 Custom Drywall ') order by match(job_freetext) against ('Glen's Custom Drywall' at line 1
select * from jobs where job_deleted=0 and ( job_loc_id='780' or job_loc_id='11995' or job_loc_id='29938' or job_loc_id='29939' or job_loc_id='29940' or job_loc_id='29941' or job_loc_id='29942' or job_loc_id='29943' or job_loc_id='29944' or job_loc_id='11996' or job_loc_id='12011' or job_loc_id='11997' or job_loc_id='17345' or job_loc_id='17346' or job_loc_id='17347' or job_loc_id='11998' or job_loc_id='17348' or job_loc_id='17349' or job_loc_id='17350' or job_loc_id='17351' or job_loc_id='17352' or job_loc_id='11999' or job_loc_id='12012' or job_loc_id='17353' or job_loc_id='17354' or job_loc_id='17355' or job_loc_id='17356' or job_loc_id='17357' or job_loc_id='17358' or job_loc_id='17359' or job_loc_id='17360' or job_loc_id='17361' or job_loc_id='17362' or job_loc_id='17363' or job_loc_id='12000' or job_loc_id='17364' or job_loc_id='17365' or job_loc_id='17366' or job_loc_id='17367' or job_loc_id='17368' or job_loc_id='17369' or job_loc_id='12001' or job_loc_id='29945' or job_loc_id='29946' or job_loc_id='29947' or job_loc_id='12002' or job_loc_id='17370' or job_loc_id='17371' or job_loc_id='17372' or job_loc_id='17373' or job_loc_id='17374' or job_loc_id='17375' or job_loc_id='17376' or job_loc_id='17377' or job_loc_id='17378' or job_loc_id='17379' or job_loc_id='17380' or job_loc_id='17381' or job_loc_id='17382' or job_loc_id='17383' or job_loc_id='17384' or job_loc_id='17385' or job_loc_id='17386' or job_loc_id='17387' or job_loc_id='17388' or job_loc_id='17389' or job_loc_id='17390' or job_loc_id='17391' or job_loc_id='17392' or job_loc_id='17393' or job_loc_id='17394' or job_loc_id='17395' or job_loc_id='17396' or job_loc_id='17397' or job_loc_id='17398' or job_loc_id='17399' or job_loc_id='17400' or job_loc_id='17401' or job_loc_id='17402' or job_loc_id='17403' or job_loc_id='17404' or job_loc_id='17405' or job_loc_id='17406' or job_loc_id='12003' or job_loc_id='17407' or job_loc_id='17408' or job_loc_id='12004' or job_loc_id='17409' or job_loc_id='17410' or job_loc_id='17411' or job_loc_id='17412' or job_loc_id='17413' or job_loc_id='17414' or job_loc_id='17415' or job_loc_id='17416' or job_loc_id='17417' or job_loc_id='17418' or job_loc_id='17419' or job_loc_id='12005' or job_loc_id='17420' or job_loc_id='17421' or job_loc_id='17422' or job_loc_id='17423' or job_loc_id='17424' or job_loc_id='17425' or job_loc_id='17426' or job_loc_id='17427' or job_loc_id='17428' or job_loc_id='17429' or job_loc_id='17430' or job_loc_id='17431' or job_loc_id='17432' or job_loc_id='17433' or job_loc_id='17434' or job_loc_id='17435' or job_loc_id='17436' or job_loc_id='17437' or job_loc_id='12006' or job_loc_id='17438' or job_loc_id='17439' or job_loc_id='17440' or job_loc_id='17441' or job_loc_id='17442' or job_loc_id='17443' or job_loc_id='17444' or job_loc_id='17445' or job_loc_id='17446' or job_loc_id='17447' or job_loc_id='17448' or job_loc_id='17449' or job_loc_id='17450' or job_loc_id='17451' or job_loc_id='17452' or job_loc_id='17453' or job_loc_id='17454' or job_loc_id='17455' or job_loc_id='17456' or job_loc_id='17457' or job_loc_id='17458' or job_loc_id='17459' or job_loc_id='17460' or job_loc_id='17461' or job_loc_id='17462' or job_loc_id='17463' or job_loc_id='17464' or job_loc_id='17465' or job_loc_id='12007' or job_loc_id='17466' or job_loc_id='17467' or job_loc_id='17468' or job_loc_id='17469' or job_loc_id='17470' or job_loc_id='17471' or job_loc_id='17472' or job_loc_id='17473' or job_loc_id='17474' or job_loc_id='17475' or job_loc_id='12008' or job_loc_id='17476' or job_loc_id='17477' or job_loc_id='17478' or job_loc_id='17479' or job_loc_id='17480' or job_loc_id='17481' or job_loc_id='17482' or job_loc_id='17483' or job_loc_id='17484' or job_loc_id='17485' or job_loc_id='17486' or job_loc_id='17487' or job_loc_id='12009' or job_loc_id='29948' or job_loc_id='12010' or job_loc_id='29949' or job_loc_id='29950' or job_loc_id='29951' or job_loc_id='29952' or job_loc_id='29953' or job_loc_id='29954' or job_loc_id='29961' or job_loc_id='29962' or job_loc_id='29963' or job_loc_id='29964' or job_loc_id='29965' or job_loc_id='29966' or job_loc_id='29967' or job_loc_id='29968' or job_loc_id='29969' or job_loc_id='29970' or job_loc_id='29955' or job_loc_id='29971' or job_loc_id='29972' or job_loc_id='29973' or job_loc_id='29974' or job_loc_id='29975' or job_loc_id='29976' or job_loc_id='29977' or job_loc_id='29956' or job_loc_id='29978' or job_loc_id='29979' or job_loc_id='29980' or job_loc_id='29981' or job_loc_id='29982' or job_loc_id='29983' or job_loc_id='29984' or job_loc_id='29985' or job_loc_id='29986' or job_loc_id='29987' or job_loc_id='29988' or job_loc_id='29989' or job_loc_id='29957' or job_loc_id='29990' or job_loc_id='29991' or job_loc_id='29992' or job_loc_id='29993' or job_loc_id='29994' or job_loc_id='29995' or job_loc_id='29996' or job_loc_id='29997' or job_loc_id='29998' or job_loc_id='29999' or job_loc_id='30000' or job_loc_id='30001' or job_loc_id='29958' or job_loc_id='30002' or job_loc_id='30003' or job_loc_id='30004' or job_loc_id='30005' or job_loc_id='30006' or job_loc_id='30007' or job_loc_id='30008' or job_loc_id='30009' or job_loc_id='30010' or job_loc_id='30011' or job_loc_id='30012' or job_loc_id='30013' or job_loc_id='29959' or job_loc_id='30014' or job_loc_id='30015' or job_loc_id='30016' or job_loc_id='30017' or job_loc_id='29960' or job_loc_id='30018' or job_loc_id='30019' or job_loc_id='30020' or job_loc_id='30021' or job_loc_id='30022' or job_loc_id='30023' or job_loc_id='30024' or job_loc_id='30025' or job_loc_id='30026' or job_loc_id='30027' or job_loc_id='30028' or job_loc_id='30029' or job_loc_id='30030' or job_loc_id='30031' or job_loc_id='30032' or job_loc_id='30033' or job_loc_id='30034' or job_loc_id='30035' or job_loc_id='30036' or job_loc_id='30037' or job_loc_id='30038' or job_loc_id='30039' or job_loc_id='30040' or job_loc_id='30041' or job_loc_id='30042' or job_loc_id='30043' or job_loc_id='30044' or job_loc_id='30045' or job_loc_id='30046' or job_loc_id='30047' or job_loc_id='30048' or job_loc_id='30049' or job_loc_id='30050' or job_loc_id='30051' ) 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-23 00:00:00' or job_featured=1) and job_closingdate>now() and match(job_freetext) against ('Glen's Custom Drywall ') order by match(job_freetext) against ('Glen's Custom Drywall ') desc, job_featured desc,job_id desc