Advertisement
johncarlson21

Untitled

Oct 9th, 2013
189
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.56 KB | None | 0 0
  1. 48,49,44,50,55,43,51,25,24,52,47,31,53
  2. City / Route Dist. CULLENS; ID: 12 DUNHAM SPORTS; ID: 21
  3. CAMPBELL/DORAN
  4. BOX; ID: 48 70 x
  5. RT 1; ID: 49 160 x x
  6. CLITHERALL
  7. BOX; ID: 44 60 x x
  8. ELBOW LAKE
  9. RT 3; ID: 50 34 x
  10. FOXHOME
  11. RT 2; ID: 55 62 x x
  12. BOX; ID: 43 80 x x
  13. NASHUA
  14. RT 1; ID: 51 51 x
  15. ROTHSAY
  16. RT 2; ID: 25 205 x x
  17. RT 1; ID: 24 215 x x
  18. TINTAH/TENNY
  19. RT 1; ID: 52 55 x
  20. VINING
  21. BOX; ID: 47 40 x
  22. WENDELL
  23. CARRIER; ID: 31 90 x x
  24. RT 1; ID: 53 89 x x
  25. Total Distribution 1211 961 1211
  26.  
  27. Array
  28. (
  29. [0] => Array
  30. (
  31. [0] => 21
  32. )
  33.  
  34. [1] => Array
  35. (
  36. [0] => 12
  37. )
  38.  
  39. [2] => Array
  40. (
  41. [0] => 12
  42. [1] => 21
  43. )
  44.  
  45. )
  46.  
  47. 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
  48.  
  49. Combination 1
  50.  
  51. Inserts: 21
  52.  
  53. Routes:
  54. 24
  55. 25
  56. 31
  57. 43
  58. 44
  59. 47
  60. 48
  61. 49
  62. 50
  63. 51
  64. 52
  65. 53
  66. 55
  67.  
  68. 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
  69.  
  70. Combination 2
  71.  
  72. Inserts: 12
  73.  
  74. Routes:
  75. 24
  76. 25
  77. 31
  78. 43
  79. 44
  80. 49
  81. 53
  82. 55
  83.  
  84. 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
  85.  
  86. Combination 3
  87.  
  88. Inserts: 12 21
  89.  
  90. Routes:
  91. 24
  92. 25
  93. 31
  94. 43
  95. 44
  96. 49
  97. 53
  98. 55
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement