string(1327) "SELECT g.goods_id,g.erp_goods_id,g.goods_code,g.goods_name,g.base_name,g.goods_unit,g.license_number,g.manufacture_factory,g.goods_spec,g.brand_id,g.class_id,g.original,g.main_img,g.keyword,g.goods_convert_s,g.goods_convert_m,g.goods_convert_b,g.is_close,g.is_self,g.is_limit_depart,g.act_price,g.act_begin_date,g.act_end_date,g.is_act,g.create_time,g.goods_sales,g.is_tsy,g.storage_id FROM zdb_goods_info g left join zdb_tongda_xiajiapinzhong as p on g.goods_code = p.itemno WHERE ( p.itemno is null ) AND g.is_close = 0 AND g.is_del = 0 AND `is_tsy` = 0 AND g.goods_jixing = '硬胶囊' AND ( ( ( g.goods_name LIKE '%东阿%' ) OR ( g.base_name LIKE '%东阿%' ) OR ( g.keyword LIKE '%东阿%' ) OR g.manufacture_factory LIKE '%东阿%' ) AND ( g.goods_depot > 0 ) ) AND g.brand_id = '7' AND g.is_self = 0 AND ( g.goods_id NOT IN (3981,3694,222757,217680,4221,2453,1362,2583,4175,639,630,585,568,1545,4896,8443,202849,217283,213167,214290,1341,4183,3044,4309,9282,210895,6631,23,38,3387,142,5543,3014,3659,724,5786,712,196419,879,197717,575,208044,209421,211877,213420,213423,1709,3470,1408,11599,1848,374,1950,5082,3324,196484,2550,2845,980,219966,34,15992,207516,6317,3773,216451,219480,2452,16664,5790,419,970,19787,17842,5175,199589,2898,4482,4620,211603,5919,218521,2827) ) GROUP BY g.goods_id ORDER BY sort asc "
string(1178) "SELECT g.goods_id,g.erp_goods_id,g.goods_code,g.goods_name,g.base_name,g.goods_unit,g.license_number,g.manufacture_factory,g.goods_spec,g.brand_id,g.class_id,g.original,g.main_img,g.keyword,g.goods_convert_s,g.goods_convert_m,g.goods_convert_b,g.is_close,g.is_self,g.is_limit_depart,g.act_price,g.act_begin_date,g.act_end_date,g.is_act,g.create_time,g.goods_sales,g.is_tsy,g.storage_id FROM zdb_goods_info g left join zdb_goods_tag as gt on gt.goods_id = g.goods_id left join zdb_tongda_xiajiapinzhong as p on g.goods_code = p.itemno WHERE ( p.itemno is null ) AND g.is_close = 0 AND g.is_del = 0 AND `is_tsy` = 0 AND g.is_self = 0 AND ( g.goods_id NOT IN (3981,3694,222757,217680,4221,2453,1362,2583,4175,639,630,585,568,1545,4896,8443,202849,217283,213167,214290,1341,4183,3044,4309,9282,210895,6631,23,38,3387,142,5543,3014,3659,724,5786,712,196419,879,197717,575,208044,209421,211877,213420,213423,1709,3470,1408,11599,1848,374,1950,5082,3324,196484,2550,2845,980,219966,34,15992,207516,6317,3773,216451,219480,2452,16664,5790,419,970,19787,17842,5175,199589,2898,4482,4620,211603,5919,218521,2827) ) AND gt.tag_id = 3 GROUP BY g.goods_id ORDER BY sort desc,main_img desc "
ICP备案号：冀ICP备17029999 互联网药品信息服务资格证（冀）-经营性-2018-0001
本网站未发布毒性药品、麻醉药品、精神药品、放射性药品、戒毒药品和医疗机构制剂的产品信息
Copyright@2012-2019 河北媒渠电子商务有限公司（技术支持）
