Subcategories
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 = 110 OR listings.subcategoryID = 109 OR listings.subcategoryID = 119 OR listings.subcategoryID = 117 OR listings.subcategoryID = 115 OR listings.subcategoryID = 113 OR listings.subcategoryID = 171 OR listings.subcategoryID = 111 OR listings.subcategoryID = 120 OR listings.subcategoryID = 121 OR listings.subcategoryID = 122 OR listings.subcategoryID = 124 OR listings.subcategoryID = 125 OR listings.subcategoryID = 126 OR listings.subcategoryID = 153 OR listings.subcategoryID = 154) 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)