SELECT DISTINCT a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid, u.name as user FROM #__adsmanager_ads as a LEFT JOIN #__adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN #__users as u ON a.userid = u.id LEFT JOIN #__adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN #__adsmanager_categories as p ON c.parent = p.id WHERE a.id=9634 and c.published LIMIT 1
Ads arrow

$row->ad_headline

$row->ad_text
Price: $row->ad_price
Contact:
$row->ad_phone
nopic

This is National Public Safety Telecommunications Week- Today we are patting on the back the “Unseen First Responders”. Beverly Harbison and employees- Julie Greer, April Dunbar, Dennis Hatcher, Laura Lee Williams, Amy Houchin, Colleen Hamilton, Schelly Vance, Pan Lyons, Jim Spears, Lisa Shirley, Teresa Bull, Alison Burton, Matthew Vaughn, Bill Ekhardt, Bill Shoopman, Kathy Tyree, Joe Perry, Joann Eaton.

WCLU Weather

51°
10°
°F | °C
Fair
Humidity: 79%
Fri
Partly Cloudy
46 | 67
7 | 19
Sat
Sunny
45 | 73
7 | 22