Project

General

Profile

bug #6024

Fix blocking name relationships for replacement names

Added by Andreas Müller almost 3 years ago. Updated almost 3 years ago.

Status:
Closed
Priority:
Highest
Category:
data
Target version:
-
Start date:
07/29/2016
Due date:
% Done:

100%

Estimated time:
3.00 h
Severity:
normal
Found in Version:
Tags:

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"

History

#1 Updated by Andreas Müller almost 3 years ago

  • Description updated (diff)

#2 Updated by Andreas Müller almost 3 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"

#3 Updated by Andreas Müller almost 3 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)

#4 Updated by Andreas Müller almost 3 years ago

  • % Done changed from 10 to 90

#5 Updated by Andreas Müller almost 3 years ago

  • Status changed from New to Closed
  • % Done changed from 90 to 100

#6 Updated by Andreas Müller almost 3 years ago

  • Target version deleted (Release 4.3)

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)