pdo error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND instrument.instrument_type = 1 AND instrument.active_flg = 1 AND i' at line 1] in EXECUTE("SELECT instrument.name AS inst_name, type1_name.type_name AS inst_type1, type2_name.type_name AS inst_type2, instrument.fee_type AS fee_type, FORMAT(instrument.fee_hour, 0) AS fee_price, inst_type_id.type1_id AS type1_id, inst_type_id.type2_id AS type2_id , instrument.instrument_id AS inst_id FROM noahdb.mst_instruments AS instrument INNER JOIN noahdb.mst_instrument_types AS inst_type_id ON instrument.instrument_id = inst_type_id.instrument_id and inst_type_id.deleted = 0 LEFT JOIN noahdb.mst_instrument_genre AS inst_genre ON instrument.instrument_id = inst_genre.instrument_id and inst_genre.deleted = 0 LEFT OUTER JOIN noahdb.mst_type AS type1_name ON inst_type_id.type1_id = type1_name.id LEFT OUTER JOIN noahdb.mst_type AS type2_name ON inst_type_id.type2_id = type2_name.id WHERE instrument.installed_branch_id = AND instrument.instrument_type = 1 AND instrument.active_flg = 1 AND instrument.school_only = 0 AND inst_genre.genre_id = 2 AND instrument.deleted = 0 GROUP BY type1_name.type_name , type2_name.type_name , instrument.name ORDER BY type1_name.display_order ASC, type2_name.display_order ASC, instrument.display_order ASC, instrument.instrument_id ASC; ")





STUDIOサウンドスタジオノア 店舗一覧