Получайте только важные новости
Два раза в неделю Вам на почту будут приходить информация об акциях, поставках и распродажах
query: SELECT e.id, e.name1 AS name, e.anons1 AS anons, e.timeedit, e.site_id, e.brand_id, e.no_buy, e.article, e.hit, e.new, e.action, e.is_file, COUNT(g.good_id) AS count_good FROM `diafan_shop` AS e INNER JOIN `diafan_shop_order_goods` AS g ON g.good_id=e.id AND g.good_id<>19391 INNER JOIN `diafan_shop_order_goods` AS eg ON eg.order_id=g.order_id AND eg.good_id=19391 LEFT JOIN `diafan_access` AS a ON a.element_id=e.id AND a.module_name='shop' AND a.element_type='element' WHERE e.act1='1' AND e.trash='0' AND e.date_start<=1611262740 AND (e.date_finish=0 OR e.date_finish>=1611262740) AND (e.access='0' OR e.access='1' AND a.role_id=1) AND e.name1 !='' GROUP BY e.id ORDER BY count_good DESC LIMIT 0, 10