Subcategories
| Cars 1979 and Older (1) | Cars 1980-89 (0) | Cars 1990-99 (2) | Cars 2000-09 (15) | Miscellaneous (23) |
| Motorcycles (4) | Trucks 1979 and Older (0) | Trucks 1980-89 (0) | Trucks 1990-99 (1) | Trucks 2000-09 (18) |
SELECT DISTINCT listings.listingID, title, price, priceType, description, dateListed, year, model,
subcategories.subcategoryTitle, subcategories.subcategoryID, companyName, phone, locationID, sold, type
FROM listings, subcategories, maincategories, members
WHERE listings.subcategoryID = subcategories.subcategoryID
AND subcategories.maincategoryID = maincategories.maincategoryID
AND listings.memberID = members.memberID
AND listings.active = 1
AND members.active=1 AND (listings.subcategoryID = 84 OR listings.subcategoryID = 66 OR listings.subcategoryID = 4 OR listings.subcategoryID = 65 OR listings.subcategoryID = 45 OR listings.subcategoryID = 71 OR listings.subcategoryID = 70 OR listings.subcategoryID = 68 OR listings.subcategoryID = 67 OR listings.subcategoryID = 64) ORDER BY dateListed DESC LIMIT 0,30:
Can't create/write to file '/tmp/#sql_774e_0.MYD' (Errcode: 17)
Can't create/write to file '/tmp/#sql_774e_0.MYD' (Errcode: 17)