Se connecter
Inscription
Mot de passe perdu
Supprimer un message
cauet
pffffff..surement po.
SELECT DISTINCT e. * , c.status, c.msgid, DATE_FORMAT( e.date, '%d/%m/%Y %H:%i:%s' ) AS date_send
FROM envoi_push e
LEFT OUTER JOIN confirm_push c ON c.msgid = e.status
WHERE type = 'BE'
HAVING max( c.id )
ORDER BY date DESC
LIMIT 0 , 40
il ne me renvoie plus qu'1 seul enregistrement..
SELECT DISTINCT e. * , c.status, c.msgid, DATE_FORMAT( e.date, '%d/%m/%Y %H:%i:%s' ) AS date_send
FROM envoi_push e
LEFT OUTER JOIN confirm_push c ON c.msgid = e.status
WHERE type = 'BE'
HAVING max( c.id )
ORDER BY date DESC
LIMIT 0 , 40
il ne me renvoie plus qu'1 seul enregistrement..
