SELECT  app_dispositius.device, app_notificacions_push.* FROM app_notificacions_push  JOIN app_dispositius on app_dispositius.id=app_notificacions_push.id_dispositiu WHERE  app_notificacions_push.estat = '0'  ORDER BY app_notificacions_push.data_creat DESC  LIMIT 30<br /><br />