There were no calibrations found in your requested clade. This is the nearest enclosing clade with calibrations.
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 (453, 456, 455, 461) 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
-
Antliophora
— (1)
-
Aparaglossata
— (1)
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE clade_root_multitree_id = '-1926' 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 = '-1926' AND is_direct_relationship = 1 AND is_custom_child_node != 1) AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
-
… Lepidoptera
— (0)
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE clade_root_multitree_id = '85604' 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 = '85604' AND is_direct_relationship = 1 AND is_custom_child_node != 1) AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
-
… Amphiesmenoptera
— (2)
show as search results
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE clade_root_multitree_id = '85817' 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 = '85817' AND is_direct_relationship = 1 AND is_custom_child_node != 1) AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
-
… Neuropterida
— (3)
show as search results
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE clade_root_multitree_id = '-1508' 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 = '-1508' AND is_direct_relationship = 1 AND is_custom_child_node != 1) AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
-
Coleoptera
— (0)
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE clade_root_multitree_id = '-1928' 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 = '-1928' AND is_direct_relationship = 1 AND is_custom_child_node != 1) AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
-
Diptera
— (0)
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE clade_root_multitree_id = '-1509' 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 = '-1509' AND is_direct_relationship = 1 AND is_custom_child_node != 1) AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
-
Hymenoptera
— (0)
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE clade_root_multitree_id = '-1844' 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 = '-1844' AND is_direct_relationship = 1 AND is_custom_child_node != 1) AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
-
Mecoptera
— (1)
show as search result