SELECT *
FROM `tk_tenders`
RIGHT JOIN `tk_tendernotice` ON `tk_tenders`.`notice_type` = `tk_tendernotice`.`tender_notice_code`
WHERE `site_tender_id` = '526846508'Rows: 1<pre>Array
(
    [0] => stdClass Object
        (
            [posting_id] => 93715959
            [site_tender_id] => 526846508
            [date_c] => 2025-12-30
            [maj_org] => Indian Air Force
            [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/6923633 <br> GEM/2025/R/598062 ID: GEM/2025/B/6923633 <br> GEM/2025/R/598062
            [short_desc] => Tender Invited For Working Model Of Instrument Landing System##quantity: 1##
            [tenders_details] => Tenders are invited for Tender Invited For Working Model of Instrument Landing System##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/91326036.zip,Dec2025/zip/91326036_TD_145_ZLRv.pdf,Dec2025/zip/91326036_TD_179_Cq12.pdf,Dec2025/zip/91326036_TD_193_TBlq.pdf,Dec2025/zip/91326036_TD_505_GgGU.pdf
            [notice_type] => 1
            [global] => 0
            [mfa] => 0
            [TValue] => 1
            [cpv] => 29815000,31216000,35332000,35333000,35350000,38224000,38224100
            [tender_sector] => 1802,19,2101
            [authorize] => 1
            [ed_choice] => 
            [entrydt] => 2025-12-29 23:23:34
            [entryby] => TT
            [s_id] => 1
            [tender_notice_code] => 1
            [tender_notice] => Tender Notice
            [show_on] => Y
        )

)