使用子查询来获取每个重复记录的第一次出现的记录

使用子查询来获取每个obj_id第一次出现的记录时，你可以通过以下方式实现：

1. 首先，创建一个子查询来找到每个obj_id的最小id（假设id是自增的主键，因此最小的id代表最早的记录）。

2. 然后，在外部查询中使用这个子查询的结果来过滤出这些最小id对应的完整记录。

   SELECT t.id, t.obj_idFROM t_app_goods_discovery tWHERE t.obj_type = 1 AND t.is_deleted = 0 AND t.obj_id IN ( 'p_5de5ccbabb54f_vQVSmCGJ', 'p_5de8ad170bf78_aNzZbyVr', 'p_5dedafebbd713_LxplwUDl', 'p_5df1f34e7000d_lQB7ke0A', 'p_5df71bb02f132_kfuZ2Z2Z', 'p_5df82f59898bd_ej8L0N1H', 'p_5df82fc1bc8f1_QS6mhj4K', 'p_5df82ffe1388a_eeWXa8oH', 'p_5df86f945a2a7_aOJqWQAG', 'p_5df9a9392a1c0_nLIrrm1V', 'p_5e16ec228098d_3tBSmxYE', 'p_5e24fb2cd3d20_5GSfHbtQ', 'p_5e5655247a140_cQOTePRD', 'p_5e8d3843aa937_rHb9nhYy', 'p_5eb4f9276ee5a_amQ5vx75', 'p_5ee0e95176c04_2pg1A0cx', 'p_5ee99fa0a4bff_elYc85BS', 'p_5ef841094583a_SLgf8NNS', 'p_5ef97c98180fa_ZqnEfGTp', 'p_5f03dfb8e4b036f1c0cf0f30', 'p_5f169115e4b0aebca61a7798', 'p_5f190a33e4b0df48afbd05f5', 'p_5f1a974fe4b0df48afbd710e', 'p_5f2117ade4b025ff2cf712f2', 'p_5f2ca669e4b0a4eaa7b969fc', 'p_5f34e783e4b075dc42ad9252', 'p_5f478802e4b0477ccba767de', 'p_5f51fb83e4b0b5edf0a0335b', 'p_5f6c1309e4b0d59c87b7effc', 'p_5f8ea04ee4b06aff1a0544cb', 'p_5f9c07bee4b068b6f2800f2a', 'p_5fa8ed3be4b01f764d8999d2', 'p_5fae4adee4b0231ba88647e5', 'p_5fe039b1e4b04db7c0961b62', 'p_5feae2a7e4b04db7c097c9c0', 'p_5fffff86e4b00ff4ed11f529', 'p_60014f58e4b00ff4ed12b8f5', 'p_6007ea04e4b00ff4ed15f982', 'p_601bd138e4b05a9e88711c25', 'p_603e021ae4b0b6e9418f167c', 'p_60403fcee4b05a6195bc8fbb', 'p_607bea9ae4b0d4eb03928978', 'p_60a87b67e4b0f120ffbfeb91', 'p_60b0adb7e4b0c726421a0801', 'p_60b62d64e4b07e4d7fdaf269', 'p_60d1a52fe4b0c726422176d0', 'p_60dad8d8e4b08aeb71e0d8cc', 'p_60fec4e5e4b0bf642ffe7aac', 'p_610b55ede4b0cce271b9fada', 'p_611b6bb4e4b0cce271bf2d4a', 'p_614435cfe4b0b558b93172e2', 'p_619206cee4b09b5fe0b2e585', 'p_6194e772e4b0c005c99176b2', 'p_6194eab2e4b0bab3cb7c8f71', 'p_61d40b20e4b0469a4f6bce5e', 'p_61dfafece4b0eec248c54890', 'p_61e53750e4b0bd9e53d4a475', 'p_61e653a3e4b0bd9e53d4e5c0', 'p_61ed0f2fe4b0beaee42556b9', 'p_620f1ec3e4b054255d9f2b28', 'p_62450706e4b01a4851eb455f', 'p_62498ef7e4b09dda12562ac5', 'p_62524f12e4b01c509aa0c6d1', 'p_626696a8e4b01c509aa8326d', 'p_62761d00e4b0812e17962d1b', 'p_62765a5ce4b09dda12651225', 'p_627d1e38e4b0cedf38b113d2', 'p_629723b8e4b0cedf38b98ecf', 'p_62a0707ae4b0812e17a4430e', 'p_62c288fce4b0c9426475ea5e', 'p_62c53e10e4b0c9426476f313', 'p_62df416de4b0a51fef041beb', 'p_62fa3dafe4b0c94264880567', 'p_62fb78bce4b050af23a9fd55', 'p_6336a0cae4b050af23bf02e0', 'p_6349192be4b0eca59c3e0984', 'p_634f8606e4b0a51fef2af336', 'p_6386fb3de4b07b05581fffc8', 'p_63bbf111e4b06159f72ca959', 'p_63c7b739e4b0fc5d1227836f', 'p_63c8ecdbe4b02685a43963c5', 'p_63e9de5ae4b02685a4428eda', 'p_64018975e4b02685a44ca693', 'p_6409840ce4b02685a44fe540', 'p_6412844ce4b0b0bc2bc7ea47', 'p_641baf27e4b0f2aa7dd09b77', 'p_643cf746e4b0b0bc2bd82782', 'p_64474d8ae4b0b2d1c40d2e12', 'p_64487d87e4b09d7237901c4f', 'p_644a2128e4b0b0bc2bdd92c6', 'p_645c40b0e4b0b0bc2be35da7', 'p_64910970e4b04c10d0a9c569', 'p_64b8cac7e4b064a8373c1bb1', 'p_64b8dc28e4b09d7237a2ca5d', 'p_64c0ec4ce4b007b201aa851c', 'p_64d9dea4e4b09d7237a730df', 'p_64ffcedde4b0694ce9e8cc18', 'p_6523cd2ce4b064a863bb72a5', 'p_652bd3f8e4b064a82f0f8d82', 'p_654259e3e4b04c1014c04db2', 'p_654b3447e4b04c1093f96820', 'p_6559cd1be4b023c044fd99c7', 'p_65659ed5e4b04c1038669e3a', 'p_65851eeae4b064a8ccb27283', 'p_65bc7664e4b064a8cb208930', 'p_65d4426ce4b04c10a130c2a3', 'p_65fa4f34e4b0694cc04f7a7e', 'p_65facfb7e4b0694cc04fb54d', 'p_66023675e4b092c1684d91b7', 'p_66140a1de4b092c155b07d9b', 'v_65574ffce4b04c1093fc78df' ) AND t.id = ( SELECT MIN(sub.id) FROM t_app_goods_discovery sub WHERE sub.obj_id = t.obj_id AND sub.obj_type = 1 AND sub.is_deleted = 0 );