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='loans' or pcategory.nameid='loans' group by item.itemid order by item.lastupdatedate desc limit 0,10]
Got error 122 from storage engine
No items found in Finance > Loans
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='finance' or pcategory.nameid='finance' group by item.itemid order by item.lastupdatedate desc limit 0,10]
Got error 122 from storage engine
- Books and Magazines
Novels, Magazines - Cars
New and Used, Audio/Video - Computers
Printers, Desktops, Laptops, Software - Electronics
Camera, MP3 Players, Phones, TVs - Fashion
Women, Jewelry, Men, Miscellaneous - 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
Vacation Deals, Cruises, Hotels, Flights
FLYERS: Events, Parties, etc
