合宿免許のことならミツカル合宿免許

エリアの合宿免許

SCHOOL LIST

の教習所・スクール

    error

    ErrorReport
    -- NGSQL --
    select pre, COUNT(*) AS pre_cnt
            from
                contract_g_school_tbl
                inner join all_school_tbl
                    on substring( contract_g_school_tbl.d_code_g, 2 ) = all_school_tbl.d_code
                left join waribiki_tbl_1 using( d_code_g )
            where all_school_tbl.d_code < 9990
                and contract_g_school_tbl.d_code < 9990
                and    all_school_tbl.c_flg_g in (1, 2)
                and all_school_tbl.site_flg & 16
                and    all_school_tbl.d_code = contract_g_school_tbl.d_code
                and pre in ()
                and name_g is not null
            group by pre
            order by contract_g_school_tbl.d_code_g ASC