if ($sec['showFilials'] == 'any') {
            $sql = 'SELECT p.id,p.id1C,p.name,p.url,p.photo,p.minOrder,p.factor,p.properties,pr.price,p.prices,p.onStore,p.type,p.top100,p.stock,p.hit,p.onRequest,p.articul,
            shp.idSection,IF((SELECT COUNT(`idProduce`) FROM `produce_store` WHERE `idProduce` = p.id AND `idFilial` IN(' . $_SESSION['idFilial'] . ',' . implode(',', $this->store) . '))>0,1,0) as `onStore`,SUM(ps.cnt) as `cnt`
          FROM  `sections_has_produce`as shp
          INNER JOIN `produce` as p on shp.idProduce = p.id AND p.status = 1
          INNER JOIN `produce_prices` as pr ON pr.idProduce = p.id AND (pr.idFilial = ' . $_SESSION['idFilial'] . ' OR pr.idFilial = 1)
           LEFT JOIN `produce_store`as ps on ps.idProduce = p.id AND ps.idFilial IN(' . $_SESSION['idFilial'] . ',' . implode(',', $this->store) . ')
           ' . (!$sec['showVariants'] ? 'LEFT JOIN `produce_variants` as pv on pv.idVariant = p.id ' : '') . '
          ' . (!empty($filters['sql']['join']) ? implode(' ', $filters['sql']['join']) : '') . '
          WHERE shp.idSection IN('.implode(',',$ids).')  AND (p.onStore = 1 OR p.onRequest = 1) ' . $minOrderWhere . '
           ' . ($sec['showNoPhoto'] ? '' : ' AND p.photo IS NOT NULL') .
                ($sec['showGroups'] ? ' AND p.groups IN(' . $sec['showGroups'] . ')' : '') .
                (!$sec['showVariants'] ? ' AND pv.idProduce IS NULL ' : '') .
                $query_filter . '
          GROUP BY p.id ' . $query_sort . $limit;
            $sqlCount = 'SELECT COUNT(DISTINCT p.id) FROM  `sections_has_produce`as shp
          INNER JOIN `produce` as p on shp.idProduce = p.id AND p.status = 1
          INNER JOIN `produce_prices` as pr ON pr.idProduce = p.id AND pr.idFilial = ' . $_SESSION['idFilial'] . '
          LEFT JOIN `produce_store`as ps on ps.idProduce = p.id AND ps.idFilial IN(' . $_SESSION['idFilial'] . ',' . implode(',', $this->store) . ')
          ' . (!$sec['showVariants'] ? 'LEFT JOIN `produce_variants` as pv on pv.idVariant = p.id ' : '') . '
          ' . (!empty($filters['sql']['join']) ? implode(' ', $filters['sql']['join']) : '') . '
          WHERE shp.idSection IN('.implode(',',$ids).') AND (p.onStore = 1 OR p.onRequest = 1) ' . $minOrderWhere . '
          ' . ($sec['showNoPhoto'] ? '' : ' AND p.photo IS NOT NULL') .
                ($sec['showGroups'] ? ' AND p.groups IN(' . $sec['showGroups'] . ')' : '') .
                (!$sec['showVariants'] ? ' AND pv.idProduce IS NULL ' : '') .
                $query_filter;
        } elseif ($sec['showFilials'] == 'all') {
            $sql = 'SELECT p.id,p.id1C,p.name,p.url,p.photo,p.minOrder,p.factor,p.properties,pr.price,p.prices,pr_msk.price as msk_price,p.onStore,p.type,p.top100,p.stock,p.hit,p.onRequest,p.articul,
            shp.idSection,IF((SELECT COUNT(`idProduce`) FROM `produce_store` WHERE `idProduce` = p.id AND `idFilial` IN(' . $_SESSION['idFilial'] . ',' . implode(',', $this->store) . '))>0,1,0) as `onStore`,SUM(ps.cnt) as `cnt`
          FROM  `sections_has_produce`as shp
          INNER JOIN `produce` as p on shp.idProduce = p.id AND p.status = 1
          LEFT JOIN `produce_prices` as pr ON pr.idProduce = p.id AND (pr.idFilial = ' . $_SESSION['idFilial'] . ' OR pr.idFilial = 1)
          LEFT JOIN `produce_prices` as pr_msk ON pr_msk.idProduce = p.id AND pr_msk.idFilial = 1
          LEFT JOIN `produce_store`as ps on ps.idProduce = p.id
          ' . (!$sec['showVariants'] ? 'LEFT JOIN `produce_variants` as pv on pv.idVariant = p.id ' : '') . '
          ' . (!empty($filters['sql']['join']) ? implode(' ', $filters['sql']['join']) : '') . '
          WHERE shp.idSection IN('.implode(',',$ids).')  ' . $minOrderWhere . '
           ' . ($sec['showNoPhoto'] ? '' : ' AND p.photo IS NOT NULL') .
                ($sec['showGroups'] ? ' AND p.groups IN(' . $sec['showGroups'] . ')' : '') .
                (!$sec['showVariants'] ? ' AND pv.idProduce IS NULL ' : '') .
                $query_filter . '
          GROUP BY p.id ' . $query_sort . $limit;
            $sqlCount = 'SELECT COUNT( DISTINCT p.id) FROM  `sections_has_produce`as shp
          INNER JOIN `produce` as p on shp.idProduce = p.id AND p.status = 1
               LEFT JOIN `produce_store`as ps on ps.idProduce = p.id AND ps.idFilial IN(' . $_SESSION['idFilial'] . ',' . implode(',', $this->store) . ')' . (!$sec['showVariants'] ? 'LEFT JOIN `produce_variants` as pv on pv.idVariant = p.id ' : '') . '
          ' . (!empty($filters['sql']['join']) ? implode(' ', $filters['sql']['join']) : '') . '
          WHERE shp.idSection IN('.implode(',',$ids).') ' . $minOrderWhere . '
           ' . ($sec['showNoPhoto'] ? '' : ' AND p.photo IS NOT NULL') .
                ($sec['showGroups'] ? ' AND p.groups IN(' . $sec['showGroups'] . ')' : '') .
                (!$sec['showVariants'] ? ' AND pv.idProduce IS NULL ' : '') .
                $query_filter;
        } else {
            $sql = 'SELECT p.id,p.id1C,p.name,p.url,p.photo,p.minOrder,p.factor,pr.price,p.properties,p.prices,p.onStore,p.type,p.top100,p.stock,p.hit,p.onRequest,p.articul,
            shp.idSection,IF((SELECT COUNT(`idProduce`) FROM `produce_store` WHERE `idProduce` = p.id AND `idFilial` IN(' . $_SESSION['idFilial'] . ',' . implode(',', $this->store) . '))>0,1,0) as `onStore`,SUM(ps.cnt) as `cnt`
          FROM  `sections_has_produce`as shp
          INNER JOIN `produce` as p on shp.idProduce = p.id AND p.status = 1
          INNER JOIN `produce_prices` as pr ON pr.idProduce = p.id AND (pr.idFilial = ' . $_SESSION['idFilial'] . ' OR pr.idFilial = 1)
          LEFT JOIN `produce_store`as ps on ps.idProduce = p.id AND ps.idFilial IN(' . $_SESSION['idFilial'] . ',' . implode(',', $this->store) . ')
          ' . (!$sec['showVariants'] ? 'LEFT JOIN `produce_variants` as pv on pv.idVariant = p.id ' : '') . '
          ' . (!empty($filters['sql']['join']) ? implode(' ', $filters['sql']['join']) : '') . '
          WHERE (ps.cnt IS NOT NULL OR p.onRequest = 1) AND shp.idSection IN('.implode(',',$ids).')  ' . $minOrderWhere . '
           ' . ($sec['showNoPhoto'] ? '' : ' AND p.photo IS NOT NULL') .
                ($sec['showGroups'] ? ' AND p.groups IN(' . $sec['showGroups'] . ')' : '') .
                (!$sec['showVariants'] ? ' AND pv.idProduce IS NULL ' : '') .
                $query_filter . '
          GROUP BY p.id ' . $query_sort . $limit;
            $sqlCount = 'SELECT COUNT( DISTINCT p.id) FROM  `sections_has_produce`as shp
          INNER JOIN `produce` as p on shp.idProduce = p.id AND p.status = 1
           INNER JOIN `produce_prices` as pr ON pr.idProduce = p.id AND pr.idFilial = ' . $_SESSION['idFilial'] . '
               LEFT JOIN `produce_store`as ps on ps.idProduce = p.id AND ps.idFilial IN(' . $_SESSION['idFilial'] . ',' . implode(',', $this->store) . ')
                ' . (!$sec['showVariants'] ? 'LEFT JOIN `produce_variants` as pv on pv.idVariant = p.id ' : '') . '
          ' . (!empty($filters['sql']['join']) ? implode(' ', $filters['sql']['join']) : '') . '
          WHERE (ps.cnt IS NOT NULL OR p.onRequest = 1) AND shp.idSection IN('.implode(',',$ids).')  ' . $minOrderWhere . '
           ' . ($sec['showNoPhoto'] ? '' : ' AND p.photo IS NOT NULL') .
                ($sec['showGroups'] ? ' AND p.groups IN(' . $sec['showGroups'] . ')' : '') .
                (!$sec['showVariants'] ? ' AND pv.idProduce IS NULL ' : '') .
                $query_filter;
        }