1 - Can't create/write to file '/tmp/#sql_19b3_0.MYI' (Errcode: 28)
select p.sold_in_bundle_only, p.products_ordered, p.products_image, pd.products_name, m.manufacturers_name, p.products_id, p.products_model, pd.products_description, p.products_weight, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.tukkuhinta from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '3' and p2c.categories_id IN ('1','23','94','952','2254','2255','955','2241','2242','1507','1968','1686','2213','2284','2271','2272','2273','2274','3635','4096','4097','4403','97','948','1908','2506','949','2234','2235','2502','1685','2008','2009','2250','3634','4219','2218','2252','2277','2260','2263','2275','2503','3633','2507','2510','2513','2514','3737','3738','4091','4092','4098','4401','598','572','1950','1951','1952','2104','1506','1959','1960','1687','1966','1967','1953','1954','1955','1956','2517','2467','2468','2469','3636','4099','4100','599','445','2232','571','2236','2237','2238','2239','1693','2094','2100','2101','2102','2103','2185','2186','2187','2283','3679','3680','2229','2261','2264','2265','2266','2267','2269','2282','2561','3637','3638','4094','4095','4238','4240','4241','4242','4402','739','738','3664','3665','3666','3667','3668','3669','3670','3671','3672','740','3640','3641','3642','3643','3646','3647','3648','3649','3644','3645','744','1707','3674','3675','3676','3677','2286','3650','3651','3652','3653','3654','3655','3656','3657','3658','3659','3660','3661','3662','3663','4263','4264','4265','4266','4335','4336','4337','4338','4339','4340','4341','2508','4093','827','570','1713','1714','1715','2285','3833','4262','1368','1716','1717','4360','1689','1690','2240','1692','2230','2251','2007','3827','2511','2512','3189','3190','3739','3740','4289','24','1970','575','1978','1979','1982','1983','2291','2293','2294','1636','1701','1976','1977','2204','1971','2471','2472','2473','3702','1972','536','2298','2299','576','2178','2180','2182','2184','2292','1669','2296','2297','1699','2206','2207','2208','2209','2210','2465','2295','2097','2486','1973','962','2288','3253','1974','818','1537','2304','1975','767','2302','2303','1670','1700','2300','2301','2098','2099','816','3181','3182','3183','3187','1664','3184','3185','3186','3188','2474','2475','2487','1984','1987','1986','2179','2287','2289','2466','601','1879','1880','1881','1882','1883','1884','2067','2068','1885','2065','3217','3218','3219','2311','1496','20','1909','347','1910','346','517','1553','2488','1911','1912','1913','28','1917','1941','2202','1918','1560','1703','1919','1920','1921','1947','1923','1924','1926','1927','1939','1940','1928','1135','1938','1929','1931','2088','1932','1935','1942','1933','1934','1943','1944','1946','2306','421','1886','1893','1895','2000','2497','2498','1906','1887','1890','1891','2001','2002','2492','1905','1888','594','1897','1898','2221','1900','1901','1988','1989','1990','1902','1992','1993','1994','1995','1996','2225','2490','2491','1903','1997','1998','1904','2003','2493','2494','2495','2004','2496','2005','2223','2224','1704','421','20','1909','347','1910','346','517','1553','2488','1911','1912','1913','28','1917','1941','2202','1918','1560','1703','1919','1920','1921','1947','1923','1924','1926','1927','1939','1940','1928','1135','1938','1929','1931','2088','1932','1935','1942','1933','1934','1943','1944','1946','2306','22','106','967','1343','1676','1684','27','261','606','1565','1680','1683','602','2072','2073','2075','2307','2519','2070','2089','2309','2310','2071','1551','1561','1877','2080','421','20','1909','347','1910','346','517','1553','2488','1911','1912','1913','28','1917','1941','2202','1918','1560','1703','1919','1920','1921','1947','1923','1924','1926','1927','1939','1940','1928','1135','1938','1929','1931','2088','1932','1935','1942','1933','1934','1943','1944','1946','2306','2081','2085','2188','2189','2190','2521','2522','2523','2524','2086','2191','2192','2193','2525','2198','945','947','2082','2197','2308','2083','2194','2520','2084','2196','2087','2195') order by products_ordered DESC, products_viewed DESC, pd.products_name ASC limit 36, 36