DB ERROR: 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 'ASC ORDER BY artistName ASC' at line 4

QUERYY:

SELECT artistName,
			COUNT(reviewID) AS total FROM reviews 
WHERE IF(alternateSort IS NULL, artistName, alternateSort) LIKE 'D%'
			GROUP BY artistName ASC
ORDER BY artistName ASC
			
			
			
debug_backtrace() (array)
0
array
file /home/stdave/daveshort.org/www/reviews/letter.php
line 20
function get
class MysqlDatabase
object
object
result [empty string]
getConnection [function]
getMysqli [function]
formatDateTime [function]
get [function]
multiQuery [function]
getField [function]
escape [function]
update [function]
query [function]
startTransaction [function]
endTransaction [function]
rollback [function]
getList [function]
getOneRow [function]
type ->
args
array
0 SELECT artistName, COUNT(reviewID) AS total FROM reviews WHERE IF(alternateSort IS NULL, artistName, alternateSort) LIKE 'D%' GROUP BY artistName ASC ORDER BY artistName ASC
1
array
file /home/stdave/daveshort.org/www/passthrough.php
line 187
function show
args
array
0
object
_parameters
array
letter
object
type 1
requiredSource 1
required TRUE
save TRUE
validate TRUE
source 1
__construct [function]
getSource [function]
getName [function]
setType [function]
getType [function]
getValue [function]
getSave [function]
setRequired [function]
setRequiredType [function]
setValidation [function]
setRequiredSource [function]
check [function]
isCorrectSource [function]
parse [function]
isCorrectType [function]
session
object
_messages
array
_taskMessages
array
_data
array
_permissions
array
_errors
array
_groups
array
__construct [function]
register [function]
getFromSession [function]
isRegistered [function]
getUser [function]
saveToSession [function]
__destruct [function]
__set [function]
__get [function]
hasMessages [function]
getMessages [function]
peekMessages [function]
addMessage [function]
addTaskMessage [function]
hasTaskMessages [function]
getTaskMessages [function]
clearTaskMessages [function]
getErrors [function]
peekErrors [function]
addError [function]
addPermission [function]
getPermission [function]
addGroup [function]
getPermissions [function]
getGroups [function]
isMemberOfGroup [function]
destroy [function]
requiredPermissions
array
requiredGroups
array
_requiredParameters
array
0 letter
_data
array
letters
array
A 4
B 9
C 4
D 4
E 3
F 5
G 6
H 2
I 1
J 0
K 1
L 2
M 3
N 5
O 1
P 5
Q 2
R 8
S 6
T 1
U 0
V 1
W 1
X 0
Y 1
Z 1
_overrideOutput [empty string]
_postvars
array
_getvars
array
letter D
__construct [function]
getAccessMethod [function]
getOutputMethod [function]
setDatabase [function]
getDatabase [function]
addRequiredPermission [function]
addRequiredGroup [function]
shouldCheck [function]
getFullPath [function]
checkPermissions [function]
checkGroups [function]
checkPage [function]
checkAccess [function]
renderPostParameters [function]
commitSession [function]
renderGetParameters [function]
__get [function]
__set [function]
addHeader [function]
headerNow [function]
getAjaxPath [function]
getRelativeAjaxPath [function]
getCurrentPage [function]
get [function]
post [function]
getGet [function]
getPost [function]
redirectRelative [function]
redirectAbsolute [function]
redirectFromRoot [function]
getHeaders [function]
isOutputOverridden [function]
debug [function]
getDebugData [function]
getFilePath [function]
getWebPath [function]
getRequestPath [function]
getRequestMethod [function]
isGetVar [function]
isPostVar [function]
getReferer [function]
getData [function]
addRequiredParameter [function]
isHTTPS [function]
getFullURI [function]
checkParameters [function]
cleanURL [function]
filterVariable [function]
arrayToQueryString [function]