public tomcat object image etc flash network file sarge sql redhat regex php open linux install java mysql code find ssh ubuntu search error manager seam class issues debian flickr
SELECT
SUM(p.orderTransaction.transAmount)
FROM
Payment
AS
p
JOIN
p.memberPaymentMethod
AS
mpm
JOIN
mpm.paymentMethod
AS
pm
JOIN
p.orderTransaction
AS
ot
WHERE
ot.currency.currencyCode = 'GBP'
AND
mpm.creationDate >= '01/01/2008'
AND
mpm.creationDate <= '01/07/2009'
AND
(p.authorisationCode IS NOT NULL OR pm.paymentMethodId NOT IN (8,4))
