3. Query Error 3: Error writing file '/tmp/MYfd=3035' (OS errno 28 - No space left on device)
Query: SELECT p.*,p.id
FROM shop_product p
JOIN shop_product_features pf1
ON p.id = pf1.product_id
JOIN shop_category_products cp1
ON p.id = cp1.product_id
WHERE p.status = 1
AND p.status = 1
AND pf1.feature_id = 4 AND pf1.feature_value_id IN (2)
AND cp1.category_id IN(2,265,266,267,268,269,270,271,272,159,208,209,210,258,259,276,277,278,262,263,264,200,198,177,202,203,186,187,188,189,190,191,192,193,194,195,197,204,205,206,207,275,254,256,257,233,234,235,236,237,238,239,240,242,294,260,251,282,283,287,289,290,284,285,286,211,212,214,215,216,217,218,219,222,224,225,226,227,228,229,230,231,232,273,274,244,245,280,249,250,295,291,292,293,296,298,300,304,305,306,309,307,308,321,332,335,336,337,340)
GROUP BY p.id
ORDER BY p.price ASC, p.id
LIMIT 4710,30