Commemorative Episode IV DVD Collection (3)

Bulk Add

Add

Added by CollectionStation

Commemorative Episode IV DVD Collection
Category: Toys › Action Figures › Science Fiction & Fantasy › Star Wars › Hasbro/Kenner › Modern (1995-Now) › United States › The Saga Collection (2006) › Commemorative Episode IV DVD Collection
- Some accessibility text
- 0/5
0 (0 reviews)
Value: Sign In to view
Selling: 0 (0 friends 0 others)

Have

Want

Cataloged

Commemorative EPISODE V DVD Collection
Category: Toys › Action Figures › Science Fiction & Fantasy › Star Wars › Hasbro/Kenner › Modern (1995-Now) › United States › The Saga Collection (2006) › Commemorative Episode IV DVD Collection
- Some accessibility text
- 0/5
0 (0 reviews)
Value: Sign In to view
Selling: 0 (0 friends 0 others)

Have

Want

Cataloged

Commemorative Episode VI DVD Collection
Category: Toys › Action Figures › Science Fiction & Fantasy › Star Wars › Hasbro/Kenner › Modern (1995-Now) › United States › The Saga Collection (2006) › Commemorative Episode IV DVD Collection
- Some accessibility text
- 0/5
0 (0 reviews)
Value: Sign In to view
Selling: 0 (0 friends 0 others)

Have

Want

Cataloged

1 to 3 of 3

Loading Time: Base Classes	0.0125
Controller Execution Time ( Categories / Category By Name )	1.1592
Total Execution Time	1.1718

0.0003	SELECT * FROM (`Url`) WHERE `GenericType` = 'category' AND `GenericID` = '2472'
0.0196	`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 = 2472`
0.0005	`select * from Attribute where GenericType = 'category' and GenericID = 2472`
0.0002	`select * from Private where GenericType = 'category' and GenericID = 1`
0.0002	`select * from Private where GenericType = 'category' and GenericID = 2`
0.0002	`select * from Private where GenericType = 'category' and GenericID = 98`
0.0002	`select * from Private where GenericType = 'category' and GenericID = 3`
0.0002	`select * from Private where GenericType = 'category' and GenericID = 66`
0.0002	`select * from Private where GenericType = 'category' and GenericID = 5`
0.0002	`select * from Private where GenericType = 'category' and GenericID = 116`
0.0002	`select * from Private where GenericType = 'category' and GenericID = 365`
0.0005	`select * from Private where GenericType = 'category' and GenericID = 2472`
0.0003	SELECT * FROM (`Category`) WHERE `CategoryID` = '2472' AND `Removed` = 0
0.0003	SELECT * FROM (`Category`) WHERE `CategoryID` = '2472' LIMIT 1
0.0002	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = 0
0.0003	SELECT * FROM (`Private`) WHERE `GenericType` = 'Category' AND `Removed` = 0
0.0032	SELECT * FROM (`Category`) WHERE `CategoryID` NOT IN ('746', '2144', '1131', '987', '991', '993', '994', '1055', '1079', '1088', '1090', '1094', '1149', '1150', '1246', '1299', '1305', '1308', '1309', '1311', '1464', '1473', '1493', '1494', '1518', '1519', '1520', '1530', '1531', '1761', '1721', '1729', '1733', '1735', '1736', '1765', '1766', '1767', '1768', '1769', '1770', '1771', '1772', '1773', '1774', '1776', '1777', '1778', '1779', '1780', '1781', '1782', '1783', '1784', '1786', '1803', '1810', '1815', '1816', '1817', '1818', '1819', '1820', '1821', '1822', '1823', '1824', '1825', '1826', '1827', '1828', '1829', '1830', '1831', '1832', '1833', '1834', '1835', '1861', '2011', '2012', '2013', '2014', '2016', '2017', '2018', '2022', '2069', '2080', '2082', '2083', '2084', '2085', '2086', '2087', '2088', '2089', '2090', '2091', '2092', '2093', '2094', '2095', '2096', '2097', '2098', '2099', '2100', '2101', '2102', '2103', '2112', '2113', '2114', '2115', '2116', '2117', '2118', '2119', '2120', '2121', '2122', '2123', '2124', '2125', '2133', '2128', '2129', '2130', '2131', '2132', '2134', '2135', '2136', '2137', '2233', '2234', '2373', '2390', '2653', '2950', '3006', '3374', '3823', '3824', '3825', '3826', '3827', '3828', '3829', '3830', '3831', '3832', '3833', '3834', '3835', '3836', '3837', '3838', '3839', '3840', '3841', '3842', '3843', '3844', '3845', '3846', '3847', '3848', '3849', '3850', '3932', '3934', '3935', '3936', '3937', '3938', '3939', '3940', '3941', '3942', '3943', '3944', '3953', '3954', '3955', '3956', '3957', '3958', '3959', '3999', '4026', '4029', '4030', '4045', '4045', '4045', '4046') AND `ParentID` = '2472' AND `Removed` = 0 ORDER BY `Name` asc
0.0003	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2472
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 365
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 116
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 5
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 66
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 3
0.0002	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.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
0.0003	SELECT * FROM (`Image`) WHERE `GenericID` = '2472' AND `GenericType` = 'category' ORDER BY `ImageID` DESC
0.0003	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0003	SELECT CategoryID FROM `Category` WHERE ParentID = 2472 AND Removed = 0
0.0002	SELECT * FROM (`Role_Group_User`) WHERE `RoleGroupID` IN (1, 2, 5) AND `UserID` = -1
0.0008	SELECT * FROM (`Collectible_Variation`)
0.0181	SELECT * FROM (`Collectible`) WHERE `Removed` = 0 AND `CategoryID` IN ('2472') AND `CollectibleID` IN ('234', '235', '236', '237', '239', '243', '245', '246', '247', '388', '251', '521', '634', '701', '788', '784', '1035', '1036', '1228', '1310', '1311', '1312', '1313', '1314', '1639', '1640', '1641', '1670', '1671', '1672', '1772', '1773', '1780', '1866', '2177', '2178', '2179', '2544', '2545', '2546', '2547', '2548', '2549', '2667', '2673', '2677', '2678', '2679', '2680', '2681', '2682', '2730', '2748', '2749', '2750', '2751', '2778', '2882', '2900', '2901', '2902', '2911', '2953', '2977', '2985', '2986', '2988', '2995', '3045', '3046', '3236', '3377', '3378', '3391', '3392', '3405', '3406', '3407', '3408', '3416', '3418', '3420', '3429', '3430', '3431', '3437', '3443', '3450', '3461', '3473', '3520', '3722', '3779', '3780', '3852', '3671', '4485', '4486', '4490', '4542', '4884', '4885', '4886', '4887', '4888', '4889', '4890', '4891', '4920', '4921', '4922', '4923', '4945', '4948', '4956', '4958', '4963', '4966', '5059', '5063', '5069', '5072', '5073', '5136', '5226', '5228', '5259', '5262', '5264', '5266', '5372', '5374', '5377', '5382', '5384', '5386', '5388', '5414', '5437', '11805', '11803', '5446', '5453', '5697', '5698', '5700', '5706', '5707', '5791', '5792', '5793', '5794', '5795', '5796', '5797', '5798', '5799', '5800', '5801', '5802', '5803', '5804', '5805', '5806', '5807', '5808', '5809', '5810', '5811', '5812', '5813', '5814', '5815', '5816', '5817', '5818', '5819', '5820', '5821', '5822', '5823', '5824', '5825', '5826', '5827', '5828', '5829', '5830', '5831', '5832', '5833', '5834', '5835', '5836', '5837', '5838', '5839', '5840', '5841', '5842', '5843', '5844', '5845', '5846', '5847', '5848', '5849', '5850', '5851', '5852', '5853', '5854', '5855', '5856', '5857', '5858', '5859', '5860', '5861', '5862', '5863', '5864', '5865', '5866', '5867', '5868', '5869', '5870', '5871', '5872', '5873', '5874', '5875', '5876', '5877', '5878', '5879', '5880', '5881', '5882', '5883', '5884', '5885', '5886', '5887', '5888', '5889', '5890', '5891', '5892', '5896', '5903', '5897', '5909', '5910', '5911', '5912', '5913', '5914', '5915', '5916', '5917', '5918', '5919', '5920', '5921', '5922', '5923', '5924', '5925', '6193', '6424', '6425', '6426', '6427', '6678', '6679', '6680', '6681', '6682', '6683', '6684', '6685', '6686', '6687', '6688', '6689', '6690', '6691', '6692', '6693', '6694', '6695', '6696', '6699', '6701', '6702', '6703', '6704', '6705', '6706', '6707', '6710', '6711', '6722', '6723', '6724', '6725', '13462', '13420', '13417', '6805', '7346', '7345', '7344', '7343', '7578', '7579', '7580', '7581', '7582', '7583', '7584', '7585', '7586', '7736', '7773', '7958', '7957', '7955', '7956', '7908', '8021', '8046', '8108', '8109', '8110', '8111', '8175', '8157', '8156', '8520', '8408', '8522', '8531', '8529', '8513', '8537', '8503', '8501', '8535', '8479', '8533', '8473', '8474', '8454', '8515', '8516', '8524', '8525', '8526', '8581', '8634', '8676', '8654', '8657', '8659', '8661', '8663', '8668', '8666', '8787', '8786', '8875', '8824', '8840', '8865', '8826', '8897', '8921', '8922', '8926', '8927', '8928', '8929', '8931', '8932', '8934', '8938', '8939', '4404', '8950', '8951', '8952', '8953', '8981', '8982', '8993', '9045', '9046', '9047', '9048', '9049', '9050', '9051', '9052', '9053', '9054', '9055', '9056', '9057', '9058', '9059', '9060', '9061', '9062', '9063', '9064', '9065', '9066', '9067', '9068', '9069', '9070', '9071', '9072', '9073', '9074', '9075', '9076', '9077', '9078', '9079', '9080', '9081', '9082', '9083', '9084', '9085', '9086', '9087', '9088', '9089', '9090', '9091', '9092', '9093', '9094', '9095', '9096', '9120', '9121', '8999', '9051', '9052', '8997', '9053', '9054', '8998', '9055', '9056', '9124', '9165', '9168', '9170', '9158', '9151', '9126', '9136', '9147', '9148', '9149', '9129', '9143', '9145', '9153', '9134', '9186', '9188', '9191', '9193', '9195', '9197', '9198', '9203', '9207', '9209', '9210', '9214', '9216', '9220', '9226', '9228', '9236', '9253', '9251', '9249', '9247', '9247', '9257', '9259', '9260', '9261', '9263', '9265', '9269', '9271', '9272', '9277', '9288', '9304', '9305', '9306', '9307', '9308', '9309', '9310', '9313', '9314', '9316', '9415', '9419', '9420', '9420', '9422', '9434', '9439', '9399', '9331', '9336', '9342', '9379', '9340', '9382', '9385', '9407', '9408', '9409', '9351', '9346', '9347', '9348', '9359', '9356', '9391', '9369', '9371', '9455', '9510', '9820', '9963', '9964', '9964', '9969', '9970', '9971', '9972', '10108', '10109', '10474', '10475', '10476', '10477', '10589', '10590', '10711', '10532', '10533', '10534', '10468', '10469', '10470', '10471', '10472', '10446', '10447', '10448', '10449', '10621', '10609', '10610', '10601', '10602', '10603', '10604', '10501', '10502', '10503', '10504', '10505', '10697', '10695', '10696', '10698', '10699', '10700', '10701', '10702', '10669', '10688', '10443', '10444', '10708', '10716', '10717', '10536', '10537', '10719', '10720', '10412', '10721', '10722', '10723', '10724', '10413', '10571', '10573', '10575', '10539', '10540', '10541', '10542', '10555', '10556', '10557', '10592', '10593', '10594', '10595', '10633', '10634', '10451', '10452', '10453', '10454', '10455', '10705', '10544', '10545', '10641', '10415', '10416', '10417', '10686', '10419', '10420', '10422', '10423', '10424', '10425', '10426', '10427', '10428', '10493', '10494', '10495', '10496', '10559', '10560', '10561', '10606', '10607', '10612', '10613', '10628', '10629', '10615', '10578', '10579', '10581', '10582', '10583', '10498', '10499', '10563', '10564', '10565', '10566', '10479', '10480', '10481', '10482', '10483', '10484', '10485', '10430', '10431', '10432', '10547', '10548', '10549', '10550', '10507', '10508', '10509', '10510', '10677', '10678', '10679', '10680', '10681', '10682', '10683', '10487', '10488', '10725', '10631', '10457', '10568', '10569', '10623', '10624', '10625', '10626', '10464', '10465', '10466', '10552', '10553', '10512', '10513', '10514', '10515', '10516', '10517', '10459', '10460', '10461', '10434', '10435', '10617', '10519', '10520', '10619', '10585', '10586', '10587', '10597', '10598', '10599', '10636', '10437', '10438', '10439', '10440', '10441', '10648', '10522', '10525', '10526', '10523', '10524', '10527', '10528', '10529', '10530', '10489', '10490', '10491', '10738', '10747', '11038', '11080', '11185', '11097', '11638', '9567', '11186', '11209', '11208', '11211', '11187', '11243', '11242', '9570', '9564', '11241', '11099', '11315', '11359', '11360', '11361', '11362', '11380', '7435', '11428', '11632', '10987', '8643', '8646', '8647', '7445', '8737', '8645', '7447', '11098', '11674', '11682', '2888', '2889', '11675', '8417', '3921', '8728', '3918', '11679', '11680', '11683', '11684', '11685', '11746', '11741', '11740', '11709', '11464', '11716', '11748', '11747', '11800', '11948', '11954', '11987', '11986', '11999', '12002', '12004', '12005', '12006', '12007', '12008', '12018', '12019', '12020', '12026', '12027', '12035', '12040', '12043', '12044', '12052', '12086', '12128', '12136', '12146', '12152', '12154', '12280', '12547', '12548', '12549', '12550', '12551', '12552', '12553', '12554', '12555', '12556', '12557', '12601', '12652', '12699', '12728', '12984', '12985', '13254', '13253', '16245', '16246', '13926', '13928', '13557', '13941', '14022', '14024', '14044', '13933', '13953', '13957', '13961', '14052', '14015', '14017', '13990', '14007', '13979', '14675', '14676', '14678', '14679', '14681', '14682', '14684', '14685', '14687', '14688', '14690', '14691', '14693', '14694', '14696', '14697', '14699', '14700', '14702', '14703', '14705', '14706', '14708', '14709', '14711', '14712', '14714', '14715', '14717', '14718', '14720', '14721', '14723', '14724', '14726', '14727', '14735', '14736', '14738', '14739', '14741', '14742', '14744', '14745', '14747', '14748', '14750', '14751', '14753', '14754', '14756', '14757', '14759', '14760', '14762', '14763', '14765', '14766', '14768', '14769', '14771', '14772', '14774', '14775', '14777', '14778', '14780', '14781', '14783', '14784', '14786', '14787', '14819', '14820', '14822', '14823', '14795', '14796', '14798', '14799', '14801', '14802', '14804', '14805', '14807', '14808', '14810', '14811', '14813', '14814', '14816', '14817', '14789', '14790', '14792', '14793', '14729', '14730', '14732', '14733', '14976', '14977', '14983', '15030', '15029', '15025', '15031', '15039', '15061', '15062', '15063', '15064', '15065', '15066', '15067', '15068', '15069', '15070', '15309', '15351', '15353', '16211', '16228', '16229', '16230', '16231', '16232', '16234', '16238', '16239', '16240', '16241', '16242', '16243', '16244', '13252', '6545', '16290', '16289', '16297', '16296', '16338', '16335', '16547', '16546', '16734', '1', '17032', '17034', '17035', '17036', '17037', '16804', '17328', '17330', '13884', '15342', '17339', '17339', '17262', '17341', '17342', '17343', '17346')
0.0004	SELECT * FROM (`Collectible`) WHERE `Removed` = 0 AND `CategoryID` IN ('2472') ORDER BY `CollectibleID` desc
0.8058	SELECT DISTINCT cs.* FROM `Collectible` AS cs, `Attribute` AS at, `Attribute_Value` AS atv WHERE cs.CategoryID IN ( 2472 ) AND cs.Removed = 0 AND atv.Removed = 0 AND cs.CollectibleID = atv.GenericID AND (at.Name = 'Name' OR at.Name = 'Title') AND atv.AttributeID = at.AttributeID ORDER BY atv.Value asc LIMIT 25
0.0003	SELECT GenericID FROM `Private` WHERE GenericType = "category" AND Removed = 0
0.0002	SELECT * FROM (`Category`) WHERE `CategoryID` = '2472' LIMIT 1
0.0003	SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2472' LIMIT 1
0.0004	SELECT * FROM (`Image`) WHERE `GenericID` = '7872' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
0.0008	`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 = 7872 ORDER BY a.Position, a.AttributeID ASC`
0.0004	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2472
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 365
0.0001	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 116
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 5
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 66
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 3
0.0002	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.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
0.0042	SELECT * FROM (`Review`) WHERE `GenericID` = '7872' AND `GenericType` = 'collectible'
0.0044	SELECT * FROM (`Review`) WHERE `GenericID` = '7872' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0032	SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '7872' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0007	SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '7872'
0.0006	SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 7872 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
0.0002	SELECT * FROM (`Category`) WHERE `CategoryID` = '2472' LIMIT 1
0.0002	SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2472' LIMIT 1
0.0004	SELECT * FROM (`Image`) WHERE `GenericID` = '7871' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
0.0007	`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 = 7871 ORDER BY a.Position, a.AttributeID ASC`
0.0002	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2472
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 365
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 116
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 5
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 66
0.0002	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.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
0.0043	SELECT * FROM (`Review`) WHERE `GenericID` = '7871' AND `GenericType` = 'collectible'
0.0043	SELECT * FROM (`Review`) WHERE `GenericID` = '7871' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0032	SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '7871' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0009	SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '7871'
0.0006	SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 7871 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
0.0002	SELECT * FROM (`Category`) WHERE `CategoryID` = '2472' LIMIT 1
0.0002	SELECT `Name` FROM (`Category`) WHERE `CategoryID` = '2472' LIMIT 1
0.0003	SELECT * FROM (`Image`) WHERE `GenericID` = '7870' AND `GenericType` = 'collectible' AND `MainImage` = 1 ORDER BY `ImageID` DESC
0.0007	`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 = 7870 ORDER BY a.Position, a.AttributeID ASC`
0.0003	SELECT * FROM (`User`) WHERE `UserID` = '37' LIMIT 1
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2472
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 365
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 116
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 5
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 66
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 3
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 98
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 2
0.0002	SELECT CP.CategoryID, CP.Name FROM `Category` CP INNER JOIN `Category` CC ON CP.CategoryID = CC.ParentID WHERE CC.CategoryID = 1
0.0042	SELECT * FROM (`Review`) WHERE `GenericID` = '7870' AND `GenericType` = 'collectible'
0.0043	SELECT * FROM (`Review`) WHERE `GenericID` = '7870' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0032	SELECT AVG(`Rating`) AS Rating FROM (`Review`) WHERE `GenericID` = '7870' AND `GenericType` = 'collectible' AND `Removed` = 0
0.0007	SELECT * FROM (`Collectible_Variation`) WHERE `Removed` = 0 AND `CollectibleID` = '7870'
0.0006	SELECT DISTINCT at.Name, atv.Value, at.Type FROM `Attribute` as at, `Attribute_Value` as atv WHERE atv.GenericType = 'collectible' AND atv.GenericID = 7870 AND atv.AttributeID = at.AttributeID AND at.Removed = 0
0.1497	`select Tag, count(TagID) as nrTags from Tag where GenericType = 'collectible' AND GenericID IN ( 2472, 0 ) and Tag != '' and Removed = 0 GROUP BY Tag ORDER BY nrTags DESC LIMIT 50`
0.0006	SELECT * FROM (`Attribute`) WHERE `Removed` = 0 AND `GenericType` = 'category' AND `GenericID` = '2472'
0.0002	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.0002	`select * from Notification_Filter`
0.0002	`select * from Notification`
0.0001	`select * from Notification`
0.0002	`select * from Zone`
0.0002	`select * from Zone`
0.0002	`select * from Zone`
0.0002	`select * from Zone`

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	as.collectionstation.com
REMOTE_ADDR	38.107.179.230
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

session_id	d7fecc19f88977c5ed259f9a02b8fd69
ip_address	38.107.179.230
user_agent	CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
last_activity	1337744714
category_id	2472

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 ) ) )

CATEGORY

FILTER BY

RECENTLY VIEWED

Category Managers

SPONSORED

Commemorative Episode IV DVD Collection (3)