1021 - Disk full (/tmp/#sql_deb6_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

select p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_weight, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_ordered, p.products_oldprice, p.products_tax_class_id_oldprice, p.products_youtube, p.products_enable_seo, p.skroutz_enable, p.skroutz_mpn, p.skroutz_isbn, p.skroutz_sizes, p.intnum1, p.intnum2, p.intnum3, p.intnum4, p.intnum5, p.intnum6, p.doublenum1, p.doublenum2, p.doublenum3, p.doublenum4, p.doublenum5, p.doublenum6, p.booleannum1, p.booleannum2, p.booleannum3, p.booleannum4, p.booleannum5, p.booleannum6, p.booleannum7, p.booleannum8, p.booleannum9, p.booleannum10, p.datenum1, p.datenum2, p.datenum3, p.datenum4, p.datenum5, p.datenum6, p.products_table1, p.products_table2, p.products_table3, p.products_table4, p.products_table5, p.products_table6, p.file1, p.file2, p.file3, p.file4, p.file5, p.file6, p.file7, p.file8, pd.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, pd.products_viewed, pd.tags, pd.seo_title, pd.seo_description, pd.seo_keywords, pd.text1, pd.text2, pd.text3, pd.text4, pd.text5, pd.text6, pd.keimeno1, pd.keimeno2, pd.keimeno3, pd.keimeno4, pd.keimeno5, pd.keimeno6, p2c.products_id, p2c.categories_id, ptb1.table1_titlos, ptb2.table2_titlos, ptb3.table3_titlos, ptb4.table4_titlos, ptb5.table5_titlos, m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, mi.manufacturers_id, mi.manufacturers_url, mi.manufacturers_titlos, fpa.products_attributes_total_id, fpa.options_values_id from products_description pd, products_to_categories p2c, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_table1 ptb1 on p.products_table1 = ptb1.products_table1_id and ptb1.language_id='1' left join products_table2 ptb2 on p.products_table2 = ptb2.products_table2_id and ptb2.language_id='1' left join products_table3 ptb3 on p.products_table3 = ptb3.products_table3_id and ptb3.language_id='1' left join products_table4 ptb4 on p.products_table4 = ptb4.products_table4_id and ptb4.language_id='1' left join products_table5 ptb5 on p.products_table5 = ptb5.products_table5_id and ptb5.language_id='1' left join manufacturers_info mi on m.manufacturers_id = mi.manufacturers_id and mi.languages_id='1' left join filters_products_attributes_total fpa on p.products_id = fpa.products_id where p.products_status = '1' and p.products_id = pd.products_id and p.products_date_available <= '2018-02-19 7:44:10' and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id in (249) group by p2c.products_id order by p.products_table1 asc, p.products_date_available desc

[TEP STOP]