Advertisement
Guest User

Untitled

a guest
Dec 18th, 2014
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.10 KB | None | 0 0
  1. # track_inventory = 0
  2.  
  3. (1.7ms) SELECT `spree_variants`.`product_id` FROM `spree_stock_items` LEFT OUTER JOIN `spree_variants` ON `spree_variants`.`id` = `spree_stock_items`.`variant_id` AND `spree_variants`.`deleted_at` IS NULL WHERE `spree_stock_items`.`deleted_at` IS NULL AND `spree_stock_items`.`stock_location_id` = 1 AND `spree_variants`.`track_inventory` = 0
  4. => [1028197865]
  5.  
  6.  
  7. # track_inventory = 1
  8.  
  9. (2.2ms) SELECT `spree_variants`.`product_id` FROM `spree_stock_items` LEFT OUTER JOIN `spree_variants` ON `spree_variants`.`id` = `spree_stock_items`.`variant_id` AND `spree_variants`.`deleted_at` IS NULL WHERE `spree_stock_items`.`deleted_at` IS NULL AND `spree_stock_items`.`stock_location_id` = 1 AND `spree_variants`.`track_inventory` = 1
  10. => [633131037, 457404764, 969162690, 338290009, 871397402, 98683658, 300709750, 158095921, 1028197832, 1028197835, 1028197836, 1028197837, 1028197838, 1028197834, 1028197847, 1028197849, 1028197850, 1028197851, 1028197852, 1028197853, 1028197854, 1028197855, 1028197857, 1028197859, 1028197862, 1028197865, 1028197866, 1028197867, 1028197868, 1028197869, 1028197870, 1028197871, 1028197872, 1028197873, 1028197874, 1028197875, 1028197876, 1028197877, 1028197878, 1028197879, 1028197880, 1028197881, 1028197882, 1028197884, 1028197885, 1028197887, 1028197888, 1028197889, 1028197890, 1028197893, 1028197894, 1028197895, 1028197896, 1028197897, 1028197898, 1028197899, 1028197900, 1028197901, 1028197902, 1028197903, 1028197904, 1028197905, 1028197906, 1028197908, 1028197909, 1028197910, 1028197911, 1028197912, 1028197913, 1028197914, 1028197916, 1028197917, 1028197918, 1028197919, 1028197920, 1028197921, 1028197922, 1028197923, 1028197924, 1028197925, 1028197926, 1028197927, 1028197928, 1028197929, 1028197930, 1028197931, 1028197932, 1028197933, 1028197934, 1028197935, 1028197936, 1028197937, 1028197938, 1028197939, 1028197940, 1028197941, 1028197942, 1028197943, 1028197944, 1028197945, 1028197946, 1028197947, 1028197948, 1028197949, 1028197950, 1028197951, 1028197952, 1028197953, 1028197954, 1028197955, 1028197956]
  11.  
  12.  
  13. # WHY IS 1028197865 included in both data sets????
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement