SQLSTATE | ??08001 |
SQL | ?? select items.itemID, allowvideo, itemURL, link_status, temperament, adurl,newhits,lockout,icity, bademail, deletedflag, farmurl,shortdescription,paiduntil,sold,updateddate,pagehits, items.datecreated, address1, address2, price, negotiable,showprice, items.name, items.height, age, color, breed, otherbreed, description, sellers.sellerID, phoneday, phoneevening, askfor, callingnotice, gender, farmname, sellType, iregion, listingtype,istateid, izip, izipfull, states.statecode, states.statename, states.statenamecode, ( select group_concat(featurename) from features where features.itemID = (param 1) ) as featurelist, pedigrees.S1, pedigrees.D1, horsebreeds.breedcode, videos.adminreviewed, videos.filename, videos.swidth, videos.sheight, videos.sfilekb, videos.width, videos.height as vidheight, videos.filekb from items join sellers left outer join zips2 on zips2.zip = items.izip left outer join states on states.stateid = items.istateid left outer join pedigrees on pedigrees.itemID = items.itemID left outer join horsebreeds on items.breed = horsebreeds.breedname left outer join videos on (videos.itemID = items.itemID and videos.deletevideofile = 0 and videos.adminreviewed = 1) where items.sellerID = sellers.sellerID and items.itemID = (param 2) order by videoID desc limit 1 |
DATASOURCE | ??horsetopia_dsn |
Source: http://www.horsetopia.com/for-sale/classifieds/ad556011
ohare airport etta james songs east west shrine game haywire underworld awakening dog the bounty hunter tacoma narrows bridge
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.