Skip to content

Instantly share code, notes, and snippets.

@kokosing
Created March 29, 2016 09:20
Show Gist options
  • Select an option

  • Save kokosing/4833fdb0d68634d37140 to your computer and use it in GitHub Desktop.

Select an option

Save kokosing/4833fdb0d68634d37140 to your computer and use it in GitHub Desktop.
*** q58.sql 2016-03-29 10:31:47.000000000 +0200
--- q58_modified.sql 2016-03-29 11:02:31.000000000 +0200
***************
*** 63,69 ****
AND ss_item_rev BETWEEN 0.9 * ws_item_rev AND 1.1 * ws_item_rev
AND cs_item_rev BETWEEN 0.9 * ss_item_rev AND 1.1 * ss_item_rev
AND cs_item_rev BETWEEN 0.9 * ws_item_rev AND 1.1 * ws_item_rev
AND ws_item_rev BETWEEN 0.9 * ss_item_rev AND 1.1 * ss_item_rev
AND ws_item_rev BETWEEN 0.9 * cs_item_rev AND 1.1 * cs_item_rev
! ORDER BY item_id,
ss_item_rev LIMIT 100;
--- 63,69 ----
AND ss_item_rev BETWEEN 0.9 * ws_item_rev AND 1.1 * ws_item_rev
AND cs_item_rev BETWEEN 0.9 * ss_item_rev AND 1.1 * ss_item_rev
AND cs_item_rev BETWEEN 0.9 * ws_item_rev AND 1.1 * ws_item_rev
AND ws_item_rev BETWEEN 0.9 * ss_item_rev AND 1.1 * ss_item_rev
AND ws_item_rev BETWEEN 0.9 * cs_item_rev AND 1.1 * cs_item_rev
! ORDER BY ss_items.item_id,
ss_item_rev LIMIT 100;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment