SELECT *
FROM `tk_tenders`
LEFT JOIN `tk_tendernotice` ON `tk_tenders`.`notice_type` = `tk_tendernotice`.`tender_notice_code`
WHERE `site_tender_id` = '526846528'Rows: 1<pre>Array
(
    [0] => stdClass Object
        (
            [posting_id] => 93715961
            [site_tender_id] => 526846528
            [date_c] => 2025-12-30
            [maj_org] => International Advanced Research Centre For Powder Metallurgy And New Materials
            [add1] => Gem Tender
            [add2] => 
            [city] => Ranga Reddy 
            [state] => Telangana
            [pincode] => 
            [country] => IN
            [Region] => 030035640,030435640,030735640,090035640
            [email_id] => 
            [url] => https://bidplus.gem.gov.in/all-bids
            [tel] => 
            [fax] => 
            [contact_person] => 
            [tender_notice_no] => GEM/2025/B/6877151 <br> GEM/2025/R/598418 ID: GEM/2025/B/6877151 <br> GEM/2025/R/598418
            [short_desc] => Tender Invited For Design, Fabrication And Supply Of Discharging Assembly Set Up For Thermal Energy Storage Prototype##quantity: 1##
            [tenders_details] => Tenders are invited for Tender Invited For Design, Fabrication and Supply of discharging Assembly Set up for Thermal Energy Storage Prototype##Quantity: 1##

Tender Category : Goods

OpeningDate : Dec 31 2025 12:00AM

Doc Sale To : Jan  1 1900 12:00AM

QTY : 1.00

            [corregendum_details] => 
            [est_cost] => 0
            [currency] => 
            [PrjStatus] => 
            [project_name] => 
            [FundingAgency] => 
            [doc_last] => 2025-12-31
            [OriTenderLink] => 
            [source] => Company Web Site
            [quantity] => 
            [tender_doc_file] => <atarget="_blank"href="http://203.199.93.185/scanned1/Dec2025/zip/91326038.zip,Dec2025/zip/91326038_TD_188_URq3.pdf,Dec2025/zip/91326038_TD_222_Dr2J.pdf
            [notice_type] => 1
            [global] => 0
            [mfa] => 0
            [TValue] => 1
            [cpv] => 31670000,33290000,45351000
            [tender_sector] => 19,47,8
            [authorize] => 1
            [ed_choice] => 
            [entrydt] => 2025-12-29 23:23:38
            [entryby] => TT
            [s_id] => 1
            [tender_notice_code] => 1
            [tender_notice] => Tender Notice
            [show_on] => Y
        )

)