Error DB:
MySQL server has gone away ,
query: SELECT * FROM `configuration`
Error DB: MySQL server has gone away ,
query: SELECT * FROM `meta_info` WHERE `url_string`='main'
Error DB: MySQL server has gone away ,
query:
SELECT DISTINCT gs.region,gs.city FROM geo_coord g
LEFT JOIN geo_city gs ON gs.id=g.id_geocities
WHERE gs.region IS NOT NULL AND g.`start` <= 3628718228 AND g.`finish` >= 3628718228
Error DB: MySQL server has gone away ,
query: SELECT * FROM `catalog_shops` WHERE `id_1c`!='' AND `id_1c` IS NOT NULL ORDER BY `sort` ASC
Error DB: MySQL server has gone away ,
query: SELECT * FROM `catalog_depots` cda WHERE cda.`is_delete`=0 ORDER BY cda.`name`
Error DB: MySQL server has gone away ,
query: SELECT
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,5,10,11,12,14,15,16,17,18,19) ) > 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,19) ) av_retail_uss_shops,
(SELECT SUM(cda.`avail`) FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` AND cda.`id_shop` IN (19) ) av_retail_komar,
(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`=4 ) price_krs_opt,
(SELECT
`price`
FROM `catalog_price` cp
WHERE c.id=cp.id_good AND cp.`id_discount_group`=4 ) 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`='edfb224a42314ce599d7ab4d473cee9f' AND `user`!='' ) inbasketuss,
(SELECT COUNT(*) FROM `billing_basket` WHERE `status`='get' AND `price_id`=c.`id` AND `depot_id`=1 AND `user`='edfb224a42314ce599d7ab4d473cee9f' AND `user`!='' ) inbasketvl,
(SELECT COUNT(*) FROM `billing_basket` WHERE `status`='get' AND `price_id`=c.`id` AND `depot_id`=3 AND `user`='edfb224a42314ce599d7ab4d473cee9f' AND `user`!='' ) inbaskethbr,
(SELECT COUNT(*) FROM `billing_basket` WHERE `status`='get' AND `price_id`=c.`id` AND `depot_id`=4 AND `user`='edfb224a42314ce599d7ab4d473cee9f' AND `user`!='' ) inbasketkrs,
(SELECT COUNT(*) FROM `billing_basket` WHERE `status`='get' AND `price_id`=c.`id` AND `depot_id`=6 AND `user`='edfb224a42314ce599d7ab4d473cee9f' AND `user`!='' ) inbasketart,
p_vl.price price_vl,
p_vl.price_old price_old_vl,
p_krs.price price_krs,
p_krs.price_old price_old_krs,
p_local.price price_local,
p_local.price_old price_old_local,
b.brand,
(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_price` p_vl ON c.id=p_vl.`id_good` AND p_vl.`id_discount_group`=5
LEFT JOIN `catalog_price` p_krs ON c.id=p_krs.`id_good` AND p_krs.`id_discount_group`=14
LEFT JOIN `catalog_price` p_local ON c.id=p_local.`id_good` AND p_local.`id_discount_group`=5
WHERE
(
c.`is_delete`=0 AND c.`is_hide`=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.`id`=11732
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 c.`id`