Draft specimens

[ConstantinoSchillebeeckx]

Some specimens (completed by Tony) have been labeled as draft because they've already been finished by a volunteer. Until I get the annotated images, the draft specimens will not show up in the labeling app.

I have a thumb drive here with images from Tony that are completed, for the most part. DSC01333 - DSC01371 DSC01421 - DSC01582 DSC01647 - DSC01975

ID (posts) associated with images:

UPDATE `vznp_posts` 
SET post_status = 'draft'
where ID in (33965,33963,33961,33959,33957,33967,33969,33971,33973,33975,33977,33979,33981,33983,33985,33987,33989,33991,33993,33995,33997,33999,34001,34003,34005,34007,34009,34011,34013,34015,34017,34019,34021,34023,34025,34027,34029,34031,34033,33955,33953,33951,33949,33947,33945,33943,33941,33939,33937,33935,33933,33931,33929,33927,33925,33923,33921,33919,33917,33915,33913,33911,33909,33907,33905,33903,33901,33899,33897,33895,33893,33891,33889,33887,33885,33883,33881,33879,33877,33875,33873,33871,33847,33845,33843,33841,33839,33837,33835,33833,33831,33829,33827,33825,33823,33821,33819,33817,33815) and post_type = 'specimen'

I have relabeled the files in the 2015_11_08 Herbario ICSEI Universidad folder. The files in the folder range from IMG_0181 thru IMG_0216.

ID (posts) associated with images:

UPDATE `vznp_posts` 
SET post_status = 'draft'
where ID in (38836,38838,38842,38844,38846,38850,38852,38856,38804,38806,38808,38810,38812,38866,38868,38872,38874,38876,38880,38882,38862,38860,38814,38816,38818,38822,38826,38828,38830,38832) and post_type = 'specimen'

[ConstantinoSchillebeeckx]

Completed by Josh:

UPDATE `vznp_posts` 
SET post_status = 'draft'
where ID in (33627,33625,33623,33621,33619,33617,33615,33613,33611,33609,33607,33605,33603,33601,33599,33597,33595,33593,33591,33589,33561,33563,33565,33567,33569,33571,33573,33575,33577,33579,33581,33583,33585,33587) 
and post_type = 'specimen'

[ConstantinoSchillebeeckx]

Allan - DSC09139 to DSC09152 (I still need to set these as draft)

[ConstantinoSchillebeeckx]

2015_11_03Herbario SINCHI, Bogota-338

