sdf-SELECT jos_auction_mgmt.*,jos_departments.* FROM jos_auction_mgmt,jos_departments WHERE auction_date LIKE '2026-%' AND auction_date LIKE '%-04-%' AND auction_date>='2026-04-24' AND web_status != '3' AND archieved != '1' and jos_auction_mgmt.department_id = jos_departments.department_code AND jos_departments.published = 1 ORDER BY auction_date ASC
