Data Diagnostics — Guru Master
Total records: 3,069  •  Total issues detected: 356
🔒 Read-only. Fix missing data on digjainwiki.org then run a sync.
3,069
Total Records
2
Hashtag Missing
49
Lineage Missing
1
Key Field Gaps
0
Unsynced Records
254
Duplicate Names
356
Total Issues

WordPress database error: [Unknown column 'sallekhna_place_ext' in 'field list']
SELECT COUNT(*) AS _total, SUM(CASE WHEN `guru_id` IS NOT NULL AND `guru_id` != '' AND `guru_id` != '0' THEN 1 ELSE 0 END) AS `guru_id`, SUM(CASE WHEN `status_id` IS NOT NULL AND `status_id` != '' AND `status_id` != '0' THEN 1 ELSE 0 END) AS `status_id`, SUM(CASE WHEN `category_id` IS NOT NULL AND `category_id` != '' AND `category_id` != '0' THEN 1 ELSE 0 END) AS `category_id`, SUM(CASE WHEN `job_title` IS NOT NULL AND `job_title` != '' AND `job_title` != '0' THEN 1 ELSE 0 END) AS `job_title`, SUM(CASE WHEN `guru_name` IS NOT NULL AND `guru_name` != '' AND `guru_name` != '0' THEN 1 ELSE 0 END) AS `guru_name`, SUM(CASE WHEN `guru_name_hindi` IS NOT NULL AND `guru_name_hindi` != '' AND `guru_name_hindi` != '0' THEN 1 ELSE 0 END) AS `guru_name_hindi`, SUM(CASE WHEN `hashtag` IS NOT NULL AND `hashtag` != '' AND `hashtag` != '0' THEN 1 ELSE 0 END) AS `hashtag`, SUM(CASE WHEN `guru_hash` IS NOT NULL AND `guru_hash` != '' AND `guru_hash` != '0' THEN 1 ELSE 0 END) AS `guru_hash`, SUM(CASE WHEN `group_hash` IS NOT NULL AND `group_hash` != '' AND `group_hash` != '0' THEN 1 ELSE 0 END) AS `group_hash`, SUM(CASE WHEN `vihar_group_key` IS NOT NULL AND `vihar_group_key` != '' AND `vihar_group_key` != '0' THEN 1 ELSE 0 END) AS `vihar_group_key`, SUM(CASE WHEN `senriority_no` IS NOT NULL AND `senriority_no` != '' AND `senriority_no` != '0' THEN 1 ELSE 0 END) AS `senriority_no`, SUM(CASE WHEN `djw_id` IS NOT NULL AND `djw_id` != '' AND `djw_id` != '0' THEN 1 ELSE 0 END) AS `djw_id`, SUM(CASE WHEN `saghnayak` IS NOT NULL AND `saghnayak` != '' AND `saghnayak` != '0' THEN 1 ELSE 0 END) AS `saghnayak`, SUM(CASE WHEN `ekalvihari` IS NOT NULL AND `ekalvihari` != '' AND `ekalvihari` != '0' THEN 1 ELSE 0 END) AS `ekalvihari`, SUM(CASE WHEN `birth_date` IS NOT NULL AND `birth_date` != '' AND `birth_date` != '0' THEN 1 ELSE 0 END) AS `birth_date`, SUM(CASE WHEN `birth_place` IS NOT NULL AND `birth_place` != '' AND `birth_place` != '0' THEN 1 ELSE 0 END) AS `birth_place`, SUM(CASE WHEN `diksha_date` IS NOT NULL AND `diksha_date` != '' AND `diksha_date` != '0' THEN 1 ELSE 0 END) AS `diksha_date`, SUM(CASE WHEN `sallekhna_place` IS NOT NULL AND `sallekhna_place` != '' AND `sallekhna_place` != '0' THEN 1 ELSE 0 END) AS `sallekhna_place`, SUM(CASE WHEN `url` IS NOT NULL AND `url` != '' AND `url` != '0' THEN 1 ELSE 0 END) AS `url`, SUM(CASE WHEN `sorting_order_no1` IS NOT NULL AND `sorting_order_no1` != '' AND `sorting_order_no1` != '0' THEN 1 ELSE 0 END) AS `sorting_order_no1`, SUM(CASE WHEN `sorting_order_no2` IS NOT NULL AND `sorting_order_no2` != '' AND `sorting_order_no2` != '0' THEN 1 ELSE 0 END) AS `sorting_order_no2`, SUM(CASE WHEN `diksha_guru` IS NOT NULL AND `diksha_guru` != '' AND `diksha_guru` != '0' THEN 1 ELSE 0 END) AS `diksha_guru`, SUM(CASE WHEN `lineage` IS NOT NULL AND `lineage` != '' AND `lineage` != '0' THEN 1 ELSE 0 END) AS `lineage`, SUM(CASE WHEN `status` IS NOT NULL AND `status` != '' AND `status` != '0' THEN 1 ELSE 0 END) AS `status`, SUM(CASE WHEN `category` IS NOT NULL AND `category` != '' AND `category` != '0' THEN 1 ELSE 0 END) AS `category`, SUM(CASE WHEN `category_fut_num_1` IS NOT NULL AND `category_fut_num_1` != '' AND `category_fut_num_1` != '0' THEN 1 ELSE 0 END) AS `category_fut_num_1`, SUM(CASE WHEN `category_fut_num_2` IS NOT NULL AND `category_fut_num_2` != '' AND `category_fut_num_2` != '0' THEN 1 ELSE 0 END) AS `category_fut_num_2`, SUM(CASE WHEN `category_fut_num_3` IS NOT NULL AND `category_fut_num_3` != '' AND `category_fut_num_3` != '0' THEN 1 ELSE 0 END) AS `category_fut_num_3`, SUM(CASE WHEN `quick_reference` IS NOT NULL AND `quick_reference` != '' AND `quick_reference` != '0' THEN 1 ELSE 0 END) AS `quick_reference`, SUM(CASE WHEN `honorific_prefix` IS NOT NULL AND `honorific_prefix` != '' AND `honorific_prefix` != '0' THEN 1 ELSE 0 END) AS `honorific_prefix`, SUM(CASE WHEN `namebefore_diksha` IS NOT NULL AND `namebefore_diksha` != '' AND `namebefore_diksha` != '0' THEN 1 ELSE 0 END) AS `namebefore_diksha`, SUM(CASE WHEN `birth_date_indian_format` IS NOT NULL AND `birth_date_indian_format` != '' AND `birth_date_indian_format` != '0' THEN 1 ELSE 0 END) AS `birth_date_indian_format`, SUM(CASE WHEN `mothers_name` IS NOT NULL AND `mothers_name` != '' AND `mothers_name` != '0' THEN 1 ELSE 0 END) AS `mothers_name`, SUM(CASE WHEN `fathers_name` IS NOT NULL AND `fathers_name` != '' AND `fathers_name` != '0' THEN 1 ELSE 0 END) AS `fathers_name`, SUM(CASE WHEN `bramhacharya_vrat` IS NOT NULL AND `bramhacharya_vrat` != '' AND `bramhacharya_vrat` != '0' THEN 1 ELSE 0 END) AS `bramhacharya_vrat`, SUM(CASE WHEN `bramhacharya_vrat_guru` IS NOT NULL AND `bramhacharya_vrat_guru` != '' AND `bramhacharya_vrat_guru` != '0' THEN 1 ELSE 0 END) AS `bramhacharya_vrat_guru`, SUM(CASE WHEN `bramcharya_vrat_place` IS NOT NULL AND `bramcharya_vrat_place` != '' AND `bramcharya_vrat_place` != '0' THEN 1 ELSE 0 END) AS `bramcharya_vrat_place`, SUM(CASE WHEN `kshullak_diksha_date` IS NOT NULL AND `kshullak_diksha_date` != '' AND `kshullak_diksha_date` != '0' THEN 1 ELSE 0 END) AS `kshullak_diksha_date`, SUM(CASE WHEN `kshullak_diksha_place` IS NOT NULL AND `kshullak_diksha_place` != '' AND `kshullak_diksha_place` != '0' THEN 1 ELSE 0 END) AS `kshullak_diksha_place`, SUM(CASE WHEN `kshullak_diksha_guru` IS NOT NULL AND `kshullak_diksha_guru` != '' AND `kshullak_diksha_guru` != '0' THEN 1 ELSE 0 END) AS `kshullak_diksha_guru`, SUM(CASE WHEN `kshullika_diksha_date` IS NOT NULL AND `kshullika_diksha_date` != '' AND `kshullika_diksha_date` != '0' THEN 1 ELSE 0 END) AS `kshullika_diksha_date`, SUM(CASE WHEN `kshullika_diksha_place` IS NOT NULL AND `kshullika_diksha_place` != '' AND `kshullika_diksha_place` != '0' THEN 1 ELSE 0 END) AS `kshullika_diksha_place`, SUM(CASE WHEN `kshullika_diksha_guru` IS NOT NULL AND `kshullika_diksha_guru` != '' AND `kshullika_diksha_guru` != '0' THEN 1 ELSE 0 END) AS `kshullika_diksha_guru`, SUM(CASE WHEN `ailak_diksha_date` IS NOT NULL AND `ailak_diksha_date` != '' AND `ailak_diksha_date` != '0' THEN 1 ELSE 0 END) AS `ailak_diksha_date`, SUM(CASE WHEN `ailak_diksha_place` IS NOT NULL AND `ailak_diksha_place` != '' AND `ailak_diksha_place` != '0' THEN 1 ELSE 0 END) AS `ailak_diksha_place`, SUM(CASE WHEN `ailak_diksha_guru` IS NOT NULL AND `ailak_diksha_guru` != '' AND `ailak_diksha_guru` != '0' THEN 1 ELSE 0 END) AS `ailak_diksha_guru`, SUM(CASE WHEN `diksha_date_tithi_indian_format` IS NOT NULL AND `diksha_date_tithi_indian_format` != '' AND `diksha_date_tithi_indian_format` != '0' THEN 1 ELSE 0 END) AS `diksha_date_tithi_indian_format`, SUM(CASE WHEN `muni_diksha_place` IS NOT NULL AND `muni_diksha_place` != '' AND `muni_diksha_place` != '0' THEN 1 ELSE 0 END) AS `muni_diksha_place`, SUM(CASE WHEN `muni_diksha_guru` IS NOT NULL AND `muni_diksha_guru` != '' AND `muni_diksha_guru` != '0' THEN 1 ELSE 0 END) AS `muni_diksha_guru`, SUM(CASE WHEN `aryika_diksha_date` IS NOT NULL AND `aryika_diksha_date` != '' AND `aryika_diksha_date` != '0' THEN 1 ELSE 0 END) AS `aryika_diksha_date`, SUM(CASE WHEN `aryika_diksha_guru` IS NOT NULL AND `aryika_diksha_guru` != '' AND `aryika_diksha_guru` != '0' THEN 1 ELSE 0 END) AS `aryika_diksha_guru`, SUM(CASE WHEN `aryika_diksha_place` IS NOT NULL AND `aryika_diksha_place` != '' AND `aryika_diksha_place` != '0' THEN 1 ELSE 0 END) AS `aryika_diksha_place`, SUM(CASE WHEN `upadhyay_diksha_date` IS NOT NULL AND `upadhyay_diksha_date` != '' AND `upadhyay_diksha_date` != '0' THEN 1 ELSE 0 END) AS `upadhyay_diksha_date`, SUM(CASE WHEN `upadhyay_diksha_place` IS NOT NULL AND `upadhyay_diksha_place` != '' AND `upadhyay_diksha_place` != '0' THEN 1 ELSE 0 END) AS `upadhyay_diksha_place`, SUM(CASE WHEN `upadhyay_diksha_guru` IS NOT NULL AND `upadhyay_diksha_guru` != '' AND `upadhyay_diksha_guru` != '0' THEN 1 ELSE 0 END) AS `upadhyay_diksha_guru`, SUM(CASE WHEN `elacharya_pad_date` IS NOT NULL AND `elacharya_pad_date` != '' AND `elacharya_pad_date` != '0' THEN 1 ELSE 0 END) AS `elacharya_pad_date`, SUM(CASE WHEN `elacharya_pad_place` IS NOT NULL AND `elacharya_pad_place` != '' AND `elacharya_pad_place` != '0' THEN 1 ELSE 0 END) AS `elacharya_pad_place`, SUM(CASE WHEN `elacharya_pad_pradata` IS NOT NULL AND `elacharya_pad_pradata` != '' AND `elacharya_pad_pradata` != '0' THEN 1 ELSE 0 END) AS `elacharya_pad_pradata`, SUM(CASE WHEN `acharya_pad_date` IS NOT NULL AND `acharya_pad_date` != '' AND `acharya_pad_date` != '0' THEN 1 ELSE 0 END) AS `acharya_pad_date`, SUM(CASE WHEN `acharya_pad_place` IS NOT NULL AND `acharya_pad_place` != '' AND `acharya_pad_place` != '0' THEN 1 ELSE 0 END) AS `acharya_pad_place`, SUM(CASE WHEN `acharya_pad_pradata` IS NOT NULL AND `acharya_pad_pradata` != '' AND `acharya_pad_pradata` != '0' THEN 1 ELSE 0 END) AS `acharya_pad_pradata`, SUM(CASE WHEN `salekhena` IS NOT NULL AND `salekhena` != '' AND `salekhena` != '0' THEN 1 ELSE 0 END) AS `salekhena`, SUM(CASE WHEN `sallekhna_place_ext` IS NOT NULL AND `sallekhna_place_ext` != '' AND `sallekhna_place_ext` != '0' THEN 1 ELSE 0 END) AS `sallekhna_place_ext`, SUM(CASE WHEN `related_family_member_who_took_initiation` IS NOT NULL AND `related_family_member_who_took_initiation` != '' AND `related_family_member_who_took_initiation` != '0' THEN 1 ELSE 0 END) AS `related_family_member_who_took_initiation`, SUM(CASE WHEN `rep_muni_aryika_diksha_guru` IS NOT NULL AND `rep_muni_aryika_diksha_guru` != '' AND `rep_muni_aryika_diksha_guru` != '0' THEN 1 ELSE 0 END) AS `rep_muni_aryika_diksha_guru`, SUM(CASE WHEN `nohashkey` IS NOT NULL AND `nohashkey` != '' AND `nohashkey` != '0' THEN 1 ELSE 0 END) AS `nohashkey`, SUM(CASE WHEN `sangh_nayak` IS NOT NULL AND `sangh_nayak` != '' AND `sangh_nayak` != '0' THEN 1 ELSE 0 END) AS `sangh_nayak`, SUM(CASE WHEN `sorting_order_no2_ext` IS NOT NULL AND `sorting_order_no2_ext` != '' AND `sorting_order_no2_ext` != '0' THEN 1 ELSE 0 END) AS `sorting_order_no2_ext` FROM wp_guru_master

