医薬品キーワード検索

システムエラー
エラーコード003
復旧までしばらくお待ちください
SELECT c.page_id,item_code,item_name,item_m_name,category_id,category_child_id,explanation,date,dvance_flg,status FROM ( SELECT page_id,item_m_name,explanation ,(CASE WHEN keyword like '%謔」驛ィ縺ォ蝪励k縺縺代〒鮗サ驟泌柑譫懊′縺ゅj縺セ縺吶ゅお繝繝ゥ繧ッ繝ェ繝シ繝,繝ゥ繧ッ繧オ繝シ繝ォ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟碑脈,騾夊イゥ,繝ェ繝峨き繧、繝ウ繧ィ繝繝ゥ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟,鮗サ驟斐け繝ェ繝シ繝,蛟倶ココ霈ク蜈・,繝ェ繝峨き繧、繝ウ%' or item_m_name like '%謔」驛ィ縺ォ蝪励k縺縺代〒鮗サ驟泌柑譫懊′縺ゅj縺セ縺吶ゅお繝繝ゥ繧ッ繝ェ繝シ繝,繝ゥ繧ッ繧オ繝シ繝ォ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟碑脈,騾夊イゥ,繝ェ繝峨き繧、繝ウ繧ィ繝繝ゥ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟,鮗サ驟斐け繝ェ繝シ繝,蛟倶ココ霈ク蜈・,繝ェ繝峨き繧、繝ウ%' or explanation like '%謔」驛ィ縺ォ蝪励k縺縺代〒鮗サ驟泌柑譫懊′縺ゅj縺セ縺吶ゅお繝繝ゥ繧ッ繝ェ繝シ繝,繝ゥ繧ッ繧オ繝シ繝ォ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟碑脈,騾夊イゥ,繝ェ繝峨き繧、繝ウ繧ィ繝繝ゥ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟,鮗サ驟斐け繝ェ繝シ繝,蛟倶ココ霈ク蜈・,繝ェ繝峨き繧、繝ウ%' or new_genre like '%謔」驛ィ縺ォ蝪励k縺縺代〒鮗サ驟泌柑譫懊′縺ゅj縺セ縺吶ゅお繝繝ゥ繧ッ繝ェ繝シ繝,繝ゥ繧ッ繧オ繝シ繝ォ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟碑脈,騾夊イゥ,繝ェ繝峨き繧、繝ウ繧ィ繝繝ゥ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟,鮗サ驟斐け繝ェ繝シ繝,蛟倶ココ霈ク蜈・,繝ェ繝峨き繧、繝ウ%' or new_1 like '%謔」驛ィ縺ォ蝪励k縺縺代〒鮗サ驟泌柑譫懊′縺ゅj縺セ縺吶ゅお繝繝ゥ繧ッ繝ェ繝シ繝,繝ゥ繧ッ繧オ繝シ繝ォ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟碑脈,騾夊イゥ,繝ェ繝峨き繧、繝ウ繧ィ繝繝ゥ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟,鮗サ驟斐け繝ェ繝シ繝,蛟倶ココ霈ク蜈・,繝ェ繝峨き繧、繝ウ%' or new_2 like '%謔」驛ィ縺ォ蝪励k縺縺代〒鮗サ驟泌柑譫懊′縺ゅj縺セ縺吶ゅお繝繝ゥ繧ッ繝ェ繝シ繝,繝ゥ繧ッ繧オ繝シ繝ォ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟碑脈,騾夊イゥ,繝ェ繝峨き繧、繝ウ繧ィ繝繝ゥ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟,鮗サ驟斐け繝ェ繝シ繝,蛟倶ココ霈ク蜈・,繝ェ繝峨き繧、繝ウ%' THEN 0 ELSE 1 END) as element_0 FROM page_search_mst where avail_flg = 1 and ( ( keyword like '%謔」驛ィ縺ォ蝪励k縺縺代〒鮗サ驟泌柑譫懊′縺ゅj縺セ縺吶ゅお繝繝ゥ繧ッ繝ェ繝シ繝,繝ゥ繧ッ繧オ繝シ繝ォ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟碑脈,騾夊イゥ,繝ェ繝峨き繧、繝ウ繧ィ繝繝ゥ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟,鮗サ驟斐け繝ェ繝シ繝,蛟倶ココ霈ク蜈・,繝ェ繝峨き繧、繝ウ%' or item_m_name like '%謔」驛ィ縺ォ蝪励k縺縺代〒鮗サ驟泌柑譫懊′縺ゅj縺セ縺吶ゅお繝繝ゥ繧ッ繝ェ繝シ繝,繝ゥ繧ッ繧オ繝シ繝ォ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟碑脈,騾夊イゥ,繝ェ繝峨き繧、繝ウ繧ィ繝繝ゥ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟,鮗サ驟斐け繝ェ繝シ繝,蛟倶ココ霈ク蜈・,繝ェ繝峨き繧、繝ウ%' or explanation like '%謔」驛ィ縺ォ蝪励k縺縺代〒鮗サ驟泌柑譫懊′縺ゅj縺セ縺吶ゅお繝繝ゥ繧ッ繝ェ繝シ繝,繝ゥ繧ッ繧オ繝シ繝ォ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟碑脈,騾夊イゥ,繝ェ繝峨き繧、繝ウ繧ィ繝繝ゥ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟,鮗サ驟斐け繝ェ繝シ繝,蛟倶ココ霈ク蜈・,繝ェ繝峨き繧、繝ウ%' or new_genre like '%謔」驛ィ縺ォ蝪励k縺縺代〒鮗サ驟泌柑譫懊′縺ゅj縺セ縺吶ゅお繝繝ゥ繧ッ繝ェ繝シ繝,繝ゥ繧ッ繧オ繝シ繝ォ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟碑脈,騾夊イゥ,繝ェ繝峨き繧、繝ウ繧ィ繝繝ゥ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟,鮗サ驟斐け繝ェ繝シ繝,蛟倶ココ霈ク蜈・,繝ェ繝峨き繧、繝ウ%' or new_1 like '%謔」驛ィ縺ォ蝪励k縺縺代〒鮗サ驟泌柑譫懊′縺ゅj縺セ縺吶ゅお繝繝ゥ繧ッ繝ェ繝シ繝,繝ゥ繧ッ繧オ繝シ繝ォ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟碑脈,騾夊イゥ,繝ェ繝峨き繧、繝ウ繧ィ繝繝ゥ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟,鮗サ驟斐け繝ェ繝シ繝,蛟倶ココ霈ク蜈・,繝ェ繝峨き繧、繝ウ%' or new_2 like '%謔」驛ィ縺ォ蝪励k縺縺代〒鮗サ驟泌柑譫懊′縺ゅj縺セ縺吶ゅお繝繝ゥ繧ッ繝ェ繝シ繝,繝ゥ繧ッ繧オ繝シ繝ォ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟碑脈,騾夊イゥ,繝ェ繝峨き繧、繝ウ繧ィ繝繝ゥ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟,鮗サ驟斐け繝ェ繝シ繝,蛟倶ココ霈ク蜈・,繝ェ繝峨き繧、繝ウ%')) ) AS m, ( SELECT page_id,category_id,category_child_id,date FROM page_mst where avail_flg = 1 ) AS c, ( SELECT page_id,item_code,item_name,dvance_flg,status FROM item_mst where avail_flg = 1 ) AS d WHERE m.page_id = c.page_id and m.page_id = d.page_id ORDER BY status, m.element_0, (CASE WHEN item_m_name LIKE '謔」驛ィ縺ォ蝪励k縺縺代〒鮗サ驟泌柑譫懊′縺ゅj縺セ縺吶ゅお繝繝ゥ繧ッ繝ェ繝シ繝,繝ゥ繧ッ繧オ繝シ繝ォ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟碑脈,騾夊イゥ,繝ェ繝峨き繧、繝ウ繧ィ繝繝ゥ繧ッ繝ェ繝シ繝,陦ィ髱「鮗サ驟,鮗サ驟斐け繝ェ繝シ繝,蛟倶ココ霈ク蜈・,繝ェ繝峨き繧、繝ウ%' THEN 0 ELSE 1 END),c.date desc