Query: SELECT child.id, child.parent_id, parent.lft, child.title, child.title as childTitle , parent.title as parentTitle, gdparent.title as gdParentTitle FROM categories as child LEFT JOIN categories as parent ON child.parent_id = parent.id LEFT JOIN categories as gdparent ON parent.parent_id = gdparent.id WHERE child.id = ORDER BY child.parent_id, parent.lft

New entertainer sw • Clown Leisure - Entertainers in Herts, Essex and Nationwide.
Clown Leisure
Tell us what you're looking for.....
24hrs 7days a week
Please enter your name


Receive offers and get the latest news


New entertainer sw

lorem lorem


Childrens, Clowns
Magicians, Puppets,
Face Painters
and much more


We offer some
Unique and inspiring
Workshops for
All ages.

Products & Services

Everything you need to
make your special day

Themed Parties

We offer some truly
amazing themes for boys
and girls of all ages