Dragonball 2009 the Movie
User Rating: / 0
PoorBest 
Written by Felix the Great!   
Sunday, 27 April 2008

The story begins with a young humanoid boy named Goku, who discovers that he was sent to Earth to blend in and destroy our population but instead elects to protect it from an oncoming alien onslaught bent on dominating the universe and controlling the mystical objects.

This photo has begun to circulate the message boards, claiming to be the Japanese poster for "20th Century Fox’s" upcoming live action big screen adaptation of Dragonball. But who knows, it could be an elaborate fan creation. I know there is enough of a fanbase looking forward to this movie, so I thought I’d share it. The poster translates into:
“Legend becomes reality
March 2009
Dragonball
www.dragonball-movie.jp”

The story begins with a young humanoid boy named Goku, who discovers that he was sent to Earth to blend in and destroy our population but instead elects to protect it from an oncoming alien onslaught bent on dominating the universe and controlling the mystical objects. He seeks out upon his adoptive grandfather Grandpa Gohan's dying request to find the great Master Roshi and gather all seven Dragon Balls. Of which he has one, in order to prevent the evil Lord Piccolo from succeeding in his desire to use the Dragon Balls to take over the world. And Goku's quest is to obtain the mystical Dragonballs before Piccolo does.

[Based on] The King Piccolo Saga [Dragonball], also known as the Piccolo Daimaoh Saga (Demon Lord Piccolo Saga) is the penultimate saga from the anime Dragon Ball. It occurs after the Tien Shinhan Saga and precedes the Piccolo Junior Saga. It includes the battles between Goku and King Piccolo's sons, Goku's first encounter with the Samurai warrior, Yajirobe, Goku's quest to find the Holy Water, his final battle with young King Piccolo, and the birth of Piccolo Junior.

Appearances also made by Yamcha and Bulma but regretably not Bwar or Oolong, nor even Krillin. Ox King and his Daughter Chi Chi are speculated.

Directed by

James Wong    
 

Writing credits

Akira Toriyama   (comic)
Ben Ramsey   adaptation
James Wong   adaptation
James Wong   screenplay

Cast (in credits order)


Justin Chatwin ... Goku

other cast:


Emmy Rossum ... Bulma

James Marsters ... Lord Piccolo

Yun-Fat Chow ... Master Roshi

Jamie Chung ... Chi Chi

Joon Park ... Yamcha

Randall Duk Kim ... Grandpa Gohan

Eriko Tamura ... Mai

Ernie Hudson    

Texas Battle ... Carey Fuller

Luis Arrieta ... Weaver

Shavon Kirksey ... Emi

Richard Blake ... Agundas

Produced by

Stephen Chow .... producer
Jose Ludlow .... line producer
Rich Thorne .... co-producer
Tim Van Rellim .... executive producer
 

Original Music by

Brian Tyler    
 

Cinematography by

Robert McLachlan    
 

Film Editing by

Chris G. Willingham    
 

Casting by

Carla Hool    
 

Production Design by

Richard Holland    
Bruton Jones    
 

Art Direction by

Patricio M. Farrell    
 

Set Decoration by

Roberto Bonelli    
 

Costume Design by

Mayes C. Rubeo    
 

Makeup Department

Gerardo perez Arreola .... hair stylist
Steve Koch .... prosthetic designer and sculptor: Amalgamated Dynamics Inc.
Bart Mixon .... special makeup effects artist
Tom Woodruff Jr. .... creature and makeup effects co-designer
 

Production Management

Adriana Aimo .... unit production manager
Iram Collantes .... unit manager
Ernesto Garabito .... unit manager
Joceline Hernandez .... unit chief manager
Arturo Núñez .... unit production manager: second unit
 

Second Unit Director or Assistant Director

Renan Bendersky .... second assistant director
Paul F. Bernard .... first assistant director
Barbara Jane Cole .... second assistant director: second unit
Mimi Crowe .... second second assistant director
Hiromi Kamata .... second second assistant director
Jaime Rivas .... assistant director
Joaquin Silva .... co-second assistant director
Joaquin Silva .... first assistant director: second unit
Rich Thorne .... second unit director
 

Art Department

