select *,kc.parent_id as kcp,tc.parent_id as tcp,tc.category_id,information from kuchikomi_category as kc left join category_db_bak as tc on kc.category_id=tc.category_id group by kc.kuchikomi_category_id select * from category_db_bak select ts.school_id,school_name,is_oote,no_bbs,no_review,address,official_url,category_id from school_db as ts left join school_category as tsc on ts.school_id=tsc.school_id where ts.school_id=1080 and is_not_open<>'Y' select title,meta_kw,meta_dc from meta_db where php_self='/kuchikomi.php' and key_name='school_id' and key_value='1080'select count(kuchikomi_id) as count from kuchikomi_db where school_id=1080 and is_hidden<>'Y' select chart_db_id,count(tr.review_db_id) as count,avg(review_point) as avg from review_db as tr left join review_chart tc on tr.review_db_id=tc.review_db_id where tr.school_id=1080 and is_hidden<>'Y' group by chart_db_id order by chart_db_id asc select branch_id,count(kuchikomi_id) as count from kuchikomi_db where school_id=1080 and branch_id>0 and is_hidden<>'Y' group by branch_id select branch_id,branch_name from branch_db where school_id=1080 select school_id,school_name from school_db select count(distinct(tk.kuchikomi_id)) as count from kuchikomi_db as tk where tk.school_id=1080 and is_hidden<>'Y' and parent_id=0 select * from kuchikomi_db as tk where tk.school_id=1080 and is_hidden<>'Y' select * from kuchikomi_db as tk where tk.school_id=1080 and is_hidden<>'Y' and parent_id=0 order by tk.date_added desc limit 45,5select kuchikomi_id,parent_id,editer_id,contents,date_added,is_hidden from kuchikomi_db where school_id=1080 and is_hidden<>'Y' order by date_added asc 日本アロマコーディネータースクールの口コミ評判！アロマ・リフレクソロジー・スクール
 

（）

お気に入り登録するとマイページに更新情報が届きます。

口コミ掲示板
レビュー・評価