SELECT *
FROM `tk_tenders`
LEFT JOIN `tk_tendernotice` ON `tk_tenders`.`notice_type` = `tk_tendernotice`.`tender_notice_code`
WHERE `site_tender_id` = '526846514'Rows: 1<pre>Array
(
    [0] => stdClass Object
        (
            [posting_id] => 93714500
            [site_tender_id] => 526846514
            [date_c] => 2025-12-30
            [maj_org] => Indian Army
            [add1] => Gem Tender
            [add2] => 
            [city] => Udhampur
            [state] => Jammu-kashmir
            [pincode] => 
            [country] => IN
            [Region] => 030035617,030435617,030735617,090035617
            [email_id] => 
            [url] => https://bidplus.gem.gov.in/all-bids
            [tel] => 
            [fax] => 
            [contact_person] => 
            [tender_notice_no] => GEM/2025/B/7049153 ID: GEM/2025/B/7049153
            [short_desc] => Tender Invited For Remote , Water Bottle , Call Bell , Combination Bd 2x3 Ft , Sprink Light , Red Raxine , Black Raxine , Single Bed Sheet , Pillow Cover , Momento For Troops , Louds Speaker , Trolley For Inverter , Vga To Hdmi Connector , Flex Bd 2x3 Wit
            [tenders_details] => Tenders are invited for Tender Invited For Remote , Water Bottle , Call bell , Combination bd 2x3 ft , Sprink Light , Red Raxine , Black Raxine , Single Bed sheet , Pillow cover , Momento for troops , Louds Speaker , Trolley for Inverter , VGA to HDMI Connector , Flex bd 2x3 with frame , Capet 5x7 , Rope normal , Imerson Rod , Tripod stand , wire 1mm , Bamboo , Led light for trolley , Grass cutting machine repair , Room freshner , Fevicol##Quantity: 91##

Tender Category : Goods

OpeningDate : Jan  9 2026 12:00AM

Doc Sale To : Jan  1 1900 12:00AM

QTY : 91.00

            [corregendum_details] => 
            [est_cost] => 0
            [currency] => 
            [PrjStatus] => 
            [project_name] => 
            [FundingAgency] => 
            [doc_last] => 2026-01-09
            [OriTenderLink] => 
            [source] => Company Web Site
            [quantity] => 
            [tender_doc_file] => <atarget="_blank"href="http://203.199.93.185/scanned1/Dec2025/zip/91324577.zip,Dec2025/zip/91324577_TD_212_TAyz.pdf,Dec2025/zip/91324577_TD_317_XVKc.csv,Dec2025/zip/91324577_TD_534_WOKs.pdf
            [notice_type] => 1
            [global] => 0
            [mfa] => 0
            [TValue] => 1
            [cpv] => 02200000,17212400,17240000,17241000,17241100,17241110,18425000,18512100,19100000,19120000,19140000,19141000,19142000,19143000,19144000,24300000,24340000,24341000,24521000,24621200,25221400,26131000,26211000,26211400,26212000,27331100,29300000,29310000,29313400,29332100,29332200,29332600,29815120,31155000,31224000,31311000,31521000,31670000,32321200,35411000,36121164,36147200,36441000,36535292,40121300,45262400
            [tender_sector] => 01,02,0204,0206,0207,0210,0211,0215,10,17,19,1929,2101,211,4
            [authorize] => 1
            [ed_choice] => 
            [entrydt] => 2025-12-29 22:02:34
            [entryby] => TT
            [s_id] => 1
            [tender_notice_code] => 1
            [tender_notice] => Tender Notice
            [show_on] => Y
        )

)