Outdoor Ashtray, Cigarette Receptacle for Smokers - AAA Park It Outdoors
Our outdoor
ashtray, also known as a
cigarette receptacle comes in
several colors and steel
types. Each outdoor ashtray
provides a stand-alone
cigarette receptacle. Smokers
receptacles are meant to be
discreet, while keeping the
park clean. Although smoking
is often referred as a
dangerous and destructive
habit, this safe and clean
disposal system is offered.
Ash Urn attachments are
available for trash
receptacles and combine two
uses. These units can be
surface mounted to existing
concrete or in ground.
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=9
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'
