sql连表查询

SELECT

    dk.id,

    dg.NAME,

    GROUP_CONCAT( db.device_desc SEPARATOR ' / ' ) AS `device_desc`,

    ada.sn,

    UNIX_TIMESTAMP( dk.lasttime ) AS lasttime,

    dk.stability,

    ada.start_time,

    ada.end_time,

    ada.signal_types,

    ada.activate,

    ada.STATUS,

    ada.age_limit

FROM

    `wp_agent_device_auth` `ada`

    LEFT JOIN `wp_device_band` `db` ON `db`.`device_id` = ada.device_id

    AND `db`.garden_id > 0

    AND `db`.`pid` IN ( 19095, 16368, 16222 )

    LEFT JOIN `wp_device_key` `dk` ON `ada`.`device_id` = `dk`.`id`

    LEFT JOIN `wp_data_garden` `dg` ON `dg`.`garden_id` = `db`.`garden_id`

WHERE

    ( `ada`.`agent_id` = 19095 AND `dg`.is_del = 0 AND `dg`.is_rand = 0 )

GROUP BY

    `dk`.`sn`

ORDER BY

    `dk`.`id` DESC