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 ('2027','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','541','2887','3227','157','281','761','435','1652','435','759','760','761','995','1014','1049','1652','1697','3228','3229','4146','72','625','4154','4162','4166','4171','155','73','4160','4163','4169','4201','4202','4203','797','758','1050','4161','4164','4172','4149','624','1646','4167','4168','4195','4150','994','4155','4156','4157','4174','4151','4155','4174','4156','994','4157','4152','4151','4155','4174','4156','994','4157','4153','4173','4165','1694','797','758','1050','4161','4164','4172','4153','4173','4165','1694','4158','1694','4165','4173','4170','4196','4197','4198','4199','4200','4188','4205','4206','4207','4208','4209','4147','4175','71','160','161','993','4183','4176','1645','1695','4185','4177','4181','161','993','4183','71','160','4182','4178','627','757','1696','4184','4186','4178','627','757','1696','4184','4186','4179','156','626','4148','4187','4215','4180','4181','161','993','4183','71','160','4182','4189','4210','4211','4212','4213','4214','4216','4159','78','79','2872','2868','3999','4000','2873','3982','3984','3985','2874','2869','3995','3996','2875','2870','3997','3998','2876','3981','3983','3992','2877','3988','3989','3990','2878','275','3986','3991','2879','2871','3993','3994','3979','3980','3999','2868','4000','2875','2870','3997','3998','4123','3993','2871','3994','3980','3999','2868','4000','4119','4120','4121','4122','4123','3993','2871','3994','168','2901','2606','4043','4044','4045','4012','4040','4041','4042','2902','2603','4035','4036','4037','4038','4039','4007','4026','4027','4028','4029','4030','2904','2605','4031','4032','4033','4017','4023','4024','4025','4083','2905','2604','4009','2906','4019','4020','2907','2601','4006','4001','4003','2600','2899','2900','2903','2602','2582','2607','4018','4011','4013','4046','4047','4014','4048','4049','2901','2606','4043','4044','4045','4012','4040','4041','4042','4002','4013','4046','4047','4014','4048','4049','4003','2600','2899','2900','2903','2602','2582','2607','4018','4005','2600','2899','2900','2903','2602','2582','2607','4018','4010','4015','4016','4011','4013','4046','4047','4014','4048','4049','411','1228','2569','2579','3936','3937','2583','2864','2865','3938','3939','2866','2867','3948','3936','3937','3949','2866','3948','3936','3937','433','2850','2854','2855','2856','2857','3942','2847','2848','2851','3943','2849','2852','2853','3944','2848','2847','2851','3945','3946','3947','3944','2848','2847','2851','2850','449','2889','2890','756','2897','2898','4075','4085','4056','4063','2894','4077','4078','4079','2599','4061','4075','4085','4072','2895','4073','4074','4279','4088','4057','4080','4089','4059','4064','4081','4082','4084','4060','4067','4061','4075','4085','4062','2599','2894','4077','4078','4079','4063','2894','4077','4078','4079','2599','4065','2896','4066','4068','4069','4070','4071','4087','4072','2895','4073','4074','4279','4088','1005','2858','2727','3848','3978','2860','3966','3967','2861','3972','3973','2862','2863','3970','3971','3951','3960','3961','3976','3952','3968','3969','3953','3958','3959','3975','3954','2859','3964','3965','3977','3955','3962','3963','3956','3950','3951','3960','3961','3976','3952','3968','3969','2860','3966','3967','3957','3951','3960','3961','3976','3952','3968','3969','2860','3966','3967','3974','2032','1452','80','162','2590','4133','4134','2591','4127','4139','4140','4128','4137','4138','2598','4135','4136','2593','4141','4142','2594','4131','4132','2595','2596','4129','4130','2597','4139','4140','2598','4135','4136','4125','4137','4138','4126','4143','4144','4127','4139','4140','4128','4137','4138','163','4008','2763','2762','4090','2759','2760','4376','2578','2840','2841','2842','2843','2844','2845','2846','3940','3941','2581','3930','41','2688','2689','2690','2691','2692','2693','2694','2695','396','2832','2833','2834','2835','2836','2837','2838','2839','3931','4076','2888','2891','2893','4124','81','2892') order by products_ordered desc, products_viewed DESC, pd.products_name limit 0, 36