ConstantinoSchillebeeckx / sp-nov

species nova
0 stars 0 forks source link

specimens with only 1 image #42

Open ConstantinoSchillebeeckx opened 7 years ago

ConstantinoSchillebeeckx commented 7 years ago
SELECT ID, post_parent, count(*) count FROM `vznp_posts` where post_type = 'attachment'
group by post_parent having count = 1

post_id: 33377,33629,33645,33657,33671,33673,33697,33725,33733,33755,33783,33791,33855,34213,34219,34466,34718,34856,34858,35080,35150,35152,35404,35420,35424,35504,35662,35698,35986,35988,36004,36076,36078,36094,36110,36112,36124,36126,36130,36136,36142,36146,36200,36216,36218,36232,36236,36240,36246,36248,36654,36666,36690,36758,36812,36820,36868,37050,37114,37522,37532,37534,37538,37542,37554,37678,37684,37686,37692,37710,37712,37750,37758,37760,37766,37772,37828,37834,37840,37844,37848,37854,37858,37872,37882,37896,37954,37982,37996,38008,38062,38094,38096,38098,38100,38104,38106,38130,38134,38140,38196,38244,38250,38258,38284,38308,38310,38312,38314,38322,38330,38344,38372,38388,38398,38412,38428,38432,38446,38450,38472,38698,38700,38702,38704,38706,38708,38710,38712,38716,38718,38720,38722,38724,38726,38728,38730,38732,38734,38736,38738,38740,38742,38744,38746,38748,38750,38752,38754,38756,38758,38760,38762,38764,38766,38768,38770,38772,38774,38776,38778,38780,38784,38786,38788,38790,38792,38794,38796,38798,38800,38802,38820,38824,38834,38840,38848,38854,38858,38864,38870,38878,38884,38886,38888,38890,38892,38894,38896,38898,38900,38902,38997,39829,39915,39927,39937,39939,39965,39967,40007,40073,40137,40139,40141,40201,40203,40213,40215,40233,40235,40253,40341

ConstantinoSchillebeeckx commented 7 years ago

Careful, not all of these specimens are an issue, for example the specimen with the IMG_XXX.jpg files

ConstantinoSchillebeeckx commented 7 years ago

fix those that was caused by my not knowing how the server renamed images after upload