医薬品キーワード検索

システムエラー
エラーコード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