Wikipedia:WikiProject Chemicals/Lists of pages/Chembox templates transclusion count

Transclusion count of Category:Chembox templates. Topbanana please update. -DePiep (talk) 22:41, 12 August 2017 (UTC)[reply]

Overview 1

edit

The report below lists templates that are members of Category:Chembox templates along with the number of times each is transcluded into namespace 0. It was generated on tool labs by TB (talk) 16:59, 23 November 2016 (UTC).[reply]

Report 1: Chembox in articles

edit
Template Transclusions
Chembox_Elements/molecular_formula 16507
Chembox_templatePar/formatPreviewMessage 10191
Chembox_Footer 10191
Chembox 10191
Chembox_headerbar 10184
Chembox_Properties 10168
Chembox_Identifiers 10149
Chembox_Elements 10025
Chembox_removeInitialLinebreak 10017
Chembox_image_sbs 9682
Chembox_image 9682
Chembox_CASNo 9138
Chembox_CASNo/format 9137
Chembox_AllOtherNames 9097
Chembox_AllOtherNames/format 9097
Chembox_SMILES 9036
Chembox_Jmol 9036
Chembox_Jmol/format 9036
Chembox_SMILES/format 9036
Chembox_image_cell 8960
Chembox_Hazards 8753
Chembox_InChI 8464
Chembox_InChI/format 8464
Chembox_ChemSpiderID 8291
Chembox_ChemSpiderID/format 8291
Chembox_PubChem 8132
Chembox_PubChem/format 8132
Chembox_verification 7061
Chembox_CalcTemperatures 4866
Chembox_MeltingPt 4302
Chembox_Appearance 4052
Chembox_Density 3653
Chembox_ChEBI/format 3063
Chembox_ChEBI 3063
Chembox_SolubilityInWater 2909
Chembox_BoilingPt 2906
Chembox_ChEMBL/format 2748
Chembox_ChEMBL 2748
Chembox_UNII/format 2343
Chembox_UNII 2343
Chembox_Related 2205
Chembox_ECNumber 1807
Chembox_KEGG/format 1629
Chembox_KEGG 1629
Chembox_FlashPt 1597
Chembox_Structure 1477
Chembox_NFPA 1402
Chembox_RPhrases 1372
Chembox_SPhrases 1348
Chembox_Solubility 1161
Chembox_image_sbs_cell 1128
Chembox_OtherCpds 1093
Chembox_subHeader 1086
Chembox_subDatarow 1086
Chembox_RTECS 1069
Chembox_MeSHName 1064
Chembox_EUClass 1025
Chembox_SDS 972
Chembox_Thermochemistry 954
Chembox_MainHazards 912
Chembox_Odour 790
Chembox_Lethal_amounts_(set) 789
Chembox_Pharmacology 721
Chembox_CrystalStruct 701
Chembox_OtherFunctn 669
Chembox_VaporPressure 642
Chembox_RefractIndex 640
Chembox_OtherCations 631
Chembox_NIOSH_(set) 622
Chembox_DeltaHf 584
Chembox_OtherAnions 581
Chembox_IUPHAR_ligand/format 578
Chembox_IUPHAR_ligand 578
Chembox_pKa 542
Chembox_UNNumber 469
Chembox_Beilstein 456
Chembox_ATCCode 432
Chembox_DrugBank/format 418
Chembox_DrugBank 418
Chembox_GHSPictograms 402
Chembox_HPhrases 397
Chembox_Entropy 391
Chembox_Abbreviations 382
Chembox_LogP 382
Chembox_GHSSignalWord 367
Chembox_AutoignitionPt 363
Chembox_PPhrases 354
Chembox_HeatCapacity 343
Chembox_SpaceGroup 316
Chembox_ExploLimits 285
Chembox_Coordination 271
Chembox_Explosive 264
Chembox_Dipole 257
Chembox_Gmelin 253
Chembox_MolShape 195
Chembox_DeltaHc 194
Chembox_Viscosity 183
Chembox_pKb 153
Chembox_Supplement 147
Chembox_LattConst 112
Chembox_3DMet 111
Chembox_HenryConstant 108
Chembox_DeltaGf 98
Chembox_AdminRoutes 55
Chembox_BandGap 54
Chembox_PointGroup 53
Chembox_SolubilityProduct 45
Chembox_LambdaMax 43
Chembox_ThermalConductivity 40
Chembox_Pharmacokinetics_(set) 40
Chembox_ShockSens 34
Chembox_DetonationV 33
Chembox_Legal_status 33
Chembox_Legal_status/format 33
Chembox_FrictionSens 31
Chembox_SpecRotation 24
Chembox_MagSus 21
Chembox_TLV 19
Chembox_ElectronMobility 17
Chembox_PregCat/format 17
Chembox_PregCat 17
Chembox_RSPhrases 16
Chembox_REFactor 15
Chembox_EyeHazard 11
Chembox_Absorbance 10
Chembox_SkinHazard 10
Chembox_SublimationConditions 9
Chembox_CMC_HLB_(set) 9
Chembox_InhalationHazard 8
Chembox_IsoelectricPt 7
Chembox_IngestionHazard 5
Chembox_AtmosphericOHRateConstant 4
Chembox_Dependence_liability 4
Chembox_E_number 3
Chembox_OrbitalHybridisation 3
Chembox_CrystalStructVolume 2
Chembox_Addiction_liability 2
Chembox_SpecificSurfaceArea 2
Chembox_CrystalStructFormulas 2
Chembox_parametercheck 1
Chembox_NIOSH_(set)/formatPocketGuideLink 1
Chembox_AveragePoreSize 1
Chembox_PoreVolume 1
Chembox_CriticalRelativeHumidity 1
Chembox_Licence 0

