Unable to run pageCountDisk full (/tmp/#sql-temptable-71ed-65f197c-1db6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")SELECT COUNT(*) AS recCount FROM (SELECT DISTINCT p.*,c.CatName,AvailableSizes,AvailableColors FROM products p
								LEFT JOIN categories c ON (p.CategoryID1=c.id)
								LEFT JOIN products_categories pc ON (p.id=pc.ProductID)
								LEFT JOIN subproducts sp ON (p.id=sp.ProductID AND sp.Visible=1 AND sp.Deleted=0)
								LEFT JOIN (SELECT  ProductID,
									GROUP_CONCAT(DISTINCT sp.ItemSize ORDER BY sp.Priority,ItemSize)as AvailableSizes,
									GROUP_CONCAT(DISTINCT sp.ItemColor ORDER BY sp.Priority,ItemColor) as AvailableColors
									FROM subproducts sp INNER JOIN products p ON sp.productid=p.id WHERE sp.Visible=1 AND sp.Deleted=0
									AND	1

									GROUP BY ProductID
								) sp2 ON (p.id=sp2.ProductID)
						    WHERE 1 AND p.`Deleted`=0  AND p.Visible=1 AND   ( CategoryID1 IN (44,84,52,53,51,127,50,78,116,89,107,106,111,92,117,41,90,118,93,91,85,108,109,48,125,120,79,126,112,86,105,119,81,46,55,100,43,42,129,54,56,121,40,102,83,47,95,76,122,101,58,99,113,103,80,114,104,110,87,57,98,17,18,19,11,12,13,77,131,94,59,115,45,123,88,124) OR CategoryID2 IN (44,84,52,53,51,127,50,78,116,89,107,106,111,92,117,41,90,118,93,91,85,108,109,48,125,120,79,126,112,86,105,119,81,46,55,100,43,42,129,54,56,121,40,102,83,47,95,76,122,101,58,99,113,103,80,114,104,110,87,57,98,17,18,19,11,12,13,77,131,94,59,115,45,123,88,124) )   AND  p.visible=1  AND ( CategoryID1 IN (4 , 60 , 61 , 62 , 63 , 64 , 65 , 66 , 67 , 68 , 69 , 70 , 71 , 72 , 73 , 74 , 128 , 131 , 83 , 84 , 85 , 86 , 87 , 88 , 89 , 90 , 91 , 92 , 93 , 94 , 95 , 98 , 99 , 100 , 101 , 102 , 103 , 104 , 105 , 106 , 107 , 108 , 109 , 110 , 111 , 112 , 113 , 114 , 115 , 116 , 117 , 118 , 119 , 120 , 121 , 122 , 123 , 124 , 125 , 126 , 129)
						or
					    CategoryID2 IN (4 , 60 , 61 , 62 , 63 , 64 , 65 , 66 , 67 , 68 , 69 , 70 , 71 , 72 , 73 , 74 , 128 , 131 , 83 , 84 , 85 , 86 , 87 , 88 , 89 , 90 , 91 , 92 , 93 , 94 , 95 , 98 , 99 , 100 , 101 , 102 , 103 , 104 , 105 , 106 , 107 , 108 , 109 , 110 , 111 , 112 , 113 , 114 , 115 , 116 , 117 , 118 , 119 , 120 , 121 , 122 , 123 , 124 , 125 , 126 , 129)
						or
					    CategoryID IN (4 , 60 , 61 , 62 , 63 , 64 , 65 , 66 , 67 , 68 , 69 , 70 , 71 , 72 , 73 , 74 , 128 , 131 , 83 , 84 , 85 , 86 , 87 , 88 , 89 , 90 , 91 , 92 , 93 , 94 , 95 , 98 , 99 , 100 , 101 , 102 , 103 , 104 , 105 , 106 , 107 , 108 , 109 , 110 , 111 , 112 , 113 , 114 , 115 , 116 , 117 , 118 , 119 , 120 , 121 , 122 , 123 , 124 , 125 , 126 , 129)
						)
					 ) as t