MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=29 OR c.`id_group` IN (29,30,927,928,31,929,930,32,35,37,38,792,793,40,41,939,43,44,46,48,699,700,701,702,703,49,704,705,706,707,708,709,710,50,746,747,748,53,54,605,690) )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =840 ) OR `id_group`=840)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =840
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=840 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =56 ) OR `id_group`=56)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =56
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=56 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =68 ) OR `id_group`=68)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =68
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=68 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =69 ) OR `id_group`=69)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =69
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=69 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =107 ) OR `id_group`=107)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =107
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=107 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =2 ) OR `id_group`=2)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =2
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=2 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =865 ) OR `id_group`=865)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =865
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=865 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =216 ) OR `id_group`=216)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =216
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=216 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =45 ) OR `id_group`=45)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =45
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=45 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =217 ) OR `id_group`=217)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =217
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=217 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =464 ) OR `id_group`=464)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =464
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=464 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =692 ) OR `id_group`=692)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =692
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=692 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =51 ) OR `id_group`=51)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =51
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=51 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =505 ) OR `id_group`=505)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =505
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=505 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =866 ) OR `id_group`=866)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =866
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=866 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =529 ) OR `id_group`=529)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =529
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=529 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =535 ) OR `id_group`=535)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =535
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=535 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =549 ) OR `id_group`=549)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =549
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=549 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =562 ) OR `id_group`=562)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =562
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=562 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =867 ) OR `id_group`=867)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =867
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=867 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =868 ) OR `id_group`=868)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =868
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=868 )
Error DB:
MySQL server has gone away , query: SELECT COUNT(*) `cnt` FROM `catalog` WHERE `is_delete`=0 AND (`id_group` IN ( SELECT id FROM `catalog_groups` WHERE `parent_id` =563 ) OR `id_group`=563)
Error DB:
MySQL server has gone away , query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =563
Error DB:
MySQL server has gone away , query:
SELECT
COUNT(*) `count`
FROM `catalog` c
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_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.`hideavailble`=0
OR (c.`hideavailble` =1
AND (SELECT SUM(cda.avail) `sum` FROM `catalog_avail` cda WHERE cda.`id_good`=c.`id` )>0
)
)
)
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 ) )
AND ( c.`id_group`=563 )
