error2select m_shop.shop_id,shop_name,shop_catchcopy,shop_info,top_img_fn,img_fn1,sum(d_pc_session+d_sp_session+d_tb_session) as se,sum(d_pc_pageview+d_sp_pageview+d_tb_pageview) as pv,cat_pname from x_daily_analytics left join m_shop on x_daily_analytics.shop_id = m_shop.shop_id left join m_shop_category on m_shop.shop_cat_p = m_shop_category.cat_pcd where (d_date >= '2018-07-16' and d_date < '2018-07-15') and m_shop.master_area='kita' and m_shop.del_flg='N' and m_shop.shop_disp='Y' group by m_shop.shop_id,shop_name,shop_catchcopy,shop_info,top_img_fn,img_fn1,cat_pname order by se desc,pv desc limit 20 offset 0