Title / Description
Code select hh.affiSid, hh.affiName, hh.seedCode, hh.seedKind, hh.seedValue, j.seedName, ifnull(hh.category, '') category, ifnull(g.codeName,'') categoryName, hh.regDateTime from (select ee.affisid, ee.affiname, aa.seedCode, aa.seedKind, aa.seedValue, category, concat(aa.regDate, aa.regTime) regDateTime from (select cmpid, seedCode, seedKind, seedValue, category, affisid, regDate, regTime from SeedHistory_${searchYearMonth}) aa , (select dishttp://coderay.rubychan.de/doc/tinct cmpid from AffiliationMember where memberid=#{userid}) bb, (select affisid, affiname from AffiliationService) ee where aa.cmpid = bb.cmpid and aa.affisid = ee.affisid) hh left outer join Code g on g.codeId = hh.category left outer join SeedCode j on j.seedCode = hh.seedCode where 1=1
Author
Highlight as C C++ CSS Clojure Delphi ERb Groovy (beta) HAML HTML JSON Java JavaScript PHP Plain text Python Ruby SQL XML YAML diff code
1.1.2
1.1.2