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=10919 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

69°
20°
°F | °C
Fair
Humidity: 35%
Sat
Sunny
47 | 73
8 | 22
Sun
Mostly Sunny
52 | 78
11 | 25