http://www.gmtodayclassifieds.com/ GMToday Classifieds - Garage Sale en-us Copyright 2008 gmtodayclassifieds.com. All Rights Reserved. Thu, 20 Nov 2008 20:24:20 CST 20 SELECT TOP 40 A.*, B.catDescription, C.regUsername, C.regCompanyName, C.regEnabled FROM tblCPClassifieds A, tblCPCategories B, tblXUDUserRegistration C WHERE A.cadTerminate > {ts '2008-11-20 20:24:20' } AND A.cadValidated = 'Y' AND A.cadCatID IN (SELECT catID FROM tblCPCategories WHERE (catTLCatID=505 OR catTLCatID=506 OR catTLCatID=507 OR catTLCatID=508 OR catTLCatID=509 OR catTLCatID=510 OR catTLCatID=511 OR catTLCatID=512 OR catTLCatID=513 OR catTLCatID=514 OR catTLCatID=515 OR catTLCatID=516 OR catTLCatID=517 OR catTLCatID=518 OR catTLCatID=519 OR catTLCatID=520 OR catTLCatID=521 OR catTLCatID=522 OR catTLCatID=523 OR catTLCatID=524 OR catTLCatID=525 OR catTLCatID=526 OR catTLCatID=527 OR catTLCatID=528 OR catTLCatID=529) AND groupID=14) AND A.cadCatID=B.catID AND A.cadRegID*=C.RegID AND C.regEnabled='Y' AND A.groupID=14 AND (A.cadRegID IN (SELECT regID FROM tblXUDUserRegistration WHERE regEnabled = 'Y') OR A.cadregID=0) ORDER BY A.cadShowFeatured DESC, A.cadTitle