QUERY:
SELECT DISTINCT TRIM(C.NodeName) AS NodeName, TRIM(C.ShortName) AS ShortName, C.*, img.image, img.caption AS image_caption, ht.DisplayOrder AS ht_display_order
FROM (
SELECT CF.CalibrationID, V . *
FROM View_Fossils V
JOIN Link_CalibrationFossil CF ON CF.FossilID = V.FossilID
) AS J
JOIN View_Calibrations C ON J.CalibrationID = C.CalibrationID
AND C.CalibrationID IN (397, 408) AND C.CalibrationID IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
LEFT JOIN publication_images img ON img.PublicationID = C.PublicationID
LEFT JOIN L_HigherTaxa ht ON ht.HigherTaxon = C.HigherTaxon
ORDER BY ht_display_order, NodeName, ShortName
-
Pedipalpi
— (1)
-
Tetrapulmonata
— (1)
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE clade_root_multitree_id = '6933' AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE (clade_root_multitree_id = '6933' AND is_direct_relationship = 1 AND is_custom_child_node != 1) AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
-
… Acari
— (2)
show as search results
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE clade_root_multitree_id = '-1887' AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE (clade_root_multitree_id = '-1887' AND is_direct_relationship = 1 AND is_custom_child_node != 1) AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
-
… Buthida
— (1)
show as search result
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE clade_root_multitree_id = '-1890' AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE (clade_root_multitree_id = '-1890' AND is_direct_relationship = 1 AND is_custom_child_node != 1) AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
-
Araneae
— (0)
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE clade_root_multitree_id = '-1886' AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE (clade_root_multitree_id = '-1886' AND is_direct_relationship = 1 AND is_custom_child_node != 1) AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
-
Solifugae
— (1)
show as search result
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE clade_root_multitree_id = '43271' AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE (clade_root_multitree_id = '43271' AND is_direct_relationship = 1 AND is_custom_child_node != 1) AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
-
Opiliones
— (1)
show as search result
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE clade_root_multitree_id = '-1883' AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE (clade_root_multitree_id = '-1883' AND is_direct_relationship = 1 AND is_custom_child_node != 1) AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
-
Pseudoscorpiones
— (1)
show as search result
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE clade_root_multitree_id = '-1888' AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE (clade_root_multitree_id = '-1888' AND is_direct_relationship = 1 AND is_custom_child_node != 1) AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
-
Uropygi
— (1)
show as search result
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE clade_root_multitree_id = '-1889' AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE (clade_root_multitree_id = '-1889' AND is_direct_relationship = 1 AND is_custom_child_node != 1) AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
-
Amblypygi
— (1)
show as search result
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE clade_root_multitree_id = '88344' AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE (clade_root_multitree_id = '88344' AND is_direct_relationship = 1 AND is_custom_child_node != 1) AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
-
Palpigradi
— (1)
show as search result