医薬品キーワード検索

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