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`=446 )

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` =447 ) OR `id_group`=447)

MySQL server has gone away ,
query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =447

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`=447 )

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` =899 ) OR `id_group`=899)

MySQL server has gone away ,
query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =899

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`=899 )

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` =448 ) OR `id_group`=448)

MySQL server has gone away ,
query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =448

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`=448 )

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` =449 ) OR `id_group`=449)

MySQL server has gone away ,
query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =449

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`=449 )

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` =687 ) OR `id_group`=687)

MySQL server has gone away ,
query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =687

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`=687 )

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` =450 ) OR `id_group`=450)

MySQL server has gone away ,
query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =450

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`=450 )

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` =451 ) OR `id_group`=451)

MySQL server has gone away ,
query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =451

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`=451 )

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` =452 ) OR `id_group`=452)

MySQL server has gone away ,
query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =452

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`=452 )

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` =453 ) OR `id_group`=453)

MySQL server has gone away ,
query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =453

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`=453 )

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` =454 ) OR `id_group`=454)

MySQL server has gone away ,
query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =454

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`=454 )

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` =455 ) OR `id_group`=455)

MySQL server has gone away ,
query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =455

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`=455 )

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` =461 ) OR `id_group`=461)

MySQL server has gone away ,
query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =461

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`=461 )

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` =463 ) OR `id_group`=463)

MySQL server has gone away ,
query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =463

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`=463 )

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` =810 ) OR `id_group`=810)

MySQL server has gone away ,
query: SELECT `id` FROM `catalog_groups` WHERE `parent_id` =810

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`=810 )