Outdoor Park Campfire Grills from Webcoat - AAA Park It Outdoors
Our park
campfire grill from Webcoat is
a generic grill that gets the
job done. This compact grill
is great for small parks and
neighborhoods. The unit
features high temperature
paint and an adjustable
cooking grate, requirements
for a commercial grade outdoor
grill. Cookouts are an
essential part of the park
experience and will bring
families and friends together
at your facilities. Other park
grills and fire rings are
available from Ultra Play
Systems, Inc.
select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, MIN(pd.products_price) AS `price` from products pd
inner join products_to_categories pc on pd.products_id=pc.products_id
inner join categories_description cd on cd.categories_id=c.categories_id
inner join categories c on c.categories_id=pc.categories_id
where c.parent_id=166
and cd.language_id=1
group by pc.categories_id
order by c.sort_order, cd.categories_nameUnknown column 'c.categories_id' in 'on clause'
