1 2 3 4 5 6 7 8 9 10 11 12 13 14
|
$query2= 'SELECT he.msg, he.date, he.id AS hid, he.type, pc.nom, ft.fromto, ft.persoid, ft.description, p.sexe, p.imgurl, s.expiration
FROM (
SELECT sstbl.msgid
FROM cc_he_fromto sstbl
WHERE sstbl.`show` = 1 AND sstbl.persoid = ' . $PERSO_VAR['id'] . '
LIMIT ' . ($hepage*$itemperpage) . ',' . $itemperpage . '
) as sq
LEFT JOIN '.DB_PREFIX.'he AS he ON (he.id=sq.msgid)
LEFT JOIN '.DB_PREFIX.'he_fromto AS ft ON ( ft.msgid = he.id )
LEFT JOIN '.DB_PREFIX.'perso_connu AS pc ON ( pc.persoid = ft.persoid AND pc.nomid = ft.persoid )
LEFT JOIN '.DB_PREFIX.'perso AS p ON ( p.id = ft.persoid )
LEFT JOIN '.DB_PREFIX.'session AS s ON ( s.user = p.user )
ORDER BY he.`' . $orderby . '` ' . $ordertype . ', hid ASC, ft.fromto ASC , pc.nom ASC'; |
Partager