Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 48,49,44,50,55,43,51,25,24,52,47,31,53
- City / Route Dist. CULLENS; ID: 12 DUNHAM SPORTS; ID: 21
- CAMPBELL/DORAN
- BOX; ID: 48 70 x
- RT 1; ID: 49 160 x x
- CLITHERALL
- BOX; ID: 44 60 x x
- ELBOW LAKE
- RT 3; ID: 50 34 x
- FOXHOME
- RT 2; ID: 55 62 x x
- BOX; ID: 43 80 x x
- NASHUA
- RT 1; ID: 51 51 x
- ROTHSAY
- RT 2; ID: 25 205 x x
- RT 1; ID: 24 215 x x
- TINTAH/TENNY
- RT 1; ID: 52 55 x
- VINING
- BOX; ID: 47 40 x
- WENDELL
- CARRIER; ID: 31 90 x x
- RT 1; ID: 53 89 x x
- Total Distribution 1211 961 1211
- Array
- (
- [0] => Array
- (
- [0] => 21
- )
- [1] => Array
- (
- [0] => 12
- )
- [2] => Array
- (
- [0] => 12
- [1] => 21
- )
- )
- Query: SELECT route_id FROM insert_route WHERE insert_id IN (21 ) AND route_id IN (48,49,44,50,55,43,51,25,24,52,47,31,53) GROUP BY route_id HAVING count( DISTINCT insert_id ) = 1
- Combination 1
- Inserts: 21
- Routes:
- 24
- 25
- 31
- 43
- 44
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 55
- Query: SELECT route_id FROM insert_route WHERE insert_id IN (12 ) AND route_id IN (48,49,44,50,55,43,51,25,24,52,47,31,53) GROUP BY route_id HAVING count( DISTINCT insert_id ) = 1
- Combination 2
- Inserts: 12
- Routes:
- 24
- 25
- 31
- 43
- 44
- 49
- 53
- 55
- Query: SELECT route_id FROM insert_route WHERE insert_id IN (12 ,21 ) AND route_id IN (48,49,44,50,55,43,51,25,24,52,47,31,53) GROUP BY route_id HAVING count( DISTINCT insert_id ) = 2
- Combination 3
- Inserts: 12 21
- Routes:
- 24
- 25
- 31
- 43
- 44
- 49
- 53
- 55
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement