SELECT *
FROM `tk_tenders`
LEFT JOIN `tk_tendernotice` ON `tk_tenders`.`notice_type` = `tk_tendernotice`.`tender_notice_code`
WHERE `site_tender_id` = '526846554'Rows: 1<pre>Array
(
    [0] => stdClass Object
        (
            [posting_id] => 93715541
            [site_tender_id] => 526846554
            [date_c] => 2025-12-30
            [maj_org] => Zilla Parishad
            [add1] => Zilla Parishad||zilla Parishad||bankura||shaltora<br>saltora<br>pincode 722158
            [add2] => 
            [city] => Bankura
            [state] => West Bengal
            [pincode] => 
            [country] => IN
            [Region] => 030035637,030435637,030735637,090035637
            [email_id] => 
            [url] => 
            [tel] => 
            [fax] => 
            [contact_person] => 
            [tender_notice_no] => 2025_ZPHD_980360_1 ID: 2025_ZPHD_980360_1
            [short_desc] => Upgradation Of Existing Old Internal Electrical Installation Work And Balancing Of Power Distribution System To Different Offices Within Saltora Panchayat Samiti During The F.y 2025-26.
            [tenders_details] => Tenders are invited for Upgradation of existing old Internal Electrical Installation work and balancing of power distribution system to different offices within Saltora Panchayat Samiti during the F.Y 2025-26.

Doc Fees : INR 1000.00

Tender Category : Works

Earnest Money : INR 18400.00

OpeningDate : Jan 19 2026 12:00AM

EMD value :       18400

            [corregendum_details] => 
            [est_cost] => 917667
            [currency] => INR
            [PrjStatus] => 
            [project_name] => 
            [FundingAgency] => 
            [doc_last] => 2026-01-15
            [OriTenderLink] => 
            [source] => Company Web Site
            [quantity] => 
            [tender_doc_file] => Dec2025/zip/91325618.zip,Dec2025/zip/91325618_TD_693_Q5IL.zip,Dec2025/zip/91325618_TD_843_Snyi.pdf
            [notice_type] => 1
            [global] => 0
            [mfa] => 0
            [TValue] => 1
            [cpv] => 31214510,45310000,45317000,65320000
            [tender_sector] => 19,47
            [authorize] => 1
            [ed_choice] => 
            [entrydt] => 2025-12-29 23:04:27
            [entryby] => TT
            [s_id] => 1
            [tender_notice_code] => 1
            [tender_notice] => Tender Notice
            [show_on] => Y
        )

)