Regenerating 1

edit

The information in this report was extracted from enwiki_p usinf the query below:

DROP TABLE IF EXISTS temp_chemtemplates;
 
CREATE TABLE temp_chemtemplates AS
  SELECT MIN(t.page_namespace) 'ctp_namespace', MIN(t.page_title) 'ctp_title', 0 'ctp_count'
  FROM enwiki_p.categorylinks
  INNER JOIN enwiki_p.page t ON t.page_id = cl_from
  WHERE cl_to = 'Chembox_templates'
  AND t.page_namespace = 10
  GROUP BY t.page_id;

UPDATE temp_chemtemplates
SET ctp_count = (
  SELECT count(*)
  FROM enwiki_p.templatelinks
  INNER JOIN enwiki_p.page ON page_id = tl_from
  WHERE tl_namespace = ctp_namespace
  AND   tl_title = ctp_title
  AND   page_namespace = 0 );
  
SELECT ctp_title, ctp_count
FROM temp_chemtemplates;

Overview 2

edit

The report below lists templates that are members of Category:Chembox templates or any direct subcategory of this, along with the number of times each is transcluded into any namespce. It was generated on tool labs by TB (talk) 16:59, 23 November 2016 (UTC).[reply]

edit
Template Transclusions
Chem_molar_mass 17219
Chem_molar_mass/format 17219
Chembox_Elements/molecular_formula 17210
ParmPart 11786
Chembox_templatePar/formatPreviewMessage 10642
Chembox_Footer 10635
Chembox 10633
Chembox_headerbar 10613
Chembox_Properties 10494
Chembox_Identifiers 10480
Chembox_removeInitialLinebreak 10348
Chembox_Elements 10344
Chembox_image 9965
Chembox_image_sbs 9963
Chembox_CASNo 9408
Chembox_CASNo/format 9407
Chembox_AllOtherNames/format 9396
Chembox_AllOtherNames 9394
Chembox_Jmol/format 9237
Chembox_SMILES 9235
Chembox_SMILES/format 9235
Chembox_Jmol 9235
Chembox_image_cell 9222
Chembox_Hazards 9039
Chembox_InChI/format 8624
Chembox_InChI 8624
Chembox_ChemSpiderID/format 8449
Chembox_ChemSpiderID 8449
Chembox_PubChem/format 8320
Chembox_PubChem 8320
Chembox_verification 7173
Chembox_CalcTemperatures 5174
Chembox_MeltingPt 4478
Chembox_Appearance 4222
Chembox_Density 3810
Chembox_ChEBI 3129
Chembox_ChEBI/format 3129
Chembox_BoilingPt 3046
Chembox_SolubilityInWater 3035
Chembox_ChEMBL 2804
Chembox_ChEMBL/format 2804
Chembox_UNII/format 2391
Chembox_UNII 2391
Chembox_Related 2315
Chembox_ECNumber 1866
Chembox_FlashPt 1698
Chembox_KEGG 1680
Chembox_KEGG/format 1680
NFPA_704_diamond 1570
Chembox_Structure 1567
Chembox_NFPA 1487
Chembox_RPhrases 1439
Chembox_SPhrases 1415
Chembox_Solubility 1212
Chembox_image_sbs_cell 1183
Chembox_subDatarow 1146
Chembox_subHeader 1146
Chembox_RTECS 1116
Chembox_OtherCpds 1111
Chembox_MeSHName 1096
Chembox_EUClass 1077
Chembox_Thermochemistry 1036
Chembox_SDS 994
Chembox_MainHazards 981
Chembox_Lethal_amounts_(set) 824
Chembox_Odour 816
Chembox_Pharmacology 786
Chembox_CrystalStruct 730
Chembox_OtherFunctn 690
Chembox_VaporPressure 688
Chembox_header 674
Chembox_RefractIndex 673
Chembox_OtherCations 661
Chembox_NIOSH_(set) 642
Chembox_DeltaHf 623
Chembox_OtherAnions 609
Chembox_IUPHAR_ligand/format 584
Chembox_IUPHAR_ligand 584
Chembox_pKa 584
ATC 514
Chembox_UNNumber 497
Chembox_Beilstein 493
Chembox_DrugBank 438
Chembox_DrugBank/format 438
Chembox_ATCCode 436
Chembox_GHSPictograms 425
Chembox_Entropy 424
Chembox_HPhrases 418
H-phrases 407
Chembox_LogP 404
Chembox_Abbreviations 400
Chembox_AutoignitionPt 385
Chembox_GHSSignalWord 379
Chembox_PPhrases 374
Chembox_HeatCapacity 369
P-phrases 369
Chembox_SpaceGroup 333
Chembox_Explosive 316
Chembox_ExploLimits 311
Chembox_Coordination 296
Chembox_Dipole 293
Chembox_Gmelin 274
ATCvet 229
Chembox_MolShape 221
Chembox_DeltaHc 217
Chembox_Viscosity 196
Chembox_pKb 169
Chembox_Supplement 163
Chembox_LattConst 130
Chembox_3DMet 123
Chembox_HenryConstant 117
Chembox_DeltaGf 112
Chembox_Pharmacology/doc/parameter_list 102
Chembox_Related/doc/parameter_list 102
Chembox_Explosive/doc/parameter_list 102
Chembox_Thermochemistry/doc/parameter_list 102
Chembox_Properties/doc/parameter_list 102
Chembox_Identifiers/doc/parameter_list 102
Chembox_Structure/doc/parameter_list 102
Chembox/doc/parameter_list 102
Chembox_Hazards/doc/parameter_list 102
Chembox/doc/images/parameter_list 102
Chembox_CalcTemperatures/doc/parameter_list 102
Chembox/doc/deprecations/parameter_list 102
Chembox_Footer/doc/parameter_list 101
Chembox_Supplement/doc/parameter_list 101
Navbox_Chembox 100
Chembox_AdminRoutes 78
Chembox_PointGroup 71
Chembox_Pharmacokinetics_(set) 67
Chembox_BandGap 56
Chembox_Legal_status/format 53
Chembox_Legal_status 51
Chembox_SolubilityProduct 48
Chembox_ShockSens 47
GHSp 46
Chembox_LambdaMax 46
Chembox_ThermalConductivity 42
Chembox_FrictionSens 42
Chembox_DetonationV 42
Chembox_TLV 31
Chembox_PregCat 29
Chembox_PregCat/format 29
Chembox_SpecRotation 29
Chembox_REFactor 26
Chembox_MagSus 23
Chembox_RSPhrases 22
Chembox_ElectronMobility 19
Chembox_OrbitalHybridisation 19
Chembox_Dependence_liability 18
Chembox_EyeHazard 16
Chembox_CrystalStructFormulas 16
Chembox_CrystalStructVolume 16
Chembox_Licence 16
Chembox_NIOSH_(set)/formatPocketGuideLink 15
Chembox/testcases/navbox 15
Chembox_SkinHazard 15
Chembox_Addiction_liability 14
Chembox_InhalationHazard 13
Chembox_IsoelectricPt 12
Chembox_Absorbance 12
Chembox_SublimationConditions 12
Chembox_CMC_HLB_(set) 11
Chembox_IngestionHazard 10
Chembox/doc/names 10
Chembox_AtmosphericOHRateConstant 7
Chembox_parametercheck 5
Chembox_SpecificSurfaceArea 4
Chembox_E_number 4
Chembox_CriticalRelativeHumidity 3
Chembox_AveragePoreSize 3
Chembox_PoreVolume 3
Chembox/doc/recently_added/parameter_list 1
Chembox/doc/Same_data_in_Chembox_and_Drugbox 0
Chembox/doc/full_parameter_list 0