Completeness of all 66 columns — how many records have a non-empty value.

guru_id
0%
status_id
0%
category_id
0%
job_title
0%
guru_name
0%
guru_name_hindi
0%
hashtag
0%
guru_hash
0%
group_hash
0%
vihar_group_key
0%
senriority_no
0%
djw_id
0%
saghnayak
0%
ekalvihari
0%
birth_date
0%
birth_place
0%
diksha_date
0%
sallekhna_place
0%
url
0%
sorting_order_no1
0%
sorting_order_no2
0%
diksha_guru
0%
lineage
0%
status
0%
category
0%
category_fut_num_1
0%
category_fut_num_2
0%
category_fut_num_3
0%
quick_reference
0%
honorific_prefix
0%
namebefore_diksha
0%
birth_date_indian_format
0%
mothers_name
0%
fathers_name
0%
bramhacharya_vrat
0%
bramhacharya_vrat_guru
0%
bramcharya_vrat_place
0%
kshullak_diksha_date
0%
kshullak_diksha_place
0%
kshullak_diksha_guru
0%
kshullika_diksha_date
0%
kshullika_diksha_place
0%
kshullika_diksha_guru
0%
ailak_diksha_date
0%
ailak_diksha_place
0%
ailak_diksha_guru
0%
diksha_date_tithi_indian_format
0%
muni_diksha_place
0%
muni_diksha_guru
0%
aryika_diksha_date
0%
aryika_diksha_guru
0%
aryika_diksha_place
0%
upadhyay_diksha_date
0%
upadhyay_diksha_place
0%
upadhyay_diksha_guru
0%
elacharya_pad_date
0%
elacharya_pad_place
0%
elacharya_pad_pradata
0%
acharya_pad_date
0%
acharya_pad_place
0%
acharya_pad_pradata
0%
salekhena
0%
sallekhna_place_ext
0%
related_family_member_who_took_initiation
0%
rep_muni_aryika_diksha_guru
0%
nohashkey
0%
sangh_nayak
0%
sorting_order_no2_ext
0%