Subversion Repositories SmartDukaan

Rev

Rev 35119 | Rev 35152 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 35119 Rev 35143
Line 46... Line 46...
46 
                        "join FofoOrder o on o.id = oi.orderId " +
 46 
                        "join FofoOrder o on o.id = oi.orderId " +
47 
                        "join Item i on i.id = oi.itemId " +
 47 
                        "join Item i on i.id = oi.itemId " +
48 
                        "join PartnerRegion pr on pr.fofoId = o.fofoId " +
 48 
                        "join PartnerRegion pr on pr.fofoId = o.fofoId " +
49 
                        "where pr.regionId = :regionId " +
 49 
                        "where pr.regionId = :regionId " +
50 
                        "and i.brand = :brand " +
 50 
                        "and i.brand = :brand " +
51 
                        "and o.createTimestamp between :orderStartDate and :orderEndDate " +
 51 
                        "and ai.activationTimestamp between :orderStartDate and :orderEndDate " +
52 
                        "and not exists (select 1 from SaleRewardHistory srh where srh.imeis = ai.serialNumber) " +
 52 
                        "and not exists (select 1 from SaleRewardHistory srh where srh.imeis = ai.serialNumber) " +
53 
                        "group by li.serialNumber"
 53 
                        "group by li.serialNumber"
54 
		),
 54 
		),
55 
 
 55 
 
56 
		@NamedQuery(
 56 
		@NamedQuery(