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='jewelry' or pcategory.nameid='jewelry' group by item.itemid order by item.lastupdatedate desc limit 0,10]
Got error 122 from storage engine
No items found in Fashion > Jewelry
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='fashion' or pcategory.nameid='fashion' group by item.itemid order by item.lastupdatedate desc limit 0,10]
Got error 122 from storage engine
- Books and Magazines
Magazines, Novels - Cars
Audio/Video, New and Used - Computers
Desktops, Software, Laptops, Printers - Electronics
Camera, MP3 Players, Phones, TVs - Fashion
Jewelry, Men, Miscellaneous, Women - Finance
Credit, Currency Exchange, Loans
- Health and Beauty
Perfume, Skincare, Haircare - Jobs
Full-Time, Interships, Part-Time - Miscellaneous
Other, Wanted Ads, Announcements - Real Estate
For Sale, Apartments, Sublets, For Rent - Travel
Cruises, Hotels, Flights, Vacation Deals
FLYERS: Events, Parties, etc
