Disk full (/tmp/#sql-temptable-22c-5fc661-131f0b.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`='16546HC250' OR brand_oem_search='16546HC250') ccv
LEFT JOIN `catalog_parts_vendors` cpv ON (cpv.part_search='16546HC250' OR cpv.part_search=ccv.brand_oem_search) AND cpv.shipper_id=ccv.shipper_id
WHERE (cpv.part_search='16546HC250' 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-5fc661-131f0c.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='16546HC250' OR ccv.brand_oem_search='16546HC250' )
Error DB:
Disk full (/tmp/#sql-temptable-22c-5fc661-131f0d.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='16546HC250' )
Error DB:
Disk full (/tmp/#sql-temptable-22c-5fc661-131f0e.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 '%16546HC250%' OR cpv.part_search='16546HC250' OR ccv.brand_other_oem_search='16546HC250' OR ccv.brand_oem_search='16546HC250' )
Error DB:
Disk full (/tmp/#sql-temptable-22c-5fc661-131f0f.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 '%16546HC250%' OR cpv.`part_search`='16546HC250' OR ccv.`brand_other_oem_search`='16546HC250' OR ccv.`brand_oem_search`='16546HC250' )
Error DB:
Disk full (/tmp/#sql-temptable-22c-5fc661-131f10.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 '%16546HC250%' OR cpv.`part_search`='16546HC250' OR ccv.`brand_other_oem_search`='16546HC250' OR ccv.`brand_oem_search`='16546HC250' )
Error DB:
Disk full (/tmp/#sql-temptable-22c-5fc661-131f14.MAI); waiting for someone to free some space... (errno: 28 "No space left on device"), query:SELECT DISTINCT
p_local.price price_local,
c.*,
(SELECT
`price`
FROM `catalog_price` cp
WHERE c.id=cp.`id_good` AND cp.`id_discount_group`=14 ) price_krs_retail,
if( (SELECT SUM(cda.`avail`) FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN(2,4,10,11,12,14,15,16,17,18) ) > 0 , 1, 0) total_availble,
(SELECT SUM(cda.`avail`) FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (4) ) av_retail_uss_shops,
(SELECT SUM(cda.`avail`) FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (14) ) av_krs_opt,
(SELECT SUM(cda.`avail`) FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (15) ) av_hbr_opt,
(SELECT SUM(cda.`avail`) FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (16) ) av_komar_opt,
(SELECT SUM(cda.`avail`) FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (17) ) av_vl_opt,
(SELECT SUM(cda.`avail`) FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (18) ) av_art_opt,
(SELECT
`price`
FROM `catalog_price` cp
WHERE c.id=cp.id_good AND cp.`id_discount_group`= 5) price_vl_retail,
(SELECT
`price`
FROM `catalog_price` cp
WHERE c.id=cp.id_good AND cp.`id_discount_group`=15 ) price_krs_opt,
(SELECT
`price`
FROM `catalog_price` cp
WHERE c.id=cp.id_good AND cp.`id_discount_group`=11 ) price_hbr_opt,
(SELECT
SUM(cda.`avail`) sum
FROM `catalog_avail` cda
WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (2,17) ) av_vl,
(SELECT
SUM(cda.`avail`) sum
FROM `catalog_avail` cda
WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (10,15) ) av_hbr,
(SELECT
SUM(cda.`avail`) sum
FROM `catalog_avail` cda
WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (11,14) ) av_krs,
(SELECT
SUM(cda.`avail`) sum
FROM `catalog_avail` cda
WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (12,18) ) av_art,
(SELECT
SUM(cda.`avail`) sum
FROM `catalog_avail` cda
WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN ( SELECT `id` FROM `catalog_shops` WHERE `depot_id`=5 AND `is_retail`=1 ) ) av_uss,
(SELECT COUNT(*) FROM `billing_basket` WHERE `status`='get' AND `price_id`=c.`id` AND `depot_id`=5 AND `user`='c9edaf7109b3a78797c70f9c9e8fe433' AND `user`!='' ) inbasketuss,
(SELECT COUNT(*) FROM `billing_basket` WHERE `status`='get' AND `price_id`=c.`id` AND `depot_id`=1 AND `user`='c9edaf7109b3a78797c70f9c9e8fe433' AND `user`!='' ) inbasketvl,
(SELECT COUNT(*) FROM `billing_basket` WHERE `status`='get' AND `price_id`=c.`id` AND `depot_id`=3 AND `user`='c9edaf7109b3a78797c70f9c9e8fe433' AND `user`!='' ) inbaskethbr,
(SELECT COUNT(*) FROM `billing_basket` WHERE `status`='get' AND `price_id`=c.`id` AND `depot_id`=4 AND `user`='c9edaf7109b3a78797c70f9c9e8fe433' AND `user`!='' ) inbasketkrs,
(SELECT COUNT(*) FROM `billing_basket` WHERE `status`='get' AND `price_id`=c.`id` AND `depot_id`=6 AND `user`='c9edaf7109b3a78797c70f9c9e8fe433' AND `user`!='' ) inbasketart,
p_vl.price price_vl,
IF( c.markingsearch = '16546hc250' , 1, 0 ) is_m_equality,
p_krs.price price_krs,
IF(
(
(
c.markingsearch LIKE '16546hc250'
OR c.name='16546hc250'
OR (SELECT COUNT(*) FROM catalog_oem WHERE (oemsearch LIKE '16546hc250%' OR oem='16546hc250' ) AND `id_good`=c.`id` ) > 0
OR c.searchindex LIKE '%16546hc250%'
OR ( ( c.name LIKE '%16546hc250%') )
OR ( ( CONCAT_WS(' ', c.f_name, c.mark,c.model,c.chassis,c.engine,c.f_body) LIKE '%16546hc250%') )
OR ( ( replace(c.`searchindex`,' ','') LIKE '%16546hc250%') )
OR ( ( replace(c.`searchindex`,' ','') LIKE '%16546hc250%') )
)
),
1,0
) st,
IF(
(
(
c.markingsearch LIKE '16546hc250'
OR ( SELECT COUNT(*) FROM catalog_oem WHERE (oemsearch LIKE '16546hc250%' OR oem='16546hc250' ) AND `id_good`=c.`id` ) > 0
OR ( ( replace(c.searchindex,' ','') LIKE '%16546hc250%') )
)
),
1,0
) morf,
b.brand,
cg.name `group_name`,
(SELECT oem FROM catalog_oem WHERE (oemsearch LIKE '16546hc250%' OR oem='16546hc250' ) AND `id_good`=c.`id` LIMIT 1) oemtarget,
(SELECT GROUP_CONCAT(DISTINCT co.oem ORDER BY co.oem ASC SEPARATOR ', ') FROM catalog_oem co WHERE co.`id_good`=c.`id` ) oem
FROM `catalog` c
LEFT JOIN `brands` b ON c.brand_id=b.id
LEFT JOIN `catalog_groups` cg ON c.id_group=cg.id
LEFT JOIN `catalog_price` p_vl ON c.id=p_vl.id_good AND p_vl.`id_discount_group`= 5
LEFT JOIN `catalog_price` p_local ON c.id=p_local.id_good AND p_local.`id_discount_group`= 5
LEFT JOIN `catalog_price` p_krs ON c.id=p_krs.id_good AND p_krs.`id_discount_group`= 14
WHERE ( p_vl.price>0 OR p_krs.price>0 OR (SELECT COUNT(*) FROM `catalog_future` WHERE id1c = c.id_1c AND datein > NOW())>0) AND
( c.is_delete=0 AND
(c.hideavailble=0 OR (c.hideavailble =1
AND (SELECT SUM(cda.avail) sum FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id`)>0 ) ))
AND (
c.markingsearch LIKE '16546hc250%'
OR c.name = '16546hc250'
OR c.id IN ( SELECT id_good FROM catalog_oem WHERE oemsearch LIKE '16546hc250%' OR oem='16546hc250')
OR ( ( c.name LIKE '%16546hc250%') )
OR
( ( CONCAT_WS(' ', c.f_name, c.mark,c.model,c.chassis,c.engine,c.f_body) LIKE '%16546hc250%') )
)
AND (
(SELECT
COUNT(*) cnt
FROM `catalog_avail` cda
WHERE
cda.`date_in` !=''
AND cda.`date_in` IS NOT NULL
AND cda.`id_good`=c.`id`
AND cda.`id_shop` IN (SELECT `id` FROM `catalog_shops` WHERE 1=1 AND `is_opt`=1 )
)>0
OR (p_vl.`price`>0 OR p_krs.`price`>0 OR (SELECT COUNT(*) FROM `catalog_future` WHERE id1c = c.id_1c AND datein > NOW())>0 ) )
ORDER BY is_m_equality DESC,morf DESC,st DESC,av_vl DESC ,c.id
* При отсутствии запрашиваемой детали на основном складе АВТОДЕПО, мы предлагаем поставку с
удаленного склада. Здесь указан срок доставки до основного склада и готовность к отгрузке.
Мы используем cookie-файлы. Для получения дополнительной информации вы можете ознакомиться с Политикой конфиденциальности.
