SELECT *
FROM `tk_tenders`
LEFT JOIN `tk_tendernotice` ON `tk_tenders`.`notice_type` = `tk_tendernotice`.`tender_notice_code`
WHERE `site_tender_id` = '526846546'Rows: 1<pre>Array
(
    [0] => stdClass Object
        (
            [posting_id] => 93716383
            [site_tender_id] => 526846546
            [date_c] => 2025-12-30
            [maj_org] => Airports Authority Of India
            [add1] => Gem Tender
            [add2] => 
            [city] => Patna
            [state] => Bihar
            [pincode] => 
            [country] => IN
            [Region] => 030035605,030435605,030735605,090035605
            [email_id] => 
            [url] => https://bidplus.gem.gov.in/all-bids
            [tel] => 
            [fax] => 
            [contact_person] => 
            [tender_notice_no] => GEM/2025/B/7053829 ID: GEM/2025/B/7053829
            [short_desc] => Tender Invited For Supply Of Bi-pin Halogen Lamp 200w, 6.6a Suitable For Hirl Fittings , Supply Of Suitable Led Light For Elevated Led Taxiway Edge Light Fixture , Supply Of Lamp Ema Make Airport Rotating Beacon Light Ab 4000 , Supply Of Aluminium Reflect
            [tenders_details] => Tenders are invited for Tender Invited For Supply of Bi-pin halogen lamp 200W, 6.6A suitable for HIRL fittings , Supply of suitable LED light for elevated LED Taxiway Edge light fixture , Supply of lamp Ema make Airport Rotating beacon light AB 4000 , Supply of Aluminium reflector suitable for existing AMA make PAPI Unit , Supply of Papi reflector suitable for existing Vardhman make PAPI unit##Quantity: 679##

Tender Category : Goods

Earnest Money :  17855.00

OpeningDate : Jan 19 2026 12:00AM

Doc Sale To : Jan  1 1900 12:00AM

QTY : 679.00

EMD value :       17855

            [corregendum_details] => 
            [est_cost] => 595175
            [currency] => 
            [PrjStatus] => 
            [project_name] => 
            [FundingAgency] => 
            [doc_last] => 2026-01-19
            [OriTenderLink] => 
            [source] => Company Web Site
            [quantity] => 
            [tender_doc_file] => <atarget="_blank"href="http://203.199.93.185/scanned1/Dec2025/zip/91326460.zip,Dec2025/zip/91326460_TD_190_GWiU.pdf,Dec2025/zip/91326460_TD_534_GA9F.pdf,Dec2025/zip/91326460_TD_812_Reus.csv,Dec2025/zip/91326460_TD_922_IPg4.docx
            [notice_type] => 1
            [global] => 0
            [mfa] => 0
            [TValue] => 1
            [cpv] => 31521000
            [tender_sector] => 19
            [authorize] => 1
            [ed_choice] => 
            [entrydt] => 2025-12-29 23:57:36
            [entryby] => TT
            [s_id] => 1
            [tender_notice_code] => 1
            [tender_notice] => Tender Notice
            [show_on] => Y
        )

)