Skip to content

Instantly share code, notes, and snippets.

@workmaster2n

workmaster2n/conditions_in_join.sql

Last active December 27, 2015 14:28
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save workmaster2n/7340362 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save workmaster2n/7340362 to your computer and use it in GitHub Desktop.
Download ZIP
count 0
Raw
conditions_in_join.sql
SELECT tracked_point_zones.worker_id, tracked_point_zones.zone_id, COUNT(*) FROM tracked_point_zones
LEFT JOIN zones ON zones.id = tracked_point_zones.zone_id AND tracked_point_zones.recorded_at > '2013-11-01' AND tracked_point_zones.worker_id = 5
GROUP BY tracked_point_zones.worker_id, tracked_point_zones.zone_id
ORDER BY COUNT(*) DESC
Raw
get_zero.sql
SELECT tracked_point_zones.worker_id, tracked_point_zones.zone_id, COUNT(*) FROM tracked_point_zones
RIGHT JOIN zones ON zones.id = tracked_point_zones.zone_id
WHERE
tracked_point_zones.recorded_at > '2013-11-01' AND tracked_point_zones.worker_id = 5
GROUP BY tracked_point_zones.worker_id, tracked_point_zones.zone_id
ORDER BY tracked_point_zones.worker_id, COUNT(*) DESC
Raw
original.sql
SELECT tracked_point_zones.worker_id, tracked_point_zones.zone_id, COUNT(*) FROM tracked_point_zones
JOIN zones ON zones.id = tracked_point_zones.zone_id
WHERE
tracked_point_zones.recorded_at > '2013-11-01' AND tracked_point_zones.worker_id = 5
GROUP BY tracked_point_zones.worker_id, tracked_point_zones.zone_id
ORDER BY tracked_point_zones.worker_id, COUNT(*) DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment