CollectionStation.com - Collectibles: Boil and Waxer with Numa

Boil and Waxer with Numa

Some accessibility text
0/5

0 (0 reviews)

Read 0 Reviews

Rate and Review this Collectible

Value Guide

CS ID #: 17049
Added: November 26, 2011 at 1:23 pm by CollectionStation

Name: Boil and Waxer with Numa
Description: With the Clone Wars well underway, Jedi General Obi-Wan Kenobi receives orders to lead his troops aboard Republic gunships to the planet Ryloth and take the city of Nabat as a landing zone for its transport ships. The Twi'lek citizens of Nabat have been taken hostage by Separatist battle droids and are being used as human shields for the droids' anti-aircraft cannons in the city's central courtyard. Landing in the jungles outside Nabat, the Jedi General leads his troops forward.�
Manufacturer: Sideshow Collectibles
License: Star Wars
Product Type: 12" Figures
Assortment: Militaries of Star Wars
Source: The Clone Wars
Item Number: 100012
Exclusive to: Nobody
Limited Edition of: 1500
SRP: $224.99
Year Released: 2011
Scale: 1/6
Size: 12"
Points of Articulation: 30
Package Type: Folding Window Box
UPC: Contribute details UPC
Country: United States
Weapons & Accessories:
- 2 x Fully articulated male body (armored body) with 30+ points of articulation
- Boil portrait
- Waxer portrait
- 2 x Fabric bodysuit with additional fabric collar
- 2 x Detailed armor
- 2 x Episode 2 style helmet
- 2 x Episode 3 style helmet
- Generous assortment of switch-out hands
- 4 x sets switch-out boots (2 x action, 2 x standing)
- 2 x Blaster Rifle
- 2 x Blaster Carbine
- 2 x Blaster pistol
- Clone binoculars
- Newly developed 5.5 inch figure body (Numa)
- Numa portrait
- Fabric dress
- Pegged disc base for Numa
- 2 x 12-inch Figure Display Base with Star Wars Logo
Artists:
- Bernardo Esquivel
- Nathan Eakins
- Jared Chapman
- Andy Bergholtz
- Trevor Grove
- Tim Hanson
- The Sideshow Collectibles Design and Development TeamThe Sideshow Collectibles Design and Development Team
Notes: None

Tags (separate by commas): Star Wars, Sideshow Collectibles, Boiler, Waxer, Militaries of Star Wars, Numa, The Clone Wars, Action Figure

BENCHMARKS

Loading Time: Base Classes	0.0161
Loading Man	0.0130
Getting Collectible	0.0008
Getting Category	0.0222
Checking Privacy	0.0000
Checking Moderator	0.0008
Getting Moderators	0.0002
Checking Collectible Privacy	0.0004
Checking Permissions	0.0002
Adding Variant	0.0000
Handling Options	0.0000
Reverting History	0.0000
Reporting Item	0.0000
Updating Item Views	0.0003
Getting Images	0.0319
Checking Featured	0.0002
Getting Avg Values	0.0002
Getting Ebay Averages	0.0003
Getting Ebay Values	0.0009
Mining Tags	0.0003
Handling Tags	0.0000
Getting Variants	0.0054
Getting Owner	0.0003
Getting Tags	0.0004
Getting Category Tags	0.0003
Getting Collectible Tags	0.0075
Merchant Data 8	0.0002
Merchant Type Description	0.0024
Merchant Type Source	0.0021
Getting Merchant Data	0.0362
Getting Comments	0.0004
Getting Reviews	0.0111
Getting Ratings	0.0000
Getting Reviews 2	0.0000
Getting Favorites	0.0001
Getting CollectionItems	0.0002
Getting Recent Viewed	0.0004
Controller Execution Time ( Collectibles / View )	0.8195
Total Execution Time	0.8357

GET DATA

No GET data exists

MEMORY USAGE

8,912,464 bytes

POST DATA

No POST data exists

URI STRING

collectibles/17049-Boil-and-Waxer-with-Numa-The-Clone-Wars/value

CLASS/METHOD

collectibles/view

DATABASE: cs_live QUERIES: 204 (Show)

