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 ('60','108','1023','1024','2824','2825','2826','2827','2828','2830','1025','2476','2478','2479','2480','1026','1027','1028','1029','1030','4346','4347','4348','1031','1032','1033','1034','2817','2818','2819','2820','2821','2822','2823','1035','1036','90','647','412','1317','3067','3068','3069','3070','3071','3072','3092','2747','3844','3845','2755','3122','645','2741','2744','3091','2753','2748','3839','3840','3838','3121','3123','3126','3841','1315','3040','3041','3042','3054','1318','2742','3842','3843','2200','3125','2752','2745','3088','3729','3730','3727','3728','1307','3024','3025','3026','3027','3037','1308','3019','3020','3021','3022','3036','1309','3032','3033','3034','3035','3039','1310','3028','3029','3030','3031','3038','3127','1643','2749','2754','3726','120','3731','3732','3733','3734','2746','3089','3090','3835','2750','2751','3834','3087','1311','3062','3063','3064','3065','3066','1312','3055','3056','3057','3058','3059','3060','3120','3735','3736','1313','3043','3044','3045','3046','3047','3048','3061','1314','3059','3049','3050','3051','3052','3053','4359','410','431','451','847','3074','3722','3724','491','3457','3458','2670','3499','3500','3501','3502','2671','2672','3503','3504','2673','3492','3497','3498','3495','3496','3741','481','1709','2446','2447','2448','1710','2459','1711','2449','2450','1712','2457','2458','2452','2453','2454','2455','2456','539','137','171','3600','3601','3604','3605','3606','172','2920','2921','2922','173','402','53','2811','2812','2813','2814','2815','2816','3617','131','874','2782','2783','2784','2785','2786','2787','2788','2789','2790','2791','2792','2793','2794','2795','2796','2797','2798','2799','2800','2801','2802','2803','2804','2805','2934','330','3611','3612','3614','3615','3613','3616','2933','2935','3619','3620','2936','660','3618','2937','2938','452','765','3597','3598','3599','3804','791','2924','3622','3623','2925','764','2806','2807','2809','1144','3800','3801','3802','3803','4280','2926','2927','2928','2929','2930','2931','2932','3595','82','170','1706','3703','3704','3705','3706','3707','3708','3709','3710','3711','3712','543','5','2712','2722','3095','3096','2713','2723','3093','3094','2714','2725','3097','3099','3100','2715','2724','4112','4113','2716','2717','2726','4114','4115','4116','3987','4110','4111','38','2706','3811','3812','3813','2708','3814','3815','3816','2709','3138','3810','3817','269','2696','2697','2698','2699','2700','2701','3808','410','431','451','847','3074','3722','3724','430','2718','3079','3080','2719','3077','3078','2720','3075','3076','2721','4193','4194','3081','3085','3086','3082','3083','3084','4192','434','4','2702','2703','2704','2705','2736','542','39','3106','3107','3108','3109','3110','47','2756','2757','2758','2761','2763','4373','4374','4375','124','3111','3112','3113','3114','3115','3116','125','1452','647','412','1317','3067','3068','3069','3070','3071','3072','3092','2747','3844','3845','2755','3122','645','2741','2744','3091','2753','2748','3839','3840','3838','3121','3123','3126','3841','1315','3040','3041','3042','3054','1318','2742','3842','3843','2200','3125','2752','2745','3088','3729','3730','3727','3728','1307','3024','3025','3026','3027','3037','1308','3019','3020','3021','3022','3036','1309','3032','3033','3034','3035','3039','1310','3028','3029','3030','3031','3038','3127','1643','2749','2754','3726','120','3731','3732','3733','3734','2746','3089','3090','3835','2750','2751','3834','3087','1311','3062','3063','3064','3065','3066','1312','3055','3056','3057','3058','3059','3060','3120','3735','3736','1313','3043','3044','3045','3046','3047','3048','3061','1314','3059','3049','3050','3051','3052','3053','4359','755','2738','2939','3101','3102','3103','2940','3104','3105','2941','3132','1037','2608','41','2688','2689','2690','2691','2692','2693','2694','2695','423','3720','3721','2739','3133','2735','2737','3718','2710','8','1004','3846','3847','2733','2711','2730','2728','2729','2731','2732','3850','3852','3853','3851','3854','3855','3809','4245','544','400','3008','3368','3369','3009','3010','3011','3367','3528','401','3015','3358','3359','3360','3016','3361','3362','3363','545','3017','3018','1012','3373','509','510','3374','1260','1261','3370','3371','3372','2651','3013','75','185','990','3014','1041','1039','3313','3314','3315','3316','3317','3319','3312','3320','3321','3326','3322','3323','1040','2773','3451','3452','3716','3717','2774','2775','2776','1042','1045','1048','3134','2740','3141','3142','3223','3136','3139','3140','3137','3144','3145','3146','3859','3301','3302','3303','3304','3305','3514','3129','3130','2018','1504','50','2767','2768','2681','2682','2683','2684','2685','2686','3464','3552','453','3544','52','3535','3536','3537','3538','3534','3545','3547','3548','3549','3550','3551','122','3574','3575','3553','51','3592','3554','3574','3578','3555','3581','3582','3556','3586','3587','3557','3583','3588','3589','3584','3590','3591','3558','3580','3585','3559','51','3569','3560','51','3572','3561','51','3571','3562','3574','3576','3563','3574','3573','3564','51','3577','3565','3566','51','3579','3567','51','3575','3568','51','3575','2019','136','169','641','1480','1481','1482','1628','3437','3438','175','2675','2676','2677','2678','2679','278','2769','2770','2771','2772','3511','521','476','3479','3480','3481','522','523','524','866','3470','3471','3472','3473','3474','867','1059','1153','1305','3475','3476','3477','3478','3469','1504','50','2767','2768','2681','2682','2683','2684','2685','2686','3464','3552','3191','2773','3451','3452','3716','3717','2774','2775','3450','3459','3460','3463','3439','2665','2666','3531','3532','2667','2674','3530','2020','331','1671','135','1053','2967','3276','3277','2968','2969','3278','3279','2970','1054','2972','3281','3282','3283','3284','2974','2975','1055','2979','2980','1056','2976','3287','3288','3289','3290','2977','3292','3293','3294','3295','184','2652','3306','3304','3305','3307','2653','3308','3309','3302','2654','3131','3513','3129','3130','2655','3150','3151','3152','3153','3858','416','2964','3861','3862','3863','3864','3865','3866','3867','3868','2965','540','88','2995','2996','2997','2998','2999','3000','115','116','117','118','404','992','3001','3002','3003','3004','3005','3006','3300','3516','3517','3518','3519','3520','3521','3522','3523','3524','3525','3526','3527','546','3322','3323','89','3310','3311','3312','3313','3314','3315','3316','3317','174','488','2646','3274','547','3324','3325','3321','3326','3314','3315','3316','3317','2643','2647','2648','2644','3272','3273','2645','562','2631','274','658','2096','2633','2634','2635','2636','2637','2638','2639','2640','2632','328','414','415','458','464','762','1672','1698','2641','663','2576','126','2990','2991','2992','2993','2994','3298','661','2981','2988','2989','2982','2983','2984','2985','2986','2987','1647','2021','271','461','2656','2657','2658','2659','2661','2764','2765','2766','3135','3423','3394','3397','3398','3399','3400','3401','3402','3403','3405','2039','939','933','940','942','2043','258','1018','2155','2156','2157','1019','1020','1021','1022','2158','4118','56','49','210','211','648','1440','2046','3825','4381','282','3432','3433','454','2662','3482','3483','3484','2663','3485','3486','3487','3488','2664','3491','1655','3489','3490','3431','671','1107','1509','500','1360','235','879','2144','2145','2146','2147','2148','2540','3856','3857','1409','2150','2151','2152','2153','2154','4342','4343','229','231','1408','2215') order by products_ordered DESC, products_viewed DESC, pd.products_name ASC limit 36, 36