CODE (SQL):
скопировать код в буфер обмена
скопировать код в буфер обмена
- SELECT
- anks.*,
- cp.id AS id_cp,
- mp.path, mp.name AS name_photo
- FROM rs_user_anketa AS anks
- LEFT JOIN rs_conf_phone AS cp ON anks.id=cp.id_anketa
- LEFT JOIN rs_ankets_photo AS mp ON anks.id=mp.id_anketa AND mp.type=1
- WHERE anks.id_user=?