Books SQL Query

Books SQL

SELECT order_id, order_item_name FROM kt_woocommerce_order_items WHERE order_item_name IN (
'The Best of The Digital Photography Book Series', #1605950
'How Do I Do That In Lightroom?', #1564501
'The Headshot: The Secrets to Creating Amazing Headshot Portraits', #1542682
'(Spiral Bound) The Adobe Photoshop Lightroom CC Book for Digital Photographers', #1475578
'The Adobe Photoshop Lightroom CC Book for Digital Photographers (Paperback)', #1446548
'It’s Not About The f-Stop', #1383012
'The Photoshop Elements 13 Book for Digital Photographers', #1286356
'The Adobe Photoshop CC Book for Digital Photographers', #1090080
'Light, Gesture & Color', #1090070
'The Digital Photography Book Part 5: Photo Recipes', #140179
'The HDR Book, 2nd Edition', #138553
'Down & Dirty Tricks for Designers Book Vol. 2', #137131
'Photoshop Elements 12 Book for Digital Photographers', #131485
'Photoshop for Lightroom Users Book', #131482
'Mastering the Model Shoot: Everything a Photographer Needs to Know Before, During and After the Shoot Book', #131479
'The Digital Photography Book Part 2, 2nd Edition', #131476
'Adobe Lightroom 5 for Digital Photographers Book', #23803
'The Digital Photography Book, Part 1, Second Edition', #22695
'The iPhone Book 5: Sixth Edition', #20059
'The iPod Book, 6th Edition', #1635
'The Digital Photography Book Part Four', #15148
'The Digital Photography Book, Volume 3', #430
'Light It. Shoot It. Retouch It.', #12440
'The Best of The Digital Photography Book Series – K1 Members', #1605959
'How Do I Do That In Lightroom? – K1 Members', #1564510
'The Headshot: The Secrets to Creating Amazing Headshot Portraits – K1 Members' #1543647
) AND order_id >= 1597109 AND order_id <= 1629037 order by order_item_name desc limit 100000000000;

product_ids

1605950
1564501
1542682
1475578
1446548
1383012
1286356
1090080
1090070
140179
138553
137131
131485
131482
131479
131476
23803
22695
20059
1635
15148
430
12440
1605959
1564510
1543647