医薬品キーワード検索

システムエラー
エラーコード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 '%蜀咲匱蝙九倥Ν繝壹せ%' or item_m_name like '%蜀咲匱蝙九倥Ν繝壹せ%' or explanation like '%蜀咲匱蝙九倥Ν繝壹せ%' or new_genre like '%蜀咲匱蝙九倥Ν繝壹せ%' or new_1 like '%蜀咲匱蝙九倥Ν繝壹せ%' or new_2 like '%蜀咲匱蝙九倥Ν繝壹せ%' THEN 0 ELSE 1 END) as element_0 FROM page_search_mst where avail_flg = 1 and ( ( keyword like '%蜀咲匱蝙九倥Ν繝壹せ%' or item_m_name like '%蜀咲匱蝙九倥Ν繝壹せ%' or explanation like '%蜀咲匱蝙九倥Ν繝壹せ%' or new_genre like '%蜀咲匱蝙九倥Ν繝壹せ%' or new_1 like '%蜀咲匱蝙九倥Ν繝壹せ%' or new_2 like '%蜀咲匱蝙九倥Ν繝壹せ%')) ) 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 '蜀咲匱蝙九倥Ν繝壹せ%' THEN 0 ELSE 1 END),c.date desc