Alejandro Ayala .... construction coordinator
David Baker .... sword maker
Francisco Blanc .... set designer
Jesus Carrera .... construction foreman
Daren Dochterman .... concept artist
Hana Espinoza .... set dressing coordinator
Dan Fraga .... storyboard artist
Carlos Gamboa .... assistant art director
Rick Gamez .... propmaker
Laura González .... construction auditor
Michael Kocurek .... construction coordinator
Arturo Lazcano .... head scenic painter
Armando Lopez .... set designer
Armando Patino .... graphic designer
Hugo Santiago .... set designer
Steven M. Saylor .... set designer
Abigail Sheiner .... art coordinator
Joseph Strachan .... storyboard artist
Colin Thurston .... property master
Marco Apolo Torres .... set designer
Sandro Valdez .... set designer
 

Special Effects by

H. Barclay Aaris .... special effects
Jason Barnett .... prosthetic technician: Amalgamated Dynamics Inc.
Michael Broom .... conceptual artist: Amalgamated Dynamics, Inc.
Damian Fisher .... mold maker
Damian Fisher .... special effects technician
Eric Hayden .... creature supervisor
Michael O'Brien .... sculptor: Amalgamated Dynamics Inc.
Joe Pancake .... special effects supervisor
 

Visual Effects by

Ivy Agregan .... visual effects coordinator
Rex Ahn .... pre-visualization lead: Image Engine
Russel Ang .... pre-visualization artist: Image Engine
Ian T. Barbella .... visual effects
Guillermo Dupinet Bours .... junior pre-visualization animator: Ollin
Joel Burch .... pre-visualization artist: Image Engine
David Urresti Chiu .... animation supervisor: pre-visualization, Ollin Studio
Donnie Creighton .... digital intermediate producer
Robin L. D'Arcy .... visual effects producer: previz
Fernando del Campo .... visual effects coordinator
Nicholas Dunlevy .... visual effects coordinator: second unit
Charlene Eberle Douglas .... visual effects: plate supervisor (as Charlene Eberle)
Charlie Iturriaga .... visual effects supervisor: previz
Patrick McNabb .... pre-visualization artist: Image Engine
Janet Muswell .... visual effects producer
Claudio Jimenez Palomar .... pre-visualisation artist: Image Engine
George Samilski .... pre-visualization supervisor: Image Engine
Ariel Velasco-Shaw .... visual effects supervisor
Joey Wilson .... previsualization artist: Image Engine
Nicki Wong .... pre-visualization artist: Image Engine
Carson Yuen .... pre-visualisation artist: Image Engine
 

Stunts

Freddy Bouciegues .... stunts
Janene Carleton .... stunt double: Emmy Rossum
Lateef Crowder .... stunts
Jared S. Eddo .... stunt coordinator
Jonathan Eusebio .... martial arts stunt coordinator
Daniel Hernandez .... stunt double
Dusan Hyska .... utility stunts
Yoshio Iizuka .... stunt double: Gohan
Ralf Koch .... stunt rigger
Ming Liu .... stunt double
Sam Looc .... utility stunts
Jackson Spidell .... stunt double: Justin Chatwin
Don Tai .... stunt double: Yun-Fat Chow
Jon Valera .... stunts
César René Vigné .... stunt double: Justin Chatwin
Ryan Watson .... stunts
Mike Wilson .... stunts
 

Camera and Electrical Department

Carlos Doerr .... first assistant camera
Wilma Gómez Luengo .... focus puller: "a" camera
Casey Hotchkiss .... camera operator
 

Animation Department

Louis Leung .... animator
Mario Pochat .... animation supervisor
 

Casting Department

PoPing AuYeung .... casting: Asia
Jennifer Cram .... casting associate
Ricardo Hernandez .... casting associate
Dylan Jury .... casting assistant
Rodrigo Urbano .... casting associate
Dan Velez .... casting associate
 

Costume and Wardrobe Department

Valerie Campbell .... costume supervisor
Mariana Mechoulam .... set costumer
 

Editorial Department

Justin C. Green .... first assistant editor
 

Transportation Department

Ricardo Díaz .... transportation coordinator
Alfonso Paredes .... driver
Edmundo Pérez .... dispatcher
Hector Salomon .... picture car coordinator
 

Other crew

