
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.