ORDER BY me duplica el resultado

[elexavi]

Iniciado por gnzsoloyo

Respecto a:


¿Qué dice el error?

Código:

Error
consulta SQL:  

$query = 'SELECT DISTINCT *FROM ex_awsompxgimagecaptions INNER JOIN ex_posts ON ex_awsompxgimagecaptions.capid = ex_posts.ID WHERE post_type="post" AND post_status="publish"ORDER BY post_date DESC;';



MySQL ha dicho:  

#1064 - 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 '$query = 'SELECT DISTINCT *FROM ex_awsompxgimagecaptions INNER JOIN ex_posts ON ' at line 1

creo que era porq estaba el ORDER BY junto a la ultima condidcion, vamos una tonteria