Deborah J. Chesebro .... production accountant: second unit
Marina Filippelli .... production coordinator: second unit
Carlos Larios .... production assistant
Norberto Nava .... security coordinator
Tony Patterson .... assistant to executive producer
Walter Vega Puig .... production assistant
Arturo Romero .... production accountant
Horacio Sandoval .... assistant location manager
Mark Shultz .... production coordinator
Efrén Valladares .... assistant office production coordinator


Add as favourites (177) | Quote this article on your site | Views: 937

Be first to comment this article
RSS comments

Only registered users can write comments.
Please login or register.

 
< Prev
186 queries executed
1
SET sql_mode = 'MYSQL40'
2 SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 AND folder = 'system' ORDER BY ordering
3 SELECT `id`,`link` FROM jos_menu WHERE ((`name` LIKE '%Mamblog%') AND (`published` > 0))
4 SELECT oldurl, newurl FROM jos_redirection WHERE oldurl = 'Mamblog/Movies-Music/dragonball_2009_movie.html' ORDER BY rank ASC LIMIT 1
5 UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_content&Itemid=104&id=76&lang=en&task=view' AND `oldurl` = 'Mamblog/Movies-Music/dragonball_2009_movie.html'
6 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 104 ) ORDER BY menuid DESC LIMIT 1
7 DELETE FROM jos_session WHERE ( ( time < '1328783026' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1328789326' ) AND guest = 1 AND userid = 0 )
8 SELECT * FROM jos_session WHERE session_id = 'e7b824e6568e10c0fe06de8708fb4dd7'
9 SELECT session_id FROM jos_session WHERE session_id = '6da896d6434596454c8d57a9b9b440ae'
10 INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '6da896d6434596454c8d57a9b9b440ae','1328790226','','0','1' )
11 SELECT * FROM jos_menu WHERE id = 104
12 SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access, s.id AS sec_id, cc.id as cat_id FROM jos_content AS a LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_sections AS s ON s.id = cc.section AND s.scope = 'content' LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_groups AS g ON a.access = g.id WHERE a.id = 76 AND ( a.state = 1 OR a.state = -1 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-09 06:23' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-09 06:23' ) AND a.access <= 0
13 SELECT a.id FROM jos_content AS a WHERE a.catid = 24 AND a.state = 1 AND a.access <= 0 AND ( a.state = 1 OR a.state = -1 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-09 06:23' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-09 06:23' ) ORDER BY a.ordering
14 SELECT ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count FROM jos_content AS a LEFT JOIN jos_content_rating AS v ON a.id = v.content_id WHERE a.id = 76
15 UPDATE jos_content SET hits = ( hits + 1 ) WHERE id = '76'
16 SELECT folder, element, published, params FROM jos_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
17 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
18 SELECT * FROM jos_mambots WHERE id = '32'
19 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
20 SELECT * FROM jos_mambots WHERE id = '32'
21 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
22 SELECT * FROM jos_mambots WHERE id = '32'
23 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
24 SELECT * FROM jos_mambots WHERE id = '32'
25 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 76 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
26 SELECT COUNT(*) AS favourite FROM jos_akocomment_favoured WHERE id_content = '76'
27 SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
28 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=104&id=76&lang=en&task=favoured'
29 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=104&id=76&lang=en&task=quote'
30 SELECT hits FROM jos_content WHERE id = '76'
31 SELECT count(*) FROM jos_akocomment WHERE contentid='76' AND published='1'
32 SELECT a.* FROM jos_components AS a WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' ) AND a.option = 'com_syndicate'
33 SELECT id, title, module, position, content, showtitle, params FROM jos_modules AS m INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id != 1 AND ( mm.menuid = 0 OR mm.menuid = 104 ) ORDER BY ordering
34 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
35 SELECT * FROM jos_mambots WHERE id = '32'
36 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
37 SELECT * FROM jos_mambots WHERE id = '32'
38 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
39 SELECT * FROM jos_mambots WHERE id = '32'
40 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
41 SELECT * FROM jos_mambots WHERE id = '32'
42 SELECT m.*, sum(case when p.published=1 then 1 else 0 end) as cnt FROM jos_menu AS m LEFT JOIN jos_menu AS p ON p.parent = m.id WHERE m.menutype='mainmenu' AND m.published='1' AND m.access <= '0' GROUP BY m.id ORDER BY m.parent, m.ordering
43 SELECT m.* FROM jos_menu AS m WHERE menutype='mainmenu' AND m.published='1'
44 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_gallery2&Itemid=82&lang=en'
45 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_gallery2&Itemid=137&lang=en'
46 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&lang=en'
47 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&lang=en'
48 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=9997&lang=en'
49 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&arcade=leaderboard&lang=en'
50 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&Itemid=135&lang=en'
51 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&Itemid=140&lang=en'
52 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_jvlinx&Itemid=152&lang=en'
53 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_kunena&Itemid=154&lang=en'
54 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_shared_private_space&Itemid=150&lang=en'
55 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&Itemid=115&lang=en'
56 SELECT u.id, u.username, u.name, c.avatar FROM jos_comprofiler c, jos_users u where c.id = u.id and c.avatar IS NOT NULL and c.approved = 1 and c.confirmed = 1 and u.block = 0 and c.banned = 0 group by u.id order by c.hits desc limit 4
57 SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 75
58 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=75'
59 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
60 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=75'
61 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
62 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=75&task=new'
63 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=75
64 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=75&lang=en&task=addConnection'
65 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
66 SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 73
67 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=73'
68 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
69 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=73'
70 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
71 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=73&task=new'
72 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=73
73 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=73&lang=en&task=addConnection'
74 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
75 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&groupid=11&lang=en&task=showgroup'
76 SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 81
77 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=81'
78 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
79 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=81'
80 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
81 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=81&task=new'
82 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=81
83 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=81&lang=en&task=addConnection'
84 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
85 SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 79
86 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=79'
87 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
88 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=79'
89 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
90 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=79&task=new'
91 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=79
92 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=79&lang=en&task=addConnection'
93 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
94 SELECT a.id, a.title, a.sectionid, a.catid FROM jos_content AS a LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid WHERE ( a.state = 1 AND a.sectionid > 0 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-09 06:23' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-09 06:23' ) AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND f.content_id IS NULL AND s.published = 1 AND cc.published = 1 ORDER BY a.created DESC LIMIT 8
95 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 136 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
96 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 135 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
97 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 134 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
98 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 133 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
99 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 131 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
100 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 130 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
101 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 129 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
102 SELECT id FROM jos_menu WHERE type = 'content_blog_section' AND published = 1 AND componentid = 0
103 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 128 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
104 select u.id, u.username, u.name, c.avatar from jos_users u, jos_comprofiler c where u.id = c.user_id and c.approved = 1 and c.confirmed = 1 and c.avatar IS NOT NULL and c.banned = 0 and u.block = 0 order by rand() desc limit 9
105 SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 76
106 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=76'
107 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
108 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=76'
109 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
110 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=76&task=new'
111 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=76
112 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=76&lang=en&task=addConnection'
113 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
114 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&groupid=13&lang=en&task=showgroup'
115 SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 74
116 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=74'
117 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
118 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=74'
119 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
120 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=74&task=new'
121 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=74
122 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=74&lang=en&task=addConnection'
123 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
124 SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 92
125 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=92'
126 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
127 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=92'
128 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
129 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=92&task=new'
130 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=92
131 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=92&lang=en&task=addConnection'
132 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
133 SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 80
134 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=80'
135 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
136 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=80'
137 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
138 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=80&task=new'
139 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=80
140 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=80&lang=en&task=addConnection'
141 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
142 SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 165
143 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=165'
144 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
145 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=165'
146 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
147 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=165&task=new'
148 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=165
149 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=165&lang=en&task=addConnection'
150 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
151 SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 153
152 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=153'
153 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
154 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=153'
155 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
156 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=153&task=new'
157 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=153
158 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=153&lang=en&task=addConnection'
159 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
160 SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 97
161 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=97'
162 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
163 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=97'
164 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
165 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=97&task=new'
166 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=97
167 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=97&lang=en&task=addConnection'
168 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
169 SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 106
170 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=106'
171 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
172 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=106'
173 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
174 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=106&task=new'
175 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=106
176 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=106&lang=en&task=addConnection'
177 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
178 SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 89
179 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=89'
180 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
181 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=89'
182 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
183 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=89&task=new'
184 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=89
185 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=89&lang=en&task=addConnection'
186 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'