0.0002	SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '17049' AND `Removed` = 0
0.0002	SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '16544' AND `Removed` = 0
0.0001	SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '16544'
0.0001	SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '302' LIMIT 1
0.0001	SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '16544'
0.0002	SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '16545' AND `Removed` = 0
0.0002	SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '16545'
0.0001	SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '304' LIMIT 1
0.0002	SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '16545'
0.0002	SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '17046' AND `Removed` = 0
0.0002	SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '17046'
0.0001	SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '304' LIMIT 1
0.0001	SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '17046'
0.0001	SELECT `AttributeID` FROM `Attribute` WHERE GenericID = 304 AND Name = 'Name'
0.0001	SELECT `Value` FROM `Attribute_Value` WHERE `AttributeID` = 1421 LIMIT 1
0.0002	SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '17048' AND `Removed` = 0
0.0002	SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '17048'
0.0001	SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '302' LIMIT 1
0.0001	SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '17048'
0.0002	SELECT `AttributeID` FROM `Attribute` WHERE GenericID = 302 AND Name = 'Name'
0.0001	SELECT `Value` FROM `Attribute_Value` WHERE `AttributeID` = 1339 LIMIT 1
0.0002	SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '17049' AND `Removed` = 0
0.0002	SELECT * FROM (`Collectible`) WHERE `CollectibleID` = '17049'
0.0001	SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '304' LIMIT 1
0.0002	SELECT * FROM (`Collectible_Title`) WHERE `CollectibleID` = '17049'
0.0001	SELECT `AttributeID` FROM `Attribute` WHERE GenericID = 304 AND Name = 'Name'
0.0001	SELECT `Value` FROM `Attribute_Value` WHERE `AttributeID` = 1421 LIMIT 1
0.0004	`select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 17049 ORDER BY a.Position, a.AttributeID ASC`
0.0168	`select c.*, (IsCategoryPrivate(CategoryID) = 1) as Private, (select count(CollectibleID) from Collectible where CategoryID = c.CategoryID and Removed = 0) as CollectibleCount from Category c where c.CategoryID = 304`
0.0004	`select * from Attribute where GenericType = 'category' and GenericID = 304`
0.0001	`select * from Private where GenericType = 'category' and GenericID = 1`
0.0002	`select * from Private where GenericType = 'category' and GenericID = 2`
0.0001	`select * from Private where GenericType = 'category' and GenericID = 98`
0.0001	`select * from Private where GenericType = 'category' and GenericID = 3`
0.0001	`select * from Private where GenericType = 'category' and GenericID = 70`
0.0001	`select * from Private where GenericType = 'category' and GenericID = 298`
0.0001	`select * from Private where GenericType = 'category' and GenericID = 304`
0.0001	`select CategoryID from Category where ParentID = '304'`
0.0002	`select R., RG.RoleGroupID from Role_Group_Link as RGL inner join Role_Group as RG on RG.RoleGroupID = RGL.RoleGroupID inner join Role as R on R.RoleID = RGL.RoleID inner join Role_Group_User as RGU on RGU.RoleGroupID = RGL.RoleGroupID where RGU.UserID = -1 union select R., null from Role as R inner join Role_Group_User as RGU on RGU.RoleID = R.RoleID where RGU.UserID = -1`
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 304
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 298
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 70
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 3
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 98
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
0.0001	`select * from Private where GenericType = 'category' and GenericID = 304`
0.0002	SELECT * FROM (`Review`) WHERE `GenericID` = '17049' AND `GenericType` = 'collectible' AND `Removed` = 0 ORDER BY `Date` DESC
0.0001	SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '17049' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0002	SELECT * FROM (`Review`) WHERE `GenericID` = '17049' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0001	SELECT RatingID, Rating FROM Rating WHERE `GenericID` = 17049 AND `Removed` = 0 Order BY Rating DESC LIMIT 1
0.0014	SELECT * FROM (`Review`) WHERE `RatingID` IS NULL
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37'
0.0001	SELECT `CollectorType` FROM (`User`) WHERE `UserID` = '37'
0.0001	SELECT RatingID, Rating FROM Rating WHERE `GenericID` = 17049 AND `Removed` = 0 Order BY Rating ASC LIMIT 1
0.0013	SELECT * FROM (`Review`) WHERE `RatingID` IS NULL
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37'
0.0002	SELECT `CollectorType` FROM (`User`) WHERE `UserID` = '37'
0.0001	SELECT * FROM (`Review`) WHERE `GenericID` = '17049' AND `GenericType` = 'collectible' AND `Removed` = 0 AND `Recommend` = 'yes'
0.0001	SELECT Rating, count( * ) as nrVotes FROM `Review` WHERE GenericID = 17049 AND GenericType = 'collectible' GROUP BY Rating
0.0002	`select * from Image where GenericType = 'collectible' and GenericID = 17049 order by ImageID DESC`
0.0002	SELECT * FROM (`Image`) WHERE `ImageID` = '25697'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT * FROM (`Image`) WHERE `ImageID` = '25696'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT * FROM (`Image`) WHERE `ImageID` = '25695'
0.0003	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT * FROM (`Image`) WHERE `ImageID` = '25694'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT * FROM (`Image`) WHERE `ImageID` = '25693'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT * FROM (`Image`) WHERE `ImageID` = '25692'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0001	SELECT * FROM (`Image`) WHERE `ImageID` = '25691'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0001	SELECT * FROM (`Image`) WHERE `ImageID` = '25690'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT * FROM (`Image`) WHERE `ImageID` = '25689'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT * FROM (`Image`) WHERE `ImageID` = '25688'
0.0004	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT * FROM (`Image`) WHERE `ImageID` = '25687'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0001	SELECT * FROM (`Image`) WHERE `ImageID` = '25686'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT * FROM (`Image`) WHERE `ImageID` = '25685'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT * FROM (`Image`) WHERE `ImageID` = '25684'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT * FROM (`Image`) WHERE `ImageID` = '25683'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT * FROM (`Image`) WHERE `ImageID` = '25682'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0001	SELECT * FROM (`Image`) WHERE `ImageID` = '25681'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT * FROM (`Image`) WHERE `ImageID` = '25680'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT * FROM (`Image`) WHERE `ImageID` = '25679'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT * FROM (`Image`) WHERE `ImageID` = '25678'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT * FROM (`Image`) WHERE `ImageID` = '25677'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT * FROM (`Image`) WHERE `ImageID` = '25676'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT * FROM (`Image`) WHERE `ImageID` = '25675'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0001	SELECT * FROM (`Image`) WHERE `ImageID` = '25674'
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	`select * from User where UserID = -1 LIMIT 1`
0.0002	`select * from Value`
0.0002	`select * from Value`
0.0001	`select CollectibleID from Collectible where CategoryID = 17049`
0.0001	`select CategoryID from Category where ParentID = '17049'`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from Tag where GenericID = 17049 and GenericType = 'collectible'`
0.0002	SELECT * FROM Attribute WHERE Removed = 0 AND `GenericType` = 'category' AND `GenericID` = 304 ORDER BY `Position`, `AttributeID` ASC
0.0002	`select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 17049 ORDER BY a.Position, a.AttributeID ASC`
0.0002	`select * from Collectible_Variation where CollectibleID = 17049`
0.0002	select C.*, Cat.Name, Cat.TitleTemplate, (select count(ReviewID) from Review where GenericType = 'collectible' and GenericID = C.CollectibleID and Removed = 0) as ReviewCount, (select count(CommentID) from Comment where GenericType = 'collectible' and GenericID = C.CollectibleID and Removed = 0) as CommentCount, C.CollectibleID as Private from Collectible as C inner join Category as Cat on C.CategoryID = Cat.CategoryID where C.CollectibleID = 17049
0.0002	`select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 17049 ORDER BY a.Position, a.AttributeID ASC`
0.0002	`select av.*, a.Name, a.Type, a.Example, a.Removed as ParentRemoved, a.Hidden as ParentHidden, a.ShowInNarrow from Attribute_Value as av inner join Attribute as a on av.AttributeID = a.AttributeID where av.GenericType = 'collectible' and av.GenericID = 17049 ORDER BY a.Position, a.AttributeID ASC`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0001	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0001	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0001	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0001	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0002	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0002	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0001	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0001	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0001	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0001	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0001	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0002	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0002	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0001	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0001	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0001	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0001	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0001	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0001	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0001	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0001	`select c.*, u.Username from Comment c inner join User u on u.UserID = c.UserID where c.GenericType = 'collectible' and c.GenericID = 17049`
0.0001	`select CI.*, C.Name as CollectionName from Collection_Item as CI inner join Collection as C on CI.CollectionID = C.CollectionID where C.CollectionID = 17049`
0.0002	`select GenericType, GenericID, (select Date from View_History where GenericID = vh.GenericID and GenericType = vh.GenericType order by Date desc limit 0,1) as LastDate, count(ViewHistoryID) as ViewCount from View_History vh group by GenericType, GenericID`
0.0001	`select *, (Max - Used) as Remaining from User_Value_Allowance`
0.0002	`select CI.*, C.Name as CollectionName from Collection_Item as CI inner join Collection as C on CI.CollectionID = C.CollectionID where C.CollectionID = 17049`
0.0001	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0002	SELECT * FROM Message WHERE `To` = '-1' ORDER BY MessageID DESC
0.0001	`select * from Notification_Filter`
0.0001	`select * from Notification`
0.0002	`select * from Notification`
0.0002	`select * from Image where GenericType = 'collectible' and GenericID = 16544 order by ImageID DESC`
0.0002	`select * from Image where GenericType = 'collectible' and GenericID = 16545 order by ImageID DESC`
0.0002	`select * from Image where GenericType = 'collectible' and GenericID = 17046 order by ImageID DESC`
0.0002	`select * from Image where GenericType = 'collectible' and GenericID = 17048 order by ImageID DESC`
0.0002	`select * from Image where GenericType = 'collectible' and GenericID = 17049 order by ImageID DESC`
0.0002	`select * from Zone`
0.0002	`select * from Zone`
0.0031	`select * from User`
0.0032	`select * from User`
0.0032	`select * from User`
0.0032	`select * from User`
0.0032	`select * from User`
0.0032	`select * from User`
0.0032	`select * from User`
0.0033	`select * from User`
0.0032	`select * from User`
0.0033	`select * from User`
0.0034	`select * from User`
0.0034	`select * from User`
0.0034	`select * from User`
0.0033	`select * from User`
0.0034	`select * from User`
0.0032	`select * from User`
0.0032	`select * from User`
0.0033	`select * from User`
0.0033	`select * from User`
0.0033	`select * from User`
0.0034	`select * from User`
0.0033	`select * from User`
0.0003	`select * from Zone`
0.0002	`select * from Zone`

HTTP HEADERS (Show)

SESSION DATA (Show)

session_id	766fac0d00e1fca869b7cdda161fab6a
ip_address	38.107.179.230
user_agent	CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
last_activity	1337898299
category_id	98
Referrer	http://www.collectionstation.com/categories/add
recently_viewed	16544,16545,17046,17048,17049

CONFIG VARIABLES (Show)

base_url	http://www.collectionstation.com/
index_page
uri_protocol	AUTO
url_suffix
language	english
charset	UTF-8
enable_hooks
subclass_prefix	MY_
permitted_uri_chars
enable_query_strings
directory_trigger	d
controller_trigger	c
function_trigger	m
log_threshold	0
log_path
log_date_format	Y-m-d H:i:s
cache_path
encryption_key	0BA565C0218E95F2FDE363571E4568262E6AE87002118329AD6CD62F802741AE
sess_cookie_name	cs_session
sess_expiration	86400
sess_encrypt_cookie	1
sess_use_database
sess_table_name	Session
sess_match_ip
sess_match_useragent
sess_time_to_update	300
cookie_prefix
cookie_domain
cookie_path	/
global_xss_filtering
compress_output
time_reference	local
rewrite_short_tags
Upload_AllowedTypes	Array ( [image/pjpeg] => jpg [image/jpeg] => jpg [image/gif] => gif [image/bmp] => bmp [image/x-png] => png [image/png] => png [image/zip] => zip [image/x-zip-compressed] => zip [application/pdf] => pdf )
Upload_MaxFileSize	52428800
Support	Array ( [Server] => mail.collectionstation.com [Port] => 110 [Email] => help@collectionstation.com [Username] => help@collectionstation.com [Password] => 28412ssg )
Email_DefaultSender	Array ( [Email] => no-reply@collectionstation.com [Name] => CollectionStation.com )
Emails	Array ( [Report] => Array ( [Collectible] => support@collectionstation.com [Blog] => support@collectionstation.com [Comment] => support@collectionstation.com ) [Collectible] => Array ( [CSV] => support@collectionstation.com ) )
Months	Array ( [0] => Array ( [0] => 1 [1] => Jan [2] => January ) [1] => Array ( [0] => 2 [1] => Feb [2] => February ) [2] => Array ( [0] => 3 [1] => Mar [2] => March ) [3] => Array ( [0] => 4 [1] => Apr [2] => April ) [4] => Array ( [0] => 5 [1] => May [2] => May ) [5] => Array ( [0] => 6 [1] => Jun [2] => June ) [6] => Array ( [0] => 7 [1] => Jul [2] => July ) [7] => Array ( [0] => 8 [1] => Aug [2] => August ) [8] => Array ( [0] => 9 [1] => Sep [2] => September ) [9] => Array ( [0] => 10 [1] => Oct [2] => October ) [10] => Array ( [0] => 11 [1] => Nov [2] => November ) [11] => Array ( [0] => 12 [1] => Dec [2] => December ) )
invalid_usernames	Array ( [0] => admin [1] => staff [2] => hasbro [3] => mattel [4] => neca [5] => star_wars [6] => starwars [7] => wwe [8] => sideshow [9] => sideshow_collectibles [10] => gentle_giant [11] => gentlegiant )
WatermarkImage	/home/stevecs/domains/collectionstation.com/git/githome/trunk/assets/images/watermark.png
signup_minimumage	13
captchaKeyPublic	6LcktQAAAAAAAKVsuDvlOPjFyoxpapzxqDkvnjoT
captchaKeyPrivate	6LcktQAAAAAAALaEVNO9bxWkHXS92Q4GcOsosPxR
CronPath	/home/stevecs/domains/collectionstation.com/git/githome/trunk/assets/_private/cron/
ReviewEditTimeout	3600
AllowCSVUpload
Pagination	Array ( [my] => Array ( [feeds] => 50 [messages] => Array ( [inbox] => 25 [sent] => 25 [trash] => 25 ) [friends] => Array ( [index] => 15 [requests] => 15 [pending] => 15 [suggestions] => 5 ) [groups] => Array ( [index] => 15 [created] => 15 [invites] => 15 ) [selling] => 20 [reviews] => 20 [collections] => Array ( [view] => 20 ) ) [profile] => Array ( [friends] => 25 [groups] => 25 [articles] => 25 [reviews] => 25 [favorites] => 25 [collectionitems] => 25 [photos] => 25 [collections] => 25 [selling] => 25 ) [groups] => Array ( [viewall] => 8 [threads] => 10 [discussions] => 10 [members] => 24 [latestthreads] => 10 ) [tags] => Array ( [search] => 10 ) [blog] => Array ( [articles] => 10 [latestarticles] => 10 [article] => Array ( [comments] => 10 ) ) [collectibles] => Array ( [index] => Array ( [categories] => Array ( [random] => 5 [newest] => 5 [right] => 15 ) [collectibles] => Array ( [random] => 5 [newest] => 5 [popular] => 5 [comments] => 5 ) [collectors] => Array ( [reviews] => 5 ) [view] => 20 ) [view] => Array ( [comments] => 50 [reviews] => 5 ) ) [category] => Array ( [view] => Array ( [collectibles] => 24 [right] => 15 ) ) [collections] => Array ( [index] => 20 ) [search] => Array ( [collectibles] => 20 [categories] => 20 [collections] => 20 [groups] => 20 [blogs] => 20 ) )
Ebay	Array ( [Mode] => Sandbox [Urls] => Array ( [ItemUrl] => http://rover.ebay.com/rover/1/711-53200-19255-0/1?type=2&campid=5335816071&toolid=10001&customid=&ext=%s&item=%s ) [Sandbox] => Array ( [Affiliation] => Array ( [TrackingID] => 5335816071 [TrackingPartnerCode] => 9 ) [Keys] => Array ( [App] => Collecti-6abf-4222-994a-f29b91034597 [Cert] => 2311c370-0c7d-4890-8c7e-86eb0caf9d70 [Dev] => 87e00c2e-beee-4d5f-8dcd-608966f590ed ) [Login] => Array ( [Username] => TESTUSER_csuser1 [Password] => amanda ) [RUName] => CollectionStati-Collecti-f256-4-lbbiez [SiteID] => 0 [Token] => AgAAAAAQAAAAaAAAAALFRiSQnY+sHZ2PrBmdj6wVnY+sEZ2PrA2dj6wFk4CoDJKApgudj6x9nY+seQGe4AAAAAMAAAA35sPpDzizBTO7Ahi85dzdrrHHtJE5jovqcOjbcasSka02//i9Tsa0d1e9AJ3KCLcqOpB88xahaDpeRV4rH2SYlxN+XEsuKfWfUt9kRk5hZ3YQ590mNnkYno3ooTwxwr2d/d6qbP+PAsu891U3Ic+xKZ1z5rzMSv2oDBl0g8AcbG+MleSVFQa4YadFPQUS6Y7jJtCbY6mt1sclU+TH97bEwHIT9Ub/Qnub868hBk1CDVLJ+5N+kKLik+zpDCyP4OBsMx1CpWMbb/+/D5ktmnXD7y2Dk+OFTWzd6FbQbw5gEqL5ORmUr9RMjBJF//gUdgXfsdP+BzSDVB4OQowrfzF7NW9tsyRGsm++jdz6bMD1KYOXTDnr1gGS2MQgdNUeJBrOCQHgxWCmnLQkAF8cHqrNzCPHWnYagHiIUVbwYHeRruTJOhD7HgvsD7g2CkVLlHIIkTyKR/uBbgc3EuTaoIegoG4wCrbPDX3PbxK4tt/SHQ85dFelJQHYsYn5DhlRLNMVJbUwD/sar4TVbItCIMeoOpCBJTRUVjQZ4k/TwoLI8ozP/hUzU9N+GSK4fl0XXd5zv4Uexgn9fSIG1tS3SPeUZAMaiASJLJYMiiGfQMomu4TobRkc3Oy3JSc0Te1v5/9573V4T6+0Z7Z6SlNsQ65MAVmcCsQOFzYaCEeDS1KJxwpuN3jLX/y2Ln1j8ifrtWo1q1drBvU0AHAIZLCaniT3ENnRHWFExkbgbe+Jbumr0vqmF2OReF0woW1ObQhuM0 [TokenExpiry] => 1277836844 [Urls] => Array ( [Trading] => https://api.sandbox.ebay.com/ws/api.dll [Shopping] => http://open.api.sandbox.ebay.com/shopping [Login] => https://signin.sandbox.ebay.com/ws/eBayISAPI.dll?SignIn ) ) [Production] => Array ( [Affiliation] => Array ( [TrackingID] => 5335816071 [TrackingPartnerCode] => 9 ) [Keys] => Array ( [App] => Collecti-f256-4970-964b-45a0e5e42da4 [Cert] => e3bea769-4a3e-4862-8391-eae1168fc4d4 [Dev] => 87e00c2e-beee-4d5f-8dcd-608966f590ed ) [Login] => Array ( [Username] => collectionstation [Password] => 28412cs123 ) [RUName] => CollectionStati-Collecti-f256-4-lbbiez [SiteID] => 0 [Token] => AgAAAAAQAAAAaAAAAASS3ZSAnY+sHZ2PrBmdj6wVnY+sEZ2PrA2dj6wDlIOgDpiFoAudj6x9nY+seQgWkAAAAAMAAAy9A44mmIUjsJVs/BKJFHZmyYA6vfKdYpVshki9s4n1qkR6KrDs+igww0sw5Z/vtME3+TYlTZ/R/0w9okIgPqJiXrOveXKAgqk/U1HOngaAUkzjsoAOpjgpbQ7aBOJdLGafdlYjJo4Y1p6KuB3eptVnz96mTqXE8Uiq/KJnQlxdUGl8V3/aENG5LyNVVkr460gEXiHsBhGZMUcNY3Cj4g5ScpRnNhs4fm7IIjehzdsxy2zp/Q1LeiNQp44n1H5xjQ+/GJWbTCFfaacoMg6TlldgvS+6pZoXde0wOXYXAeBirxefYFbor3Cfb9OjFTomBoU36PDs8pecvNXEm6tUsH95xRgnA8xhQc8oVqGfKIhbAIaRuf63JQ4ESiEQo2ftnRjc1reWZRUu6CxCmaMBU+A/DL+Gp+m6/I14/0pfNeVYR6AUBWq1LlLWTlvYpaTpFUU/8koYI9gQHrrvEbebYAbtckuJC8agRCHTKiBnYLOUUNnYuv7wKlcubueQVqb8oGRb61rE948e+xCoISgSWmVJxkKCUSkXGxFmjIJ9/giDxQz7SX0pEnmZ+2zMNiGfLF1c2V9qDJK6+VnrsoM6R1qq/KyK0rmvv+B3Doefk7XDhZJspnEJukS6gdqVB6ysLsmPvhfquqe5YVyk/ibX6EQfc93yk8RzxOPSv6Y2n1T79bsysO4zp2xz7kpeDegQX1vDpSI1LpIwIb6YMow4BnfA/g+n6VlvDZs4NiKyJjBgxnntpLjOCpcFVIDKAPoKFI [TokenExpiry] => 1277836844 [Urls] => Array ( [Trading] => https://api.ebay.com/ws/api.dll [Shopping] => http://open.api.ebay.com/shopping [Login] => https://signin.ebay.com/ws/eBayISAPI.dll?SignIn ) ) )
Amazon	Array ( [WSDL] => https://webservices.amazon.com/AWSECommerceService/AWSECommerceService.wsdl [Key] => 01NSVJN3ZJDBJ0CKB082 [SecretKey] => QQj24a5D5xHpJ8vMNuzF5adS02ddxUZJ2axFnbzU [Tag] => collectioncom-20 [CertPath] => /home/stevecs/domains/collectionstation.com/git/githome/trunk/assets//_private/cert-XLJLFUMSMJO27XFNSFYWA73DRIYQV5AX.pem )
CommissionJunction	Array ( [WSDL] => https://pubcommission.api.cj.com/wsdl/version2/publisherCommissionServiceV2.wsdl [Key] => 00adcd6482b3e6b7b46f10f8cbadec5bb32c3a124dfb0657aa5c9ee8ab27cfffc688ebfe6aef86384ded52c84d29b951584944e8184d7a19baaffd79e4b00de88d/7126d6380dbdb87dfd0d349d0e3762200d3c256ca57024a4e23606ce5f56187367e8022feed3c6e433488ad908defdb9ab32b92431a7173b5d15a71e55984e81 )
DataUnison	Array ( [Mode] => Sandbox [Sandbox] => Array ( [Keys] => Array ( [User] => 68df413c6cd87412016fb9195bbe67 [Dev] => collectionstation_steve_comenzo ) [SiteID] => 0 [Token] => d16bda03700aac097dd79e20e110ee [Urls] => http://api.dataunison.com/ ) [Production] => Array ( [Keys] => Array ( [User] => 68df413c6cd87412016fb9195bbe67 [Dev] => collectionstation_steve_comenzo ) [SiteID] => 0 [Token] => d16bda03700aac097dd79e20e110ee [Urls] => http://api.dataunison.com/ ) )
Cache	Array ( [Servers] => Array ( [0] => Array ( [Host] => localhost [Port] => 11211 ) ) )

HTTP_ACCEPT	text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,/;q=0.5
HTTP_USER_AGENT	CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_CONNECTION	close
SERVER_PORT	80
SERVER_NAME	www.collectionstation.com
REMOTE_ADDR	38.107.179.231
SERVER_SOFTWARE	Apache/2
HTTP_ACCEPT_LANGUAGE	en-us,en;q=0.5
SCRIPT_NAME	/index.php
REQUEST_METHOD	GET
HTTP_HOST
REMOTE_HOST
CONTENT_TYPE
SERVER_PROTOCOL	HTTP/1.1
QUERY_STRING
HTTP_ACCEPT_ENCODING	gzip
HTTP_X_FORWARDED_FOR

CATEGORY

RECENTLY VIEWED

CATEGORY MANAGERS

SPONSORED

Boil and Waxer with Numa

Variants

(curr)	Name	Boil and Waxer with Numa	November 26, 2011 at 1:23 pm	CollectionStation
(curr)	Description	With the Clone Wars well underway, Jedi General Obi-Wan Kenobi receives orders to lead his troops aboard Republic gunships to the planet Ryloth and take the city of Nabat as a landing zone for its transport ships. The Twi'lek citizens of Nabat have been taken hostage by Separatist battle droids and are being used as human shields for the droids' anti-aircraft cannons in the city's central courtyard. Landing in the jungles outside Nabat, the Jedi General leads his troops forward.�	November 26, 2011 at 1:23 pm	CollectionStation
(curr)	Manufacturer	Sideshow Collectibles	November 26, 2011 at 1:23 pm	CollectionStation
(curr)	License	Star Wars	November 26, 2011 at 1:23 pm	CollectionStation
(curr)	Product Type	12" Figures	November 26, 2011 at 1:23 pm	CollectionStation
(curr)	Assortment	Militaries of Star Wars	November 26, 2011 at 1:23 pm	CollectionStation
(curr)	Source	The Clone Wars	November 26, 2011 at 1:23 pm	CollectionStation
(curr)	Item Number	100012	November 26, 2011 at 1:23 pm	CollectionStation
(curr)	Exclusive to	Nobody	November 26, 2011 at 1:23 pm	CollectionStation
(curr)	Limited Edition of	1500	November 26, 2011 at 1:23 pm	CollectionStation
(curr)	SRP	$224.99	November 26, 2011 at 1:23 pm	CollectionStation
(curr)	Year Released	2011	November 26, 2011 at 1:23 pm	CollectionStation
(curr)	Scale	1/6	November 26, 2011 at 1:23 pm	CollectionStation
(curr)	Size	12"	November 26, 2011 at 1:23 pm	CollectionStation
(curr)	Points of Articulation	30	November 26, 2011 at 1:23 pm	CollectionStation
(curr)	Package Type	Folding Window Box	November 26, 2011 at 1:23 pm	CollectionStation
(prev)	UPC	747720214842	November 26, 2011 at 1:23 pm	CollectionStation
(curr)	UPC	Contribute details	November 26, 2011 at 1:48 pm	CollectionStation
(curr)	Country	United States	November 26, 2011 at 1:23 pm	CollectionStation
(curr)	Weapons & Accessories	2 x Fully articulated male body (armored body) with 30+ points of articulation Boil portrait Waxer portrait 2 x Fabric bodysuit with additional fabric collar 2 x Detailed armor 2 x Episode 2 style helmet 2 x Episode 3 style helmet Generous assortment of switch-out hands 4 x sets switch-out boots (2 x action, 2 x standing) 2 x Blaster Rifle 2 x Blaster Carbine 2 x Blaster pistol Clone binoculars Newly developed 5.5 inch figure body (Numa) Numa portrait Fabric dress Pegged disc base for Numa 2 x 12-inch Figure Display Base with Star Wars Logo	November 26, 2011 at 1:23 pm	CollectionStation
(curr)	Artists	Bernardo Esquivel Nathan Eakins Jared Chapman Andy Bergholtz Trevor Grove Tim Hanson The Sideshow Collectibles Design and Development TeamThe Sideshow Collectibles Design and Development Team	November 26, 2011 at 1:23 pm	CollectionStation
(curr)	Notes	None	November 26, 2011 at 1:23 pm	CollectionStation