Actions
bug #6024
closedFix blocking name relationships for replacement names
Start date:
Due date:
% Done:
100%
Estimated time:
3:00 h
Severity:
normal
Found in Version:
Description
Find replacement names that do not have a blocking name relationship
SELECT tnb.id, tnb.uuid, tnb.titleCache
FROM TaxonNameBase tnb
WHERE tnb.id
IN
(SELECT relatedTo_id FROM NameRelationship nr WHERE nr.type_id = 906)
AND tnb.id NOT IN (
SELECT tnb.id
FROM TaxonNameBase tnb INNER JOIN NameRelationship bnrel ON bnrel.relatedTo_id = tnb.id AND bnrel.type_id = 902
WHERE tnb.id
IN
(SELECT relatedTo_id FROM NameRelationship nr WHERE nr.type_id = 906)
)
ORDER BY tnb.titleCache
"7746" "f20f12b2-2db4-431f-a06d-409445869edc" "Diospyros discolor Willd."
"19984" "adf2d458-e834-4c5a-a3ac-60e0da7d48a5" "Eulophia ecristata (Fernald) Ames"
"19864" "0953bd65-df4c-4ccd-adb0-493ae2b17a92" "Liparis jamaicensis Lindl. ex Griseb."
"1840" "01737338-f947-447b-b724-f19d9841ce7a" "Mariscus swartzii A. Dietr."
"8390" "c18ba0cc-e81d-4a3f-91b8-feb1e5b17ea2" "Nectandra anonyma Steud."
"8386" "7b6da163-1bd3-43da-95f2-51c08e22e706" "Nectandra neesii D. Dietr."
"19986" "ca79e7a3-6f16-4980-872a-571263420dc2" "Pteroglossaspis ecristata (Fernald) Rolfe"
Non species issues
AND (tnb.rank_id <> 790 OR bn.rank_id <> 790)
"6556" "3b62c9ab-ad76-4618-91ad-961b6e71d3a3" "Buxus wrightii Müll. Arg. subsp. wrightii" "Buxus microphylla Siebold & Zucc." "788"
"1913" "77464776-5824-46fc-a540-01c5d6603935" "Cyperus tenuis var. capillaris (Sw.) Kük." "Cyperus capillaris J. Koenig ex Roxb." "785"
Updated by Andreas Müller over 7 years ago
- Description updated (diff)
SELECT tnb.id rnid, tnb.uuid, tnb.titleCache as replacementName, bn.titleCache as blockingName, rs.titleCache replacedSynonym, rs.id rsid, bnrel.id bnrelid, bn.id
FROM TaxonNameBase tnb INNER JOIN NameRelationship bnrel ON bnrel.relatedTo_id = tnb.id AND bnrel.type_id = 902
INNER JOIN TaxonNameBase bn ON bnrel.relatedFrom_id = bn.id
INNER JOIN NameRelationship rsrel ON rsrel.relatedTo_id = tnb.id AND rsrel.type_id = 906
INNER JOIN TaxonNameBase rs ON rsrel.relatedFrom_id = rs.id
WHERE tnb.id
IN
(SELECT relatedTo_id FROM NameRelationship nr WHERE nr.type_id = 906)
-- AND bn.specificEpithet <> rs.specificEpithet
ORDER BY tnb.titleCache
"rnid" "uuid" "replacementName" "blockingName" "replacedSynonym" "rsid" "bnrelid" "id"
"15180" "1462c0ba-48e3-4b6d-af24-b3fd137ba9fe" "Anneslia grisebachii Britton & Rose" "Anneslia gracilis (M. Martens & Galeotti) Britton & Rose" "Calliandra gracilis Griseb." "15178" "4566" "15182"
"9623" "572ab786-0623-4aed-a2ce-a20f907f3505" "Ardisia pickeringia Torrey & A. Gray ex A. DC." "Ardisia paniculata Roxb." "Cyrilla paniculata Nutt." "9622" "3009" "9624"
"5188" "3bb93fa3-7e37-4899-b2d2-d86f01652151" "Astephanus grisebachii M. Gómez" "Astephanus cubensis Kunth" "Tylodontia cubensis Griseb." "5186" "6641" "5172"
"895" "3d27c563-6331-4ed3-a3f9-d9d24732c32d" "Aster grisebachii Britton" "Aster marginatus Kunth" "Haplopappus marginatus Griseb." "894" "313" "896"
"10002" "6e97eba8-ca32-4832-bf9f-39d3bf84e17b" "Bacopa cyclophylla Fernald" "Bacopa rotundifolia (Michx.) Wettst." "Herpestis rotundifolia Gaertn." "10004" "3126" "10003"
"6556" "3b62c9ab-ad76-4618-91ad-961b6e71d3a3" "Buxus wrightii Müll. Arg. subsp. wrightii" "Buxus microphylla Siebold & Zucc." "Tricera microphylla Griseb." "6557" "2123" "6558"
"19555" "6dc71434-009d-4e4e-a84a-7a5a1237ae4f" "Camaridium micranthum M. A. Blanco" "Camaridium parviflorum Fawc." "Scaphyglottis parviflora Poepp. & Endl." "19556" "5767" "19558"
"9660" "15b126cd-2e83-46d3-a4cd-070767db3217" "Casearia aquifolia C. Wright" "Casearia coriacea Vent." "Valentinia coriacea Griseb." "9661" "3023" "9662"
"20944" "f972fcfd-8496-42a6-96e2-08431ba11df0" "Catesbaea vavassorii Spreng." "Catesbaea spinosa L." "Cinchona spinosa Vavass." "20943" "6258" "20946"
"8459" "658b76ad-d0ae-401d-85b1-58ed1c695796" "Cinnamomum grisebachii Lorea-Hern." "Cinnamomum triplinerve (Ruiz & Pav.) Kosterm." "Phoebe triplinervis Griseb." "8461" "6659" "8473"
"299" "1cc3d027-af60-48c3-ae4d-1876b7322b47" "Conyza subspathulata Cronquist" "Conyza spathulata Hornem." "Erigeron spathulatus Vahl" "298" "115" "300"
"6185" "139e865e-a1c6-4826-ad1a-f1464d95c998" "Cordia van-hermannii Alain" "Cordia coriacea Killip" "Varronia coriacea Moldenke" "6184" "2013" "6186"
"13560" "c2102e36-61c1-43c4-b930-792b75abdf22" "Croton alainii B. W. van Ee & P. E. Berry" "Croton lanceolatus Cav." "Moacroton lanceolatus Alain" "13562" "4045" "13561"
"5382" "22691f2b-7496-42b5-8453-43f2d3df7ea2" "Cynanchum caribaeum Alain" "Cynanchum hamatum (E. Mey.) D. Dietr." "Metastelma hamatum Griseb." "5384" "1791" "5383"
"5183" "638a841e-27da-4daa-96a3-9eed2ffca577" "Cynanchum ekmanii Alain" "Cynanchum schlechterianum Warb." "Astephanus schlechterianus Urb." "5182" "1703" "5184"
"5187" "70b5e248-3f27-4012-b677-cf3ce6e99ba7" "Cynanchum grisebachii (M. Gómez) Woodson" "Cynanchum cubense (A. Rich.) Woodson" "Tylodontia cubensis Griseb." "5186" "6639" "5031"
"5378" "72b9e266-cf24-49ee-81d6-1f5c2a4f6e4b" "Cynanchum ophiticola Alain" "Cynanchum cubense (A. Rich.) Woodson" "Metastelma cubense Decne." "5377" "6637" "5031"
"5218" "9783775b-f8b1-407d-bf42-ed2e17ef9c59" "Cynanchum orientense Alain" "Cynanchum pauciflorum (Miq.) Matsum." "Astephanus cubensis var. pauciflorus Griseb." "5217" "1715" "5219"
"5169" "7308b0a1-12f8-4ba6-902b-a3d0a8dc9f18" "Cynanchum pubipetalum Alain" "Cynanchum cubense (A. Rich.) Woodson" "Astephanus cubensis Kunth" "5172" "6638" "5031"
"5332" "4c4cb938-bee8-4bc1-88f0-65dc4c35bf40" "Cynanchum richardianum Alain" "Cynanchum ovalifolium Wight" "Astephanus ovalifolius A. Rich." "5334" "1767" "5333"
"5287" "2101a8a7-e05d-4051-a7ef-c61398405581" "Cynanchum sauvallei Alain" "Cynanchum filiforme Jacq." "Amphistelma filiforme Griseb." "5286" "1752" "5288"
"5360" "66e0957c-93dd-42c0-ae30-166d6adea554" "Cynanchum savannarum Alain" "Cynanchum linearifolium Hemsl." "Metastelma linearifolium A. Rich." "5359" "1779" "5361"
"5196" "478cd5be-53c0-4a08-bd05-4a86b4ac5b3e" "Cynanchum wrightianum Alain" "Cynanchum urceolatum (E. Fourn.) K. Schum." "Astephanus urceolatus Griseb." "5195" "1711" "5197"
"2282" "741006c1-4e3e-401d-9e94-b1a4cff73482" "Cyperus densicaespitosus Mattf. & Kük." "Cyperus pumilus L." "Kyllinga pumila Michx." "2281" "764" "2283"
"2288" "8fbd4ae4-a33a-4db2-9fa4-41eb622c37b9" "Cyperus neourbanii Kük." "Cyperus urbanii Boeckeler" "Kyllinga urbanii Kük." "2287" "767" "2289"
"1966" "4d27b0f5-f1e3-4275-bfdc-f2dfebb3b0a0" "Cyperus subumbellatus Kük." "Cyperus alternifolius L." "Mariscus alternifolius Vahl" "1967" "637" "1968"
"1913" "77464776-5824-46fc-a540-01c5d6603935" "Cyperus tenuis var. capillaris (Sw.) Kük." "Cyperus capillaris J. Koenig ex Roxb." "Schoenus capillaris Sw." "1911" "621" "1914"
"9898" "f0fd06d0-291a-4545-9d0b-5c924a2d4e94" "Dendrophthora podocarpicola Leiva" "Dendrophthora cubensis Eichler" "Arceuthobium cubense Leiva & Bisse" "9900" "6670" "9852"
"7758" "951bf2ab-66ba-4cdc-8e5d-60e9c873a15f" "Diospyros grisebachii (Hiern) Standl." "Diospyros buxifolia (Blume) Hiern" "Macreightia buxifolia Griseb." "7761" "2471" "7763"
"6975" "8427e1bb-f7d2-4e61-92e2-3cb485ea33a0" "Drymaria cubana Alain" "Drymaria glandulosa Bartl." "Pinosia glandulosa Alain" "6976" "2264" "6977"
"6004" "85d10d2c-af18-4d75-ad8c-e7ae1893a2f2" "Ehretia grisebachii M. Gómez" "Ehretia microphylla Lam." "Bourreria microphylla Griseb." "6002" "1956" "6005"
"19710" "a9373b2f-28fe-4956-a066-e34fe8d1e1d3" "Elleanthus cephalotus Garay & H. R. Sweet" "Elleanthus capitatus (Poepp. & Endl.) Rchb. f." "Bletia capitata R. Br." "19712" "5833" "19711"
"18963" "426d2244-a1f5-4cd6-8c9e-3cadb0f1f9c2" "Eugenia bergiana Griseb." "Eugenia pseudopsidium Jacq." "Stenocalyx pseudopsidium O. Berg" "18965" "6577" "22085"
"19025" "d1e2da89-e1d7-4761-aa74-5047d21211b2" "Eugenia borhidiana Z. Acosta" "Eugenia acunae Alain" "Plinia acunae Borhidi & O. Muñiz" "19027" "6716" "18923"
"742" "529b9f54-4415-4577-94ea-667942b0d476" "Eupatorium cowleyanum M. Gómez & Molinet" "Eupatorium gonocladum DC." "Mikania gonoclada DC." "743" "265" "744"
"740" "33fe05ab-54ac-473b-9796-48708fa97891" "Eupatorium marquezii M. Gómez" "Eupatorium molle Sw." "Mikania mollis Kunth" "739" "263" "741"
"236" "d3dc2125-5e24-49da-a2ea-85c561e904d0" "Eupatorium planellasianum M. Gómez & Molinet" "Eupatorium domingense Spreng." "Ageratum domingense Spreng." "234" "99" "237"
"13533" "f490a0c4-b2ce-4145-8731-87b208184b06" "Euphorbia millspaughii V. W. Steinm. & P. E. Berry" "Euphorbia brittonii Millsp." "Cubanthus brittonii Millsp." "13535" "6628" "13420"
"13369" "e0898041-8af5-4085-b052-caf2ec78b8fb" "Euphorbia podocarpifolia Urb." "Euphorbia linearifolia Roth" "Euphorbiodendron linearifolium Millsp." "13371" "6629" "13502"
"13499" "63028ad7-cb75-4ce7-9890-9fe8b360442b" "Euphorbia scutiformis V. W. Steinm. & P. E. Berry" "Euphorbia linearifolia Roth" "Pedilanthus linearifolius Griseb." "13500" "4028" "13502"
"2065" "9aec88ac-35e5-4f00-bb5f-2514b7cacef3" "Fimbristylis grisebachii Greenm. ex Combs" "Fimbristylis setacea Benth." "Abildgaardia setacea Griseb." "2064" "689" "2067"
"2060" "4e91596c-30a8-4390-8ff7-422969a9abb4" "Fimbristylis savannarum Alain" "Fimbristylis arenaria Nees" "Oncostylis arenaria Nees" "2059" "684" "2061"
"7340" "e2055b79-76d7-4170-b14f-4be9076298b3" "Garcinia clarensis Borhidi" "Garcinia brevipes Pierre" "Rheedia brevipes Britton" "7342" "2365" "7341"
"7354" "71a16606-b021-4c81-afdc-35f7df0e2b3c" "Garcinia pungens Borhidi" "Garcinia elliptica Choisy" "Rheedia elliptica C. Wright" "7355" "2373" "7356"
"7330" "d583e25a-97b8-4006-89ba-27c51e61e27e" "Garcinia serpentini Borhidi" "Garcinia fruticosa Lauterb." "Rheedia fruticosa C. Wright ex Griseb." "7331" "2361" "7332"
"20667" "fa9fe970-3ed3-4ba3-afcd-815c9462c631" "Gardenia armata Sw." "Gardenia spinosa Thunb." "Mussaenda spinosa Jacq." "20669" "6172" "20668"
"8198" "354e80d7-0148-4262-a738-1754aa642b4d" "Gesneria mortonii Wiehler" "Gesneria cubensis (Decne.) Baill." "Heppiella cubensis C. V. Morton" "8197" "6658" "8077"
"8157" "95f683e8-ce01-4862-838e-9ea64aadbdf4" "Gesneria wrightii Urb." "Gesneria triflora M. Martens & Galeotti" "Pentaraphia triflora Griseb." "8158" "2585" "8159"
"97" "9fad6207-4395-495c-912c-3a09051a7da9" "Gochnatia sagrana R. N. Jervis & Alain" "Gochnatia ilicifolia Less." "Anastraphia ilicifolia D. Don" "96" "39" "98"
"4501" "84b68642-af10-4d7d-8420-5ff4e47cb205" "Justicia neoglandulosa M. Gómez" "Justicia glandulosa B. Heyne ex Roth" "Dianthera glandulosa Griseb." "4500" "1506" "4502"
"19434" "2e542af7-5aaf-4b53-ae67-1ba6656688ba" "Krokia leonis Borhidi & O. Muñiz" "Krokia moaensis (Areces) Borhidi & O. Muñiz" "Pimenta moaensis Borhidi & O. Muñiz" "19433" "6721" "19363"
"6877" "bf20a29d-76aa-4609-ac0b-f754e26705ec" "Lobelia cubana Urb." "Lobelia montana Reinw. ex Blume" "Tupa montana C. Wright ex Griseb." "6878" "2231" "6879"
"7759" "e3ac3fe9-6d3f-4d94-bfc6-09782e5b69c7" "Maba grisebachii Hiern" "Maba buxifolia (Rottb.) Juss." "Macreightia buxifolia Griseb." "7761" "2470" "7762"
"16594" "c69306ef-1ae4-4ebd-9ee1-f9aebc32ae77" "Malpighia substrigosa F. K. Mey." "Malpighia oblongifolia Griseb." "Malpighia nummulariifolia subsp. oblongifolia Vivaldi" "16596" "6565" "22075"
"5170" "86076b74-638d-4ca4-bc63-6bfe93dbcd76" "Metastelma pubipetalum (Alain) Liede" "Metastelma cubense Decne." "Astephanus cubensis Kunth" "5172" "6640" "5377"
"16900" "cd796df4-7852-4258-aae7-20384d6a7c6d" "Miconia acunagalei Judd & al." "Miconia acunae Borhidi" "Ossaea acunae Alain" "16901" "6729" "16935"
"16910" "175ba892-27fe-4bbd-bf72-69cb8d175159" "Miconia argentimuricata Majure & Judd" "Miconia muricata (D. Don) Triana" "Calycogonium muricatum Griseb." "16911" "5059" "16913"
"16925" "3fb80d7e-ef89-4aef-9f6c-197c44b559d1" "Miconia ascenditricha Judd & al." "Miconia elliptica Macfad." "Ossaea elliptica Alain" "16927" "6747" "17103"
"17165" "90855603-c8be-4a62-a9a8-1fcde4d4a6f0" "Miconia borhidiana Judd & al." "Miconia baracoensis Urb." "Ossaea baracoensis Borhidi & O. Muñiz" "17166" "6731" "16909"
"17315" "9d0b66e7-398d-4e38-8f8a-6c45f7078f83" "Miconia cajalbanensis Judd & al." "Miconia coriacea (Sw.) DC." "Tetrazygia coriacea Urb." "17317" "6732" "16981"
"17257" "33fde4a2-bb20-4e1f-9428-d09d9f687fa5" "Miconia cubacinerea Majure & Judd" "Miconia cinerea Cogn." "Clidemia cinerea Griseb." "17258" "5198" "17262"
"17204" "c4e81df4-7c2c-4062-bdba-409dac487e5c" "Miconia glabrifolia Skean & al." "Miconia glabrata Cogn." "Melastoma glabratum Sw." "17203" "5174" "17205"
"17113" "9c404815-1381-4d01-a511-dddc893c6a97" "Miconia grandibracteata Judd & al." "Miconia involucrata Donn. Sm." "Calycogonium involucratum Griseb." "17115" "5130" "17114"
"17079" "83f59660-8599-4232-bfde-cf13117797ec" "Miconia guajaibonensis Judd & al." "Miconia lanceolata (Desr.) DC." "Tetrazygia lanceolata Urb." "17081" "5114" "17080"
"17129" "dd6f9fea-ee4a-45c6-ab64-b7fa3d195ae1" "Miconia jashaferi Majure & Judd" "Miconia shaferi Cogn." "Ossaea shaferi Britton & P. Wilson" "17131" "6733" "17318"
"17312" "98d680b9-f6a1-4a80-98bb-8790bce9d832" "Miconia karsticola Judd & al." "Miconia saxicola Brandegee" "Calycogonium saxicola Britton & P. Wilson" "17314" "5218" "17313"
"17107" "0309faf5-8a68-4094-bc3b-553fec7e12c5" "Miconia lanatifolia Judd & al." "Miconia lanata Triana" "Sagraea lanata Naudin" "17109" "5126" "17108"
"17211" "ee2ce788-7a9b-4dbe-b049-f2f14b97c54c" "Miconia maestrensis Judd & al." "Miconia lambertiana DC." "Miconiastrum lambertianum Bonpl. ex Naudin" "17213" "5177" "17212"
"17134" "1095e076-f4af-4160-a7d8-6337078f7579" "Miconia pratensis Judd & al." "Miconia microphylla (C. Wright) M. Gómez" "Melastoma microphyllum Sw." "17136" "6570" "16764"
"17087" "f5f0eba3-1d55-4cff-9aa0-ce95a223b2ae" "Miconia pulverata Judd & al." "Miconia pulverulenta Ruiz & Pav." "Ossaea pulverulenta Urb." "17088" "5119" "17089"
"17269" "97426364-eedd-443d-9bf6-b50d44f57afc" "Miconia scaberrima Judd & al." "Miconia wilsonii Cogn." "Ossaea wilsonii Alain" "17271" "6736" "17250"
"16973" "c04434ac-c705-4234-9563-cde7cd2017b5" "Miconia secundo-angustifolia M. Gómez" "Miconia angustifolia (Sw.) Griseb." "Pachyanthus angustifolius Griseb." "16972" "6737" "17029"
"16754" "33285e51-4192-4019-9dcd-f2ca3b6fca11" "Miconia secundo-lanceolata M. Gómez" "Miconia lanceolata (Desr.) DC." "Calycogonium lanceolatum Griseb." "16753" "6728" "17080"
"17125" "82e21ddf-a72d-4595-b444-daa118dd419f" "Miconia tentaculicapitata Majure & Judd" "Miconia capitata Ule" "Ossaea capitata Urb." "17126" "5137" "17127"
"17071" "4860cff2-b7d9-4b02-8ba6-729149a38eb1" "Miconia yunquensis Judd & al." "Miconia heterotricha Wurdack" "Clidemia heterotricha Griseb." "17072" "5112" "17075"
"18941" "a09258bd-6c92-44b0-b10a-eb8513e97fc2" "Myrtus anomala Burret" "Myrtus bullata Salisb." "Psidium bullatum Britton & P. Wilson" "18940" "5566" "18942"
"19099" "d423dcbf-e0f5-47be-b70f-a390ac0a8fa3" "Myrtus willdenowii Spreng." "Myrtus zeylanica L." "Eugenia zeylanica Willd." "19098" "5587" "19100"
"14918" "16d767a2-d394-4575-8242-a02ab4ec4852" "Notodon roigii Britton & P. Wilson" "Notodon gracilis (Griseb.) Urb." "Corynella gracilis Griseb." "14919" "6695" "14915"
"8418" "8ddc3ae7-25ec-49c6-8939-2362c670d77c" "Ocotea bissei Imkhan." "Ocotea similis Kosterm." "Persea similis Britton & P. Wilson" "8420" "2652" "8419"
"21280" "fcb25635-b779-43ed-a4bb-9bc87d7b8994" "Palicourea orientensis Borhidi & Oviedo" "Palicourea subalata Standl. ex Steyerm." "Psychotria subalata C. Wright ex Griseb." "21282" "6346" "21281"
"3539" "a4f4cc22-d8b5-4f65-a7e8-bc485bf79aa2" "Panicum nudiculme Mez" "Panicum ovinum Scribn. & J. G. Sm." "Triscenia ovina Griseb." "3538" "1209" "3540"
"3733" "4e7e2872-ba5c-4dd4-b2a8-4a5baae9cd57" "Paspalum pulchellum Kunth" "Paspalum elegans Flüggé" "Reimaria elegans Humb. & Bonpl. ex Flüggé" "3734" "1283" "3735"
"13813" "bc3435ec-2d24-40e1-a59d-b42dd3a3f5dd" "Phyllanthus brittonii Alain" "Phyllanthus ovalifolius Forssk." "Conami ovalifolia Britton" "13812" "4105" "13814"
"11007" "97a5995b-427d-4bc3-970c-982657c2495b" "Polygala dimorphophylla S. F. Blake" "Polygala heterophylla Scheele" "Badiera heterophylla Britton" "11006" "3393" "11008"
"11009" "0850c444-ea21-4216-888e-d53460dea264" "Polygala punctifera S. F. Blake" "Polygala punctata A. W. Benn." "Badiera punctata Britton" "11011" "3394" "11010"
"10996" "b95192f6-cce2-4892-a3a8-bfe063e95304" "Polygala stipitata S. F. Blake" "Polygala cubensis Chodat" "Badiera cubensis Britton" "10995" "6680" "11047"
"12015" "29e56d04-613c-4c7e-b936-5b74469179b4" "Pouteria cubensis Baehni" "Pouteria grandifolia (Wall.) Baehni" "Labatia grandifolia Urb." "12016" "3647" "12017"
"11331" "fd187fd0-76b2-4b86-ae13-b91e59f4cade" "Reynosia wrightii Urb." "Reynosia retusa Griseb." "Rhamnidium retusum Griseb." "11333" "6682" "11327"
"2709" "9d6506f5-2061-4414-bdf8-e72e2df769be" "Rhynchospora subsetigera H. Pfeiff." "Rhynchospora grisebachii Boeckeler ex Kük." "Dichromena grisebachii C. B. Clarke" "2711" "890" "2710"
"2597" "4d3208b1-efc4-4906-8923-8d96bd66331a" "Rhynchospora tracyi Britton" "Rhynchospora capitata (Kunth) Roem. & Schult." "Ceratoschoenus capitatus Chapm." "2598" "871" "2599"
"4615" "c4e6262b-614e-49c3-a777-dd18b61ff25a" "Ruellia tweedieana Griseb." "Ruellia angustifolia Sw." "Cryphiacanthus angustifolius Nees" "4617" "1552" "4616"
"11947" "fae0f2bd-b677-448b-819c-bb9f9aa2f317" "Schmidelia occidentalis Sw." "Schmidelia racemosa L." "Allophylus racemosus Sw." "11946" "3628" "11949"
"2740" "943fcb90-2312-40b1-8228-03f3e6ce0f67" "Scleria liebmannii Steud." "Scleria purpurascens Steud." "Hypoporum purpurascens Liebm." "2742" "902" "2741"
"159" "c2316fd6-d98f-4cb3-b3a1-dfbb03038393" "Senecio almironcillo M. Gómez" "Senecio discolor (Sw.) DC." "Cacalia discolor Griseb." "158" "67" "161"
"12057" "b0f9cc6a-b01e-446e-9d9c-9d72e42db644" "Sideroxylon angustum T. D. Penn." "Sideroxylon revolutum Baker" "Bumelia revoluta Urb." "12058" "3668" "12059"
"21198" "094f1629-a272-4b87-b520-def62463378a" "Spermacoce garro M. Gómez" "Spermacoce radicans Aubl." "Diodia radicans Cham. & Schltdl. ex DC." "21200" "6312" "21199"
"21179" "aaa49842-4741-4315-9423-0bb66c657798" "Spermacoce sarcophylla M. Gómez" "Spermacoce crassifolia DC." "Mitracarpus crassifolius A. Rich." "21180" "6307" "21181"
"20249" "ab417f8c-b86d-4dd2-8b52-2b13595e423c" "Spiranthes swartzii E. H. L. Krause" "Spiranthes spiralis (L.) Chevall." "Satyrium spirale Sw." "20248" "6050" "20250"
"5637" "2de58fe9-97e0-480f-9c54-405285e6664d" "Tabebuia sauvallei Britton" "Tabebuia sanguinea DC." "Tecoma sanguinea C. Wright" "5638" "1858" "5639"
"5331" "86d7d36b-5fcc-4dd5-b74e-2cae9f2645d7" "Tassadia richardiana (Alain) Liede & Mangelsdorff" "Tassadia ovalifolia (E. Fourn.) Fontella" "Astephanus ovalifolius A. Rich." "5334" "1771" "5336"
"16707" "105e6f16-66f7-49f7-9078-bb210b18a3da" "Tibouchina heteronoma M. Gómez" "Tibouchina cubensis (A. Rich.) M. Gómez" "Heteronoma cubense Naudin" "16706" "6727" "17047"
"20094" "81f6a7a2-b241-4006-befa-05794b54bae8" "Trichosalpinx acunae Luer" "Trichosalpinx obliquipetala (Ames & C. Schweinf.) Luer" "Pleurothallis obliquipetala Acuña & C. Schweinf." "20092" "5985" "20095"
"10853" "471c0d65-266c-4306-9230-a1701dea4117" "Verhuellia pellucida Schmitz" "Verhuellia elegans Miq." "Mildea elegans Griseb." "10854" "6675" "10852"
"11544" "b031a183-a394-4f18-bc6e-7f60e239df9e" "Zanthoxylum cubense P. Wilson" "Zanthoxylum juglandifolium Willd." "Fagara juglandifolia Krug & Urb ex Engl." "11547" "6683" "11578"
"11405" "2715fa2e-ff09-4cf3-afcf-f95205f095ab" "Ziziphus grisebachiana M. C. Johnst." "Ziziphus divaricata Davidson & Moxley" "Sarcomphalus divaricatus Griseb." "11407" "3491" "11406"
"16715" "0d69373e-077c-4653-ad60-1668967373ef" "[Miconia glomeruliflora Judd & al.]" "Miconia glomerata Triana" "Sagraea glomerata Naudin" "16716" "4985" "16719"
"20665" "d5537f58-3d6d-48ff-ade1-49b20bf90655" "[Randia armata (Sw.) DC.]" "Randia spinosa Poir." "Mussaenda spinosa Jacq." "20669" "6170" "20666"
Updated by Andreas Müller over 7 years ago
Use tmp table
INSERT INTO _tmpBlockName (relId, rsID, bnID, rnID)
SELECT bnrel.id bnrelid, rs.id rsid, bn.id, tnb.id
FROM TaxonNameBase tnb INNER JOIN NameRelationship bnrel ON bnrel.relatedTo_id = tnb.id AND bnrel.type_id = 902
INNER JOIN TaxonNameBase bn ON bnrel.relatedFrom_id = bn.id
INNER JOIN NameRelationship rsrel ON rsrel.relatedTo_id = tnb.id AND rsrel.type_id = 906
INNER JOIN TaxonNameBase rs ON rsrel.relatedFrom_id = rs.id
WHERE tnb.id
IN
(SELECT relatedTo_id FROM NameRelationship nr WHERE nr.type_id = 906)
ORDER BY tnb.titleCache
UPDATE NameRelationship nr
SET nr.relatedTo_id = (SELECT rsID FROM _tmpBlockName tmp WHERE tmp.relID = nr.id)
WHERE nr.id IN ( SELECT tmp.relID FROM _tmpBlockName tmp)
Updated by Andreas Müller over 7 years ago
- Status changed from New to Closed
- % Done changed from 90 to 100
Actions