Disk full (/tmp/#sql-temptable-22c-5fda71-132b28.MAI); waiting for someone to free some space... (errno: 28 "No space left on device"), query:
SELECT
DISTINCT cpv.*
FROM
(SELECT brand_oem_search,shipper_id FROM `catalog_crosses_vendors` WHERE `brand_other_oem_search`='8MK 376 770151' OR brand_oem_search='8MK 376 770151') ccv
LEFT JOIN `catalog_parts_vendors` cpv ON (cpv.part_search='8MK 376 770151' OR cpv.part_search=ccv.brand_oem_search) AND cpv.shipper_id=ccv.shipper_id
WHERE (cpv.part_search='8MK 376 770151' OR cpv.part_search=ccv.brand_oem_search) AND cpv.availble!=''
AND cpv.shipper_id IN (
SELECT id FROM `billing_shipper` WHERE id IN (12,7,10,13,14,15,16,17,18,19,20,21,24,25,26,27,28,29,35,36,37,38,39,41,43,44,2,47,50,53,54,55,56,58,57,59,63,65,66,68,69,70,71,72,73,74,75,76,77,78,79,80,82,83,84,85) AND `is_delete`=0
) LIMIT 100
Error DB:
Disk full (/tmp/#sql-temptable-22c-5fda71-132b29.MAI); waiting for someone to free some space... (errno: 28 "No space left on device"), query:
SELECT DISTINCT cpv.*,cpdv.oem oems FROM catalog_parts_vendors cpv
LEFT JOIN billing_shipper bs ON cpv.shipper_id=bs.id
LEFT JOIN catalog_crosses_vendors ccv ON ccv.brand_other_oem_search=cpv.part_search
LEFT JOIN catalog_parts_descr_vendors cpdv ON cpdv.marking_search=cpv.part_search AND cpdv.shipper_id=11
WHERE bs.is_delete=0 AND cpv.shipper_id=11 AND cpv.availble!='' AND
( cpv.part_search='8MK 376 770151' OR ccv.brand_oem_search='8MK 376 770151' )
Error DB:
Disk full (/tmp/#sql-temptable-22c-5fda71-132b2a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device"), query:
SELECT DISTINCT cpv.* FROM catalog_parts_vendors cpv
LEFT JOIN billing_shipper bs ON cpv.shipper_id=bs.id
WHERE bs.is_delete=0 AND cpv.shipper_id=69 AND cpv.availble!='' AND
( cpv.part_search='8MK 376 770151' )
Error DB:
Disk full (/tmp/#sql-temptable-22c-5fda71-132b2b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device"), query:
SELECT DISTINCT cpv.* FROM catalog_parts_vendors cpv
LEFT JOIN catalog_crosses_vendors ccv ON ccv.brand_oem_search=cpv.part_search
WHERE cpv.shipper_id=82 AND cpv.availble!='' AND ( cpv.`name` LIKE '%8MK 376 770151%' OR cpv.part_search='8MK 376 770151' OR ccv.brand_other_oem_search='8MK 376 770151' OR ccv.brand_oem_search='8MK 376 770151' )
Error DB:
Disk full (/tmp/#sql-temptable-22c-5fda71-132b2c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device"), query:
SELECT DISTINCT cpv.* FROM catalog_parts_vendors cpv
LEFT JOIN catalog_crosses_vendors ccv ON ccv.brand_oem_search=cpv.part_search
WHERE cpv.shipper_id=83 AND cpv.availble!='' AND ( cpv.`name` LIKE '%8MK 376 770151%' OR cpv.`part_search`='8MK 376 770151' OR ccv.`brand_other_oem_search`='8MK 376 770151' OR ccv.`brand_oem_search`='8MK 376 770151' )
Error DB:
Disk full (/tmp/#sql-temptable-22c-5fda71-132b2d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device"), query:
SELECT DISTINCT cpv.* FROM catalog_parts_vendors cpv
LEFT JOIN catalog_crosses_vendors ccv ON ccv.brand_oem_search=cpv.part_search
WHERE cpv.shipper_id=84 AND cpv.availble!='' AND ( cpv.`name` LIKE '%8MK 376 770151%' OR cpv.`part_search`='8MK 376 770151' OR ccv.`brand_other_oem_search`='8MK 376 770151' OR ccv.`brand_oem_search`='8MK 376 770151' )