の合宿免許
SCHOOL LIST
の合宿免許一覧
-
error
ErrorReport
-- NGSQL --
select *,
contract_g_school_tbl.d_code_g as d_code_g1
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 =
and name_g is not null
order by contract_g_school_tbl.d_code_g ASC