Percentile Ranks KB

example.md

    select
        pk_items,
        count,
        wos_b_2019.d_percentiles.c_max,
        wos_b_2019.classifications.classification,
        wos_b_2019.items.pubyear,
        wos_b_2019.items.doctype,
        wos_b_2019.items.pubtype,
        wos_b_2019.d_percentiles.pk_d_percentiles  
    from
        wos_b_2019.items      
    inner join
        wos_b_2019.items_classifications             
            on wos_b_2019.items_classifications.fk_items = wos_b_2019.items.pk_items     
    inner join
        wos_b_2019.classifications             
            on wos_b_2019.classifications.pk_classifications = wos_b_2019.items_classifications.fk_classifications     
    inner join
        wos_b_2019.citingcounts             
            on wos_b_2019.citingcounts.fk_items = wos_b_2019.items.pk_items     
    inner join
        wos_b_2019.d_percentiles             
            on wos_b_2019.d_percentiles.fk_classifications = wos_b_2019.classifications.pk_classifications  
            and                wos_b_2019.items.doctype = wos_b_2019.d_percentiles.doctype 
            and                wos_b_2019.items.pubyear = wos_b_2019.d_percentiles.pubyear 
            and                wos_b_2019.items.pubtype = wos_b_2019.d_percentiles.pubtype 
    where
        wos_b_2019.items.pk_items = '23916998' 
        and wos_b_2019.classifications.classification_type = 'sc_extended'

PK_ITEMS	COUNT	C_MAX	CLASSIFICATION	PUBYEAR	DOCTYPE	PUBTYPE	PK_D_PERCENTILES
23916998	8614	4010	Crystallography	2015	Article	Journal	2202000
23916998	8614	4010	Chemistry	2015	Article	Journal	2203153