searchtextterms:
q:
SELECT ID,jobnum,jobtitle,username,contact,jobtype,city,state,denomination,payment,dateadded,premium,jobstatus,active,picture,videocode,filename,description,size,style,filenamelong,organization FROM joblistings WHERE dateadded!='0000-00-00' AND active='yes' AND jobstatus!='suspend' AND username not like '%motorola%' ORDER BY dateadded DESC, ID DESC