|
R
ragrim author
Ive written a custom query ti display some data and i know the query works cause it displays results in the query builder and i have tested it in navicat mysql, but when i go to view my list page i get an error.
Here is the query
SELECT userinfo.User_ID
, userinfo.FirstName
, userinfo.LastName
, userinfo.Phone
, userinfo.Mobile
, userinfo.Email2
, userinfo.Email
, userinfo.PostCode
, userinfo.Suburb
, userinfo.Address
, userinfo.`State`
, userinfo.DOB
, userinfo.SecondCardName
, userinfo.BusinessName
, userinfo.Concession
, userinfo.CreatedBy
, userinfo.Proof
, subscribernumbers.SubNumber
, subtransactions.Expires
, subtransactions.`SubType`
, membernumbers.MemNumber
, userinfo.Datecreated
, userinfo.LastModified
, subtransactions.RecieptNum
, subtransactions.TransDate
, subtransactions.PaymentType
FROM userinfo
INNER
JOIN subscribernumbers
ON subscribernumbers.FKUserID = userinfo.User_ID
AND subscribernumbers.SubNumber > 0
INNER
JOIN ( SELECT FKSubNum
, MAX(TransDate) AS max_trans
FROM subtransactions
GROUP
BY FKSubNum ) AS m
ON m.FKSubNum = subscribernumbers.SubNumber
INNER
JOIN subtransactions
ON subtransactions.FKSubNum = subscribernumbers.SubNumber
AND subtransactions.TransDate = m.max_trans
INNER
JOIN membernumbers
ON membernumbers.FKUserID = userinfo.User_ID
ORDER
BY subscribernumbers.SubNumber DESC
, subtransactions.TransDate DESC
And here is the error i get when i try to view the list page for that query
description You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY subscribernumbers.SubNumber DESC , subtransactions.TransDate ' at line 1 |
|