Subversion Repositories SmartDukaan

Rev

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

Rev 8625 Rev 8626
Line 114... Line 114...
114 
        SUM((age >= 1 and age < 2) * currentQuantity) AS oneToTwoCount,
114 
        SUM((age >= 1 and age < 2) * currentQuantity) AS oneToTwoCount,
115 
        SUM((age >= 2 and age < 3) * currentQuantity) AS twoToThreeCount,
115 
        SUM((age >= 2 and age < 3) * currentQuantity) AS twoToThreeCount,
116 
        SUM((age >= 3 and age < 4) * currentQuantity) AS threeToFourCount,
116 
        SUM((age >= 3 and age < 4) * currentQuantity) AS threeToFourCount,
117 
        SUM((age >= 4) * currentQuantity) as fourPlusCount,
 117 
        SUM((age >= 4) * currentQuantity) as fourPlusCount,
118 
        SUM((age >= 1) * currentQuantity) as onePlusCount,
 118 
        SUM((age >= 1) * currentQuantity) as onePlusCount,
- 
 
 119 
        SUM((age >= 13) * currentQuantity) as threeMonthPlusCount,
- 
 
 120 
        SUM((age >= 26) * currentQuantity) as sixMonthPlusCount,
119 
        SUM((age >= 1) * unitPrice) as onePlusCost,
 121 
        SUM((age >= 1) * unitPrice) as onePlusCost,
120 
        SUM(currentQuantity) as zeroPlusCount,
 122 
        SUM(currentQuantity) as zeroPlusCount,
121 
        SUM(l.unitPrice) as zeroPlusCost,
 123 
        SUM(l.unitPrice) as zeroPlusCost,
122 
        l.productGroup as category
 124 
        l.productGroup as category
123 
    FROM  (SELECT ii.id, ii.itemId, ii.currentQuantity, ii.purchaseId,
 125 
    FROM  (SELECT ii.id, ii.itemId, ii.currentQuantity, ii.purchaseId,