Error 1

  1. Disk full (/tmp/#sql_368_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
    SELECT * FROM (SELECT c.id_carrier, c.id_reference, c.name, c.position, c.is_free, c.range_behavior, c.shipping_method, edc.picking_limit, edc.picking_days, edc.shippingdays, edc.min, edc.max, edc.ignore_picking, edc.ed_active, edc.ed_alias FROM `ps_carrier_shop` AS cs NATURAL JOIN ps_carrier AS c LEFT JOIN `ps_ed_carriers` AS edc USING (id_reference, id_shop) LEFT JOIN `ps_carrier_lang` AS cl USING (id_carrier, id_shop) WHERE cl.id_lang = 8 AND active = 1 AND deleted=0 AND cl.id_shop = 2 AND cs.id_shop = 2 ORDER BY c.id_reference DESC, c.id_carrier DESC) AS tmp GROUP BY id_reference