医薬品キーワード検索

システムエラー
エラーコード003
復旧までしばらくお待ちください
SELECT c.page_id,item_code,item_name,item_m_name,category_id,category_child_id,explanation,date,dvance_flg,status,c.group_id_order_1_1 FROM ( SELECT page_id,item_code,item_name,dvance_flg,status FROM item_mst where avail_flg = 1 order by item_price asc ) AS d, ( 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, CASE WHEN group_id_order_1_1 IS NULL THEN 999 WHEN group_id_order_1_1 = '' THEN 999 ELSE group_id_order_1_1 END as group_id_order_1_1 FROM page_mst where avail_flg = 1 ) AS c WHERE m.page_id = c.page_id and m.page_id = d.page_id ORDER BY status asc ,c.group_id_order_1_1 asc, m.element_0, (CASE WHEN item_m_name LIKE '繧「繝ャ繝ォ繧ョ繝シ諤ァ鮠サ轤%' THEN 0 ELSE 1 END),c.date desc