SELECT * FROM `vznp_posts` where 
post_type = 'specimen'
and post_status = 'publish'
AND ID in 
(SELECT post_id FROM `vznp_postmeta` where meta_value REGEXP "^(DSC01647|DSC01664|DSC01681|DSC01698|DSC01715|DSC01734|DSC01751|DSC01768|DSC01785|DSC01802|DSC01822|DSC01843|DSC01860|DSC01877|DSC01894|DSC01911|DSC01928|DSC01945|DSC01962|DSC01648|DSC01665|DSC01682|DSC01699|DSC01716|DSC01735|DSC01752|DSC01769|DSC01786|DSC01803|DSC01823|DSC01844|DSC01861|DSC01878|DSC01895|DSC01912|DSC01929|DSC01946|DSC01963|DSC01649|DSC01666|DSC01683|DSC01700|DSC01717|DSC01736|DSC01753|DSC01770|DSC01787|DSC01804|DSC01824|DSC01845|DSC01862|DSC01879|DSC01896|DSC01913|DSC01930|DSC01947|DSC01964|DSC01650|DSC01667|DSC01684|DSC01701|DSC01720|DSC01737|DSC01754|DSC01771|DSC01788|DSC01805|DSC01825|DSC01846|DSC01863|DSC01880|DSC01897|DSC01914|DSC01931|DSC01948|DSC01965|DSC01651|DSC01668|DSC01685|DSC01702|DSC01721|DSC01738|DSC01755|DSC01772|DSC01789|DSC01806|DSC01826|DSC01847|DSC01864|DSC01881|DSC01898|DSC01915|DSC01932|DSC01949|DSC01966|DSC01652|DSC01669|DSC01686|DSC01703|DSC01722|DSC01739|DSC01756|DSC01773|DSC01790|DSC01807|DSC01827|DSC01848|DSC01865|DSC01882|DSC01899|DSC01916|DSC01933|DSC01950|DSC01967|DSC01653|DSC01670|DSC01687|DSC01704|DSC01723|DSC01740|DSC01757|DSC01774|DSC01791|DSC01808|DSC01828|DSC01849|DSC01866|DSC01883|DSC01900|DSC01917|DSC01934|DSC01951|DSC01968|DSC01654|DSC01671|DSC01688|DSC01705|DSC01724|DSC01741|DSC01758|DSC01775|DSC01792|DSC01809|DSC01829|DSC01850|DSC01867|DSC01884|DSC01901|DSC01918|DSC01935|DSC01952|DSC01969|DSC01655|DSC01672|DSC01689|DSC01706|DSC01725|DSC01742|DSC01759|DSC01776|DSC01793|DSC01813|DSC01834|DSC01851|DSC01868|DSC01885|DSC01902|DSC01919|DSC01936|DSC01953|DSC01970|DSC01656|DSC01673|DSC01690|DSC01707|DSC01726|DSC01743|DSC01760|DSC01777|DSC01794|DSC01814|DSC01835|DSC01852|DSC01869|DSC01886|DSC01903|DSC01920|DSC01937|DSC01954|DSC01971|DSC01657|DSC01674|DSC01691|DSC01708|DSC01727|DSC01744|DSC01761|DSC01778|DSC01795|DSC01815|DSC01836|DSC01853|DSC01870|DSC01887|DSC01904|DSC01921|DSC01938|DSC01955|DSC01972|DSC01658|DSC01675|DSC01692|DSC01709|DSC01728|DSC01745|DSC01762|DSC01779|DSC01796|DSC01816|DSC01837|DSC01854|DSC01871|DSC01888|DSC01905|DSC01922|DSC01939|DSC01956|DSC01973|DSC01659|DSC01676|DSC01693|DSC01710|DSC01729|DSC01746|DSC01763|DSC01780|DSC01797|DSC01817|DSC01838|DSC01855|DSC01872|DSC01889|DSC01906|DSC01923|DSC01940|DSC01957|DSC01974|DSC01660|DSC01677|DSC01694|DSC01711|DSC01730|DSC01747|DSC01764|DSC01781|DSC01798|DSC01818|DSC01839|DSC01856|DSC01873|DSC01890|DSC01907|DSC01924|DSC01941|DSC01958|DSC01975|DSC01661|DSC01678|DSC01695|DSC01712|DSC01731|DSC01748|DSC01765|DSC01782|DSC01799|DSC01819|DSC01840|DSC01857|DSC01874|DSC01891|DSC01908|DSC01925|DSC01942|DSC01959|DSC01662|DSC01679|DSC01696|DSC01713|DSC01732|DSC01749|DSC01766|DSC01783|DSC01800|DSC01820|DSC01841|DSC01858|DSC01875|DSC01892|DSC01909|DSC01926|DSC01943|DSC01960|DSC01663|DSC01680|DSC01697|DSC01714|DSC01733|DSC01750|DSC01767|DSC01784|DSC01801|DSC01821|DSC01842|DSC01859|DSC01876|DSC01893|DSC01910|DSC01927|DSC01944|DSC01961)"
and meta_key = 'imgs')

[ConstantinoSchillebeeckx]

2015_10_30-31_Herbario JBGP_Jardin Botanico Cartagena161

