SQL[select item.itemid,item.categoryid,category.name as categoryname,category.nameid as categorynameid,pcategory.name as pcategoryname,pcategory.nameid as pcategorynameid,item.ownerid,item.title,item.description,item.dateadded,item.lastupdatedate,image.url as imageurl,image.imageid from marketplaceitem item left join marketplaceimage image on item.itemid=image.itemid join marketplacecategory category on item.categoryid=category.categoryid left join marketplacecategory pcategory on category.parentid=pcategory.categoryid where category.nameid='announcements' or pcategory.nameid='announcements' group by item.itemid order by item.lastupdatedate desc limit 0,10]
Got error 122 from storage engine
No items found in Misc > Announcements
SQL[select item.itemid,item.categoryid,category.name as categoryname,category.nameid as categorynameid,pcategory.name as pcategoryname,pcategory.nameid as pcategorynameid,item.ownerid,item.title,item.description,item.dateadded,item.lastupdatedate,image.url as imageurl,image.imageid from marketplaceitem item left join marketplaceimage image on item.itemid=image.itemid join marketplacecategory category on item.categoryid=category.categoryid left join marketplacecategory pcategory on category.parentid=pcategory.categoryid where category.nameid='misc' or pcategory.nameid='misc' group by item.itemid order by item.lastupdatedate desc limit 0,10]
Got error 122 from storage engine
- Books and Magazines
Magazines, Novels - Cars
New and Used, Audio/Video - Computers
Desktops, Laptops, Software, Printers - Electronics
Camera, MP3 Players, Phones, TVs - Fashion
Jewelry, Men, Miscellaneous, Women - Finance
Credit, Currency Exchange, Loans
- Health and Beauty
Perfume, Skincare, Haircare - Jobs
Part-Time, Full-Time, Interships - Miscellaneous
Other, Wanted Ads, Announcements - Real Estate
For Sale, Apartments, Sublets, For Rent - Travel
Cruises, Hotels, Flights, Vacation Deals
FLYERS: Events, Parties, etc
