$ =
select * from states where statePub = 1
$sql =
select * from eagle_testimonials
where tesPub = 1
order by tesDate DESC
limit 0, 6
$ =
select cc.catID, cc.catName, cc.catDesc, cc.catIcon, cc.catLive, cc.catParent, count(p2c.prodID) as productCount
from catalog_categories cc
left join catalog_prod2cat p2c
on p2c.catID = cc.catID
where cc.catPub = 1
group by cc.catID
order by cc.catName
$header =