(mysqlt): select p1.cID, pt.ctHandle from Pages p1 left join Pages p2 on (p1.cPointerID = p2.cID) left join PagePaths on (PagePaths.cID = p1.cID and PagePaths.ppIsCanonical = 1) left join PageSearchIndex psi on (psi.cID = if(p2.cID is null, p1.cID, p2.cID)) inner join CollectionVersions cv on (cv.cID = if(p2.cID is null, p1.cID, p2.cID) and cvID = (select cvID from CollectionVersions where cvIsApproved = 1 and cID = cv.cID)) left join PageTypes pt on pt.ctID = cv.ctID inner join Collections c on (c.cID = if(p2.cID is null, p1.cID, p2.cID)) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = if (p2.cID is null, p1.cID, p2.cID)) where 1=1 and (ak_pebble_authorName LIKE '%voodooman%') and (p1.cID!='128') and cvName != '' and pt.ctID = '10' and (ak_exclude_page_list = 0 OR ak_exclude_page_list is null) and PagePaths.cPath like '/apps/%' and PagePaths.ppIsCanonical = '1' and cvIsApproved = '1' and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and ((select count(cID) from PagePermissionAssignments ppa1 inner join PermissionAccessList pa1 on ppa1.paID = pa1.paID where ppa1.cID = if(p2.cID is null, p1.cInheritPermissionsFromCID, p2.cInheritPermissionsFromCID) and pa1.accessType = 10 and pa1.pdID in (0)
and pa1.peID in (2) and (if(pa1.peID = 4 and p1.uID <>0, false, true)) and (ppa1.pkID = 1 and cv.cvIsApproved = 1)) > 0
or (p1.cPointerExternalLink !='' AND p1.cPointerExternalLink IS NOT NULL)) and ((select count(cID) from PagePermissionAssignments ppaExclude inner join PermissionAccessList paExclude on ppaExclude.paID = paExclude.paID where ppaExclude.cID = if(p2.cID is null, p1.cInheritPermissionsFromCID, p2.cInheritPermissionsFromCID) and accessType = -1 and pdID in (0)
and paExclude.peID in (2) and (if(paExclude.peID = 4 and p1.uID <>0, false, true)) and (ppaExclude.pkID = 1 and cv.cvIsApproved = 1)) = 0) and ak_pebble_flag = '0' and ak_pebble_subApp = '0' and p1.cIsActive = '1' order by ak_pebble_dateAdded desc limit 0,56
-
Description
Akira is a Japanese manga series, written and illustrated by Katsuhiro Otomo.
created by - voodooman
-
Description
Akira is a Japanese manga series, written and illustrated by Katsuhiro Otomo.
This bike is the one of great design from this manga.
created by - voodooman
-
Description
AKIRA is a Japanese manga series, written and illustrated by Katsuhiro Otomo.
created by - voodooman
-
-
-
-
Description
Battlezone is an arcade game from Atari released in November 1980.
It displays a wireframe view (using vector graphics rather than raster graphics) on a horizontal black and white (with green and red sectioned color overlay) vector monitor.
I wish it could move like real....
I do not have that skill yet....
created by - voodooman
-
Description
Karateka is old game which released to Apple II by Jordan Mecher in 1984.
This face is 1st approaching scene of the game.
Update History :
1.1
refine background art
release other clock type.
Digital clock + date (BLACK)
Digital clock + date (WHITE)
Digital clock no date (BLACK)
Digital clock no date (WHITE)
Digital clock with seconds (BLACK)
Digital clock with seconds (WHITE)
1.0
1st release
created by - voodooman
-
Description
Karateka is old game which released to Apple II by Jordan Mecher in 1984.
This face is 1st approaching scene of the game.
Update History :
1.1
refine background art
release other clock type.
Digital clock + date (BLACK)
Digital clock + date (WHITE)
Digital clock no date (BLACK)
Digital clock no date (WHITE)
Digital clock with seconds (BLACK)
Digital clock with seconds (WHITE)
1.0
1st release
created by - voodooman
-
Description
Karateka is old game which released to Apple II by Jordan Mecher in 1984.
This face is 1st approaching scene of the game.
Update History :
1.1
refine background art
release other clock type.
Digital clock + date (BLACK)
Digital clock + date (WHITE)
Digital clock no date (BLACK)
Digital clock no date (WHITE)
Digital clock with seconds (BLACK)
Digital clock with seconds (WHITE)
1.0
1st release
created by - voodooman
-
Description
Karateka is old game which released to Apple II by Jordan Mecher in 1984.
This face is 1st approaching scene of the game.
Update History :
1.1
refine background art
release other clock type.
Digital clock + date (BLACK)
Digital clock + date (WHITE)
Digital clock no date (BLACK)
Digital clock no date (WHITE)
Digital clock with seconds (BLACK)
Digital clock with seconds (WHITE)
1.0
1st release
created by - voodooman
-
Description
Karateka is old game which released to Apple II by Jordan Mecher in 1984.
This face is 1st approaching scene of the game.
Update History :
1.1
refine background art
release other clock type.
Digital clock + date (BLACK)
Digital clock + date (WHITE)
Digital clock no date (BLACK)
Digital clock no date (WHITE)
Digital clock with seconds (BLACK)
Digital clock with seconds (WHITE)
1.0
1st release
created by - voodooman
-
Description
The Laughing Man (įŽãį· Warai Otoko) is a fictional character in the animated series " Ghost in the Shell: Stand Alone Complex ".
created by - voodooman
-
Description
This is NES game called "Spelunker" in 1985.
The original game is from Atari 8bit computer.
This hero is one of the weakest hero ever in the game history.
created by - voodooman
-
Description
Karateka is old game which released to Apple II by Jordan Mecher in 1984.
This face is 1st approaching scene of the game.
created by - voodooman
-
Description
This design is inspired from the NES game "Dragon Quest I" in 1986.
Due to limitation of the screen size and color, I left out some of its detail.
I used Web watch face generator from " http://www.watchface-generator.de/ "
I wish I could change the font where indicate Time and Date.
created by - voodooman
-
Description
SYD MEAD is one of my favorite product designer as known as the designer of Policespinner from the film BLADE RUNNER.
I respet his work.
http://goo.gl/KkGjjc
My friend also respect his work and produce his 40th Anniv. watch called "SYD MEAD WATCH : PROMISE" by UT DESIGN.
http://goo.gl/Kibh8C
This watch face is inspired from UT DESIGN watch.
I will delete this watch face If this design against the law of their copyright matter.
created by - voodooman
-