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 = 88 OR listings.subcategoryID = 82 OR listings.subcategoryID = 80 OR listings.subcategoryID = 79 OR listings.subcategoryID = 74 OR listings.subcategoryID = 75 OR listings.subcategoryID = 73 OR listings.subcategoryID = 150 OR listings.subcategoryID = 130 OR listings.subcategoryID = 131 OR listings.subcategoryID = 132 OR listings.subcategoryID = 133 OR listings.subcategoryID = 134 OR listings.subcategoryID = 136 OR listings.subcategoryID = 137 OR listings.subcategoryID = 138 OR listings.subcategoryID = 139 OR listings.subcategoryID = 140 OR listings.subcategoryID = 141 OR listings.subcategoryID = 144 OR listings.subcategoryID = 146 OR listings.subcategoryID = 147 OR listings.subcategoryID = 148 OR listings.subcategoryID = 156 OR listings.subcategoryID = 173 OR listings.subcategoryID = 174 OR listings.subcategoryID = 76 OR listings.subcategoryID = 180 OR listings.subcategoryID = 77 OR listings.subcategoryID = 78 OR listings.subcategoryID = 81) 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)