Regenerating 2

edit

The information in this report was extracted from enwiki_p using the query below:

DROP TABLE IF EXISTS temp_catlist;
 
CREATE TABLE temp_catlist (
      ctl_id INT(8) UNSIGNED NOT NULL,
      ctl_name VARCHAR(255) BINARY NOT NULL,
      ctl_nestlevel INT(8) UNSIGNED NOT NULL,
 
      PRIMARY KEY (ctl_id)
);
 
TRUNCATE TABLE temp_catlist;
 
-- Initial category
INSERT INTO temp_catlist
SELECT page_id, page_title, 1
FROM enwiki_p.page
WHERE page_namespace = 14
AND   page_title = 'Chembox_templates';
 
-- Subcategories
INSERT INTO temp_catlist
SELECT page_id, page_title, ctl_nestlevel + 1
FROM enwiki_p.categorylinks
INNER JOIN temp_catlist ON cl_to = ctl_name
INNER JOIN enwiki_p.page ON page_id = cl_from
WHERE page_namespace = 14;
 

DROP TABLE IF EXISTS temp_chemtemplates;
 
CREATE TABLE temp_chemtemplates AS
  SELECT MIN(page_namespace) 'ctp_namespace', MIN(page_title) 'ctp_title', 0 'ctp_count'
  FROM temp_catlist
  INNER JOIN enwiki_p.categorylinks ON cl_to = ctl_name 
  INNER JOIN enwiki_p.page ON page_id = cl_from
  WHERE page_namespace = 10
  GROUP BY page_id;

 
UPDATE temp_chemtemplates
SET ctp_count = (
  SELECT COUNT(*)
  FROM enwiki_p.templatelinks
  INNER JOIN enwiki_p.page ON page_id = tl_from
  WHERE tl_namespace = ctp_namespace
  AND   tl_title = ctp_title );
 
SELECT ctp_title, ctp_count
FROM temp_chemtemplates;