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 'ORDER BY article_date DESC LIMIT 100' at line 4
---
SELECT * FROM ams_articles
INNER JOIN ams_users ON user_id = article_author_id
WHERE article_state = 1
AND article_author_id = ORDER BY article_date DESC LIMIT 100
---
|
Articles Published: 25
|
|
Articles Published: 24
|
|
Articles Published: 20
|
|
Articles Published: 18
|
|
Articles Published: 14
|
|
Articles Published: 12
|
|
Articles Published: 12
|
|
Articles Published: 11
|
|
Articles Published: 10
|
|
Articles Published: 9
|