SHARE
TWEET

Untitled

a guest Mar 18th, 2019 47 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. item_id       Lookup_id      date     archive
  2. ------------------------------------------------
  3. 1234            4           1-1-19       0
  4. 1235            4           1-1-19       0
  5. 1236            4           1-1-19       0
  6. 1237            2           1-1-19       0
  7. 1238            1           1-1-19       0
  8. 1239            1           1-1-19       0
  9.      
  10. 'SELECT  `item_id` ,  `lookup_id`, `date`, `archive`
  11.  FROM  items
  12.  WHERE  `item_id`
  13.  IN (
  14.     `SELECT  `item_id`
  15.      FROM  items
  16.      GROUP BY  `item_id`
  17.      HAVING COUNT(  `item_id` ) >1
  18. )
  19. ORDER BY  `item_id`;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top