SQL
1SELECT2 th.ticket_id id,3 th.order_id,4 th.event_id 5FROM6 ticket_histories th 7WHERE8 th.ticket_id in (1603707, 1603708, 1603709, 1603710, 1603711, 1603712, 1603713, 1603714, 1603715, 1603716, 1603717, 1603726, 1603727, 1603728, 1603729, 1603730, 1603731, 1603732, 1603733, 1603734, 1603735, 1603736, 1603778, 1603779, 1603780, 1603781, 1603782, 1603783, 1603784, 1603785, 1603786, 1603787, 1603788, 1603830, 1603831, 1603832, 1603833, 1603834, 1603835, 1603836, 1603837, 1603838, 1603839, 1603840, 1604022, 1604023, 1604024, 1604025, 1604026, 1604027, 1604028, 1604029, 1604030, 1604031, 1604032, 1604033, 1604034, 1604035, 1604036, 1604037, 1604038, 1604039, 1604040, 1604041, 1604042, 1604043, 1604044, 1604045, 1604046, 1604047, 1604048, 1604049, 1604050, 1604051, 1604052, 1604053, 1604054, 1604177, 1604178, 1604179, 1604180, 1604181, 1604182, 1604183, 1604184, 1604185, 1604186, 1604187, 1604188, 1604189, 1604190, 1604191, 1604192, 1604193, 1604194, 1604195, 1604196, 1604197, 1604198, 1604199, 1604200, 1604201, 1604202, 1604203, 1604204, 1604205, 1604206, 1604207, 1604208, 1604209, 1222481, 1222485, 1604331, 1604332, 1604333, 1604334, 1604335, 1604336, 1604337, 1604338, 1604339, 1604340, 1604341, 1604353, 1604354, 1604355, 1604356, 1604357, 1604358, 1604359, 1604360, 1604361, 1604362, 1604363, 1222489, 1604412, 1604413, 1604414, 1604415, 1604416, 1604417, 1604418, 1604419, 1604420, 1604421, 1604422, 1222493, 1222499, 1222505, 1222506, 1222507, 1222508, 1222509, 1222510, 1222511, 1222512, 1222513, 1222514, 1222515, 1222567, 1222568, 1222569, 1222570, 1222571, 1222572, 1222573, 1222574, 1222575, 1222576, 1222577, 1604530, 1604531, 1604532, 1604533, 1604534, 1604535, 1604536, 1604537, 1604538, 1604539, 1604540, 1222634, 1222638, 1222642, 1222646, 1222650, 1222656, 1222660, 1222664, 1222670, 1222672, 1604634, 1604635, 1604636, 1604637, 1604638, 1604639, 1604640, 1604641, 1604642, 1604643, 1604644, 1222707, 1604699, 1222712, 1604700, 1604701, 1604702, 1604703, 1604704, 1604705, 1604706, 1604707, 1604708, 1604709, 1222717, 1222735, 1222746, 1222747, 1222748, 1222749, 1222750, 1222751, 1222752, 1222753, 1222754, 1222755, 1222756, 1222762, 1222769, 1222770, 1222771, 1222772, 1222773, 1222774, 1222775, 1222776, 1222777, 1222778, 1222779, 1222781, 1222803, 1222804, 1222805, 1222806, 1222807, 1222808, 1222809, 1222815, 1222843, 1222844, 1222845, 1222846, 1222847, 1222848, 1222849, 1222850, 1222851, 1222852, 1222853, 1222900, 1222901, 1222902, 1222903, 1222904, 1222905, 1222906, 1222907, 1222908, 1222909, 1222910, 1222966, 1222967, 1222968, 1222969, 1222970, 1222971, 1222972, 1222973, 1222974, 1222975, 1222976, 1222983, 1222984, 1222985, 1222986, 1222987, 1222988, 1223079, 1223080, 1223081, 1223082, 1223083, 1223084, 1223085, 1223086, 1223087, 1223088, 1223089, 1223135, 1223136, 1223137, 1223138, 1223139, 1223140, 1223141, 1223142, 1223143, 1223144, 1223145, 1604782, 1604783, 1604784, 1604785, 1604786, 1604787, 1604788, 1604789, 1604790, 1604791, 1604792, 1604822, 1604823, 1604824, 1604825, 1604826, 1604827, 1604828, 1604829, 1604830, 1604831, 1604853, 1604854, 1604855, 1604856, 1604857, 1604858, 1604859, 1604860, 1604861, 1604862, 1604863, 1604864, 1604865, 1604866, 1604867, 1604868, 1604869, 1604870, 1604871, 1604872, 1604873, 1604874)9 AND th.order_id = 832810 AND th.order_type = 'Commission'11 AND th.created_at = '2023-01-23T17:44:29.000+09:00'
0 コメント