CODE (sql):
скопировать код в буфер обмена
скопировать код в буфер обмена
- SELECT D.id,sender_id,recipient_id,send_notifications, S.id AS sender_id, R.id AS recipient_id, R.name AS recipient_name, R.birthday AS recipient_birthday, R.STATUS AS recipient_status, R.sex AS recipient_sex, R.last_activity_at AS recipient_last_activity_at, BS.id AS im_blakcklist, BR.id AS youare_blakcklist, LM.id AS last_message
- FROM dialogs D
- JOIN users S ON S.id=IF(93=sender_id, sender_id, recipient_id)
- JOIN users R ON R.id=IF(93=recipient_id, sender_id, recipient_id)
- LEFT JOIN blacklist BS ON BS.uid=S.id AND BS.who=R.id
- LEFT JOIN blacklist BR ON BR.uid=R.id AND BR.who=S.id
- WHERE ((sender_id=93 AND recipient_id!=93) OR (sender_id!=93 AND recipient_id=93))
- ORDER BY id DESC LIMIT 0,16