item_id       Lookup_id      date     archive
------------------------------------------------
1234            4           1-1-19       0
1235            4           1-1-19       0
1236            4           1-1-19       0
1237            2           1-1-19       0
1238            1           1-1-19       0
1239            1           1-1-19       0

'SELECT  `item_id` ,  `lookup_id`, `date`, `archive`
 FROM  items
 WHERE  `item_id`
 IN (
    `SELECT  `item_id`
     FROM  items
     GROUP BY  `item_id`
     HAVING COUNT(  `item_id` ) >1
)
ORDER BY  `item_id`;