SELECT * FROM `vznp_posts` where 
post_type = 'specimen'
and post_status = 'publish'
AND ID in 
(SELECT post_id FROM `vznp_postmeta` where meta_value REGEXP "^(DSC01421|DSC01429|DSC01437|DSC01445|DSC01455|DSC01463|DSC01471|DSC01495|DSC01504|DSC01512|DSC01520|DSC01529|DSC01537|DSC01545|DSC01553|DSC01561|DSC01569|DSC01577|DSC01422|DSC01430|DSC01438|DSC01446|DSC01456|DSC01464|DSC01472|DSC01496|DSC01505|DSC01513|DSC01521|DSC01530|DSC01538|DSC01546|DSC01554|DSC01562|DSC01570|DSC01578|DSC01423|DSC01431|DSC01439|DSC01447|DSC01457|DSC01465|DSC01473|DSC01497|DSC01506|DSC01514|DSC01522|DSC01531|DSC01539|DSC01547|DSC01555|DSC01563|DSC01571|DSC01579|DSC01424|DSC01432|DSC01440|DSC01449|DSC01458|DSC01466|DSC01474|DSC01498|DSC01507|DSC01515|DSC01524|DSC01532|DSC01540|DSC01548|DSC01556|DSC01564|DSC01572|DSC01580|DSC01425|DSC01433|DSC01441|DSC01450|DSC01459|DSC01467|DSC01491|DSC01499|DSC01508|DSC01516|DSC01525|DSC01533|DSC01541|DSC01549|DSC01557|DSC01565|DSC01573|DSC01581|DSC01426|DSC01434|DSC01442|DSC01451|DSC01460|DSC01468|DSC01492|DSC01500|DSC01509|DSC01517|DSC01526|DSC01534|DSC01542|DSC01550|DSC01558|DSC01566|DSC01574|DSC01582|DSC01427|DSC01435|DSC01443|DSC01452|DSC01461|DSC01469|DSC01493|DSC01501|DSC01510|DSC01518|DSC01527|DSC01535|DSC01543|DSC01551|DSC01559|DSC01567|DSC01575|DSC01428|DSC01436|DSC01444|DSC01453|DSC01462|DSC01470|DSC01494|DSC01502|DSC01511|DSC01519|DSC01528|DSC01536|DSC01544|DSC01552|DSC01560|DSC01568|DSC0157)"
and meta_key = 'imgs')

[ConstantinoSchillebeeckx]

2015_10_29_Herbario DUGAND, Baranquilla75

SELECT * FROM `vznp_posts` where 
post_type = 'specimen'
and post_status = 'publish'
AND ID in 
(SELECT post_id FROM `vznp_postmeta` where meta_value REGEXP "^(DSC01333|DSC01337|DSC01341|DSC01344|DSC01347|DSC01350|DSC01353|DSC01357|DSC01360|DSC01364|DSC01367|DSC01370|DSC01374|DSC01377|DSC01392|DSC01395|DSC01398|DSC01334|DSC01338|DSC01342|DSC01345|DSC01348|DSC01351|DSC01354|DSC01358|DSC01362|DSC01365|DSC01368|DSC01371|DSC01375|DSC01383|DSC01393|DSC01396|DSC01336|DSC01339|DSC01343|DSC01346|DSC01349|DSC01352|DSC01355|DSC01359|DSC01363|DSC01366|DSC01369|DSC01373|DSC01376|DSC01391|DSC01394|DSC01397)"
and meta_key = 'imgs')

[ConstantinoSchillebeeckx]

2015_10_22_UTPC Herbarium in Tunja_153-

SELECT * FROM `vznp_posts` where 
post_type = 'specimen'
and post_status = 'publish'
AND ID in 
(SELECT post_id FROM `vznp_postmeta` where meta_value REGEXP "^(DSC00170|DSC00178|DSC00186|DSC00194|DSC00202|DSC00211|DSC00219|DSC00236|DSC00244|DSC00252|DSC00260|DSC00268|DSC00276|DSC00284|DSC00292|DSC00301|DSC00309|DSC00317|DSC00171|DSC00179|DSC00187|DSC00195|DSC00203|DSC00212|DSC00220|DSC00237|DSC00245|DSC00253|DSC00261|DSC00269|DSC00277|DSC00285|DSC00293|DSC00302|DSC00310|DSC00318|DSC00172|DSC00180|DSC00188|DSC00196|DSC00204|DSC00213|DSC00230|DSC00238|DSC00246|DSC00254|DSC00262|DSC00270|DSC00278|DSC00286|DSC00295|DSC00303|DSC00311|DSC00319|DSC00173|DSC00181|DSC00189|DSC00197|DSC00205|DSC00214|DSC00231|DSC00239|DSC00247|DSC00255|DSC00263|DSC00271|DSC00279|DSC00287|DSC00296|DSC00304|DSC00312|DSC00320|DSC00174|DSC00182|DSC00190|DSC00198|DSC00206|DSC00215|DSC00232|DSC00240|DSC00248|DSC00256|DSC00264|DSC00272|DSC00280|DSC00288|DSC00297|DSC00305|DSC00313|DSC00321|DSC00175|DSC00183|DSC00191|DSC00199|DSC00207|DSC00216|DSC00233|DSC00241|DSC00249|DSC00257|DSC00265|DSC00273|DSC00281|DSC00289|DSC00298|DSC00306|DSC00314|DSC00322|DSC00176|DSC00184|DSC00192|DSC00200|DSC00208|DSC00217|DSC00234|DSC00242|DSC00250|DSC00258|DSC00266|DSC00274|DSC00282|DSC00290|DSC00299|DSC00307|DSC00315|DSC00323|DSC00177|DSC00185|DSC00193|DSC00201|DSC00210|DSC00218|DSC00235|DSC00243|DSC00251|DSC00259|DSC00267|DSC00275|DSC00283|DSC00291|DSC00300|DSC00308|DSC00316)"
and meta_key = 'imgs')

[ConstantinoSchillebeeckx]

2015_10_21_Universidad Los Andes- Day 3169

SELECT * FROM `vznp_posts` where 
post_type = 'specimen'
and post_status = 'publish'
AND ID in 
(SELECT post_id FROM `vznp_postmeta` where meta_value REGEXP "^(DSC00001|DSC00010|DSC00019|DSC00028|DSC00037|DSC00046|DSC00055|DSC00064|DSC00073|DSC00082|DSC00092|DSC00101|DSC00110|DSC00119|DSC00128|DSC00137|DSC00146|DSC00155|DSC00164|DSC00002|DSC00011|DSC00020|DSC00029|DSC00038|DSC00047|DSC00056|DSC00065|DSC00074|DSC00083|DSC00093|DSC00102|DSC00111|DSC00120|DSC00129|DSC00138|DSC00147|DSC00156|DSC00165|DSC00003|DSC00012|DSC00021|DSC00030|DSC00039|DSC00048|DSC00057|DSC00066|DSC00075|DSC00084|DSC00094|DSC00103|DSC00112|DSC00121|DSC00130|DSC00139|DSC00148|DSC00157|DSC00166|DSC00004|DSC00013|DSC00022|DSC00031|DSC00040|DSC00049|DSC00058|DSC00067|DSC00076|DSC00085|DSC00095|DSC00104|DSC00113|DSC00122|DSC00131|DSC00140|DSC00149|DSC00158|DSC00167|DSC00005|DSC00014|DSC00023|DSC00032|DSC00041|DSC00050|DSC00059|DSC00068|DSC00077|DSC00086|DSC00096|DSC00105|DSC00114|DSC00123|DSC00132|DSC00141|DSC00150|DSC00159|DSC00168|DSC00006|DSC00015|DSC00024|DSC00033|DSC00042|DSC00051|DSC00060|DSC00069|DSC00078|DSC00088|DSC00097|DSC00106|DSC00115|DSC00124|DSC00133|DSC00142|DSC00151|DSC00160|DSC00169|DSC00007|DSC00016|DSC00025|DSC00034|DSC00043|DSC00052|DSC00061|DSC00070|DSC00079|DSC00089|DSC00098|DSC00107|DSC00116|DSC00125|DSC00134|DSC00143|DSC00152|DSC00161|DSC00008|DSC00017|DSC00026|DSC00035|DSC00044|DSC00053|DSC00062|DSC00071|DSC00080|DSC00090|DSC00099|DSC00108|DSC00117|DSC00126|DSC00135|DSC00144|DSC00153|DSC00162|DSC00009|DSC00018|DSC00027|DSC00036|DSC00045|DSC00054|DSC00063|DSC00072|DSC00081|DSC00091|DSC00100|DSC00109|DSC00118|DSC00127|DSC00136|DSC00145|DSC00154|DSC00163)"
and meta_key = 'imgs')