×

Error

Got error -1 from storage engine SQL=SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM wl5z3_content AS a LEFT JOIN wl5z3_categories AS c ON c.id = a.catid LEFT JOIN wl5z3_users AS ua ON ua.id = a.created_by LEFT JOIN wl5z3_users AS uam ON uam.id = a.modified_by LEFT JOIN wl5z3_categories as parent ON parent.id = c.parent_id LEFT JOIN wl5z3_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM wl5z3_categories AS cat JOIN wl5z3_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN wl5z3_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-09-20 13:56:55') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-09-20 13:56:55') ORDER BY c.lft, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC LIMIT 0, 9

Hello!
My name
is John

I'm multidisciplined freelance designer specialise in rich interactive experiences for web. If you’ve got an exciting project, get in touch with me!

Scroll Down John S.

Check
out my
hot
works

  • All
  • Print Design
  • Photos
  • UI/UX
Batter Home BakeryIsland Grown Schools IdentityYour Local IdentityPredators IllustrationC2C - Tetra packAbstract Geometric BackgroundsFREE Logo Mock up!Future ArtifactsPeek CalendarMagazine CoversFree Moto 360 MockupBorg Typeface (FREE)

Didn't
you
know?!

I'm award winning desiger. It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.

Prize

HTML Inspiration

Featured Site + #1 Best of the best

Prize

French Design Index

Featured Site + #1 Best of the best

Prize

Awwwards

Featured Site + #1 Best of the best

Prize

The FWA

Featured Site + #1 Best of the best

  • I do my
    clients

  • Client
  • Client
  • Client
  • Client
  • Client
  • Client
  • Client
  • Client
  • Client
  • Client

My
loyal
team

Team member

John Hammond

CEO, Creative Director
Team member

Dennis Hawkings

Lead Developer
Team member

Tom Weerd

General manager
Team member

John Doe

Webmaster
Team member

John Hammond

CEO, Creative Director
Team member

Dennis Hawkings

Lead Developer
Team member

Tom Weerd

General manager
Team member

John Doe

Webmaster

Don't
hesitate to
contact
me

2130 Broadway #1
New York, NY 10023

Feel free to email me. I would be happy to answer any questions you might have.