Tables
From Komic Box Docs
Revision as of 18:52, 23 October 2018 by Gskluzacek (Talk | contribs) (added info on override_pvhl_id)
Contents
Table from Old Code base
previews_hdg_lvls
CREATE TABLE IF NOT EXISTS `previews_hdg_lvls` (
`pvhl_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`pvhl_level` tinyint(3) unsigned NOT NULL,
`parent_pvhl_id` bigint(20) unsigned DEFAULT NULL,
`pull_list_ind` varchar(1) DEFAULT NULL,
`heading_name` varchar(100) NOT NULL,
`updt_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`pvhl_id`),
UNIQUE KEY `pvhl_parent_name_unq` (`parent_pvhl_id`,`heading_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Previews Heading Levels' AUTO_INCREMENT=1788 ;
INSERT INTO `previews_hdg_lvls` (`pvhl_id`, `pvhl_level`, `parent_pvhl_id`, `pull_list_ind`, `heading_name`, `updt_dt`) VALUES (1, 1, NULL, NULL, 'APPAREL', '2013-03-17 18:02:43'), (2, 1, NULL, NULL, 'BOOKS & MAGAZINES', '2013-03-17 18:02:43'), (3, 1, NULL, NULL, 'COLLECTIBLES & NOVELTIES', '2013-03-17 18:02:43'), (4, 1, NULL, 'Y', 'COMICS', '2013-03-17 18:49:03'), (5, 1, NULL, NULL, 'DVDS & DIGITAL MEDIA', '2013-03-17 18:02:43'), (6, 1, NULL, NULL, 'GAMES', '2013-03-17 18:02:43'), (7, 1, NULL, NULL, 'IMPORT TOYS & MODELS', '2013-03-17 18:02:43'), (8, 1, NULL, 'Y', 'PREMIER PUBLISHERS', '2013-03-17 18:49:03'), (9, 1, NULL, NULL, 'PREVIEWS PUBLICATIONS', '2013-03-17 18:02:43'), (10, 1, NULL, NULL, 'STATUES & MODELS', '2013-03-17 18:02:43'), (11, 1, NULL, NULL, 'TOYS', '2013-03-17 18:02:43'), (12, 1, NULL, NULL, 'TRADING CARDS', '2013-03-17 18:02:43'), (13, 2, 8, 'Y', 'DARK HORSE', '2013-03-17 18:23:45'), (14, 2, 8, 'Y', 'DC COMICS', '2013-03-17 18:23:45'), (15, 2, 8, 'Y', 'IDW PUBLISHING', '2013-03-17 18:23:45'), (16, 2, 8, 'Y', 'IMAGE COMICS', '2013-03-17 18:23:45'), (17, 2, 8, 'Y', 'MARVEL COMICS', '2013-03-17 18:23:45'), (18, 2, 8, 'Y', 'DISNEY COMICS', '2013-03-17 18:23:45'),
previews_hdr
This table is loaded by the lf.php script (load file?)
pvh_id will AUTO_INCREMENT
The IDENT_STR column is populated from the first line in the file as follows
$ident = explode(' ', rtrim($line))
$ident_str = 'PREVIEWS VOL ' . str_pad($ident[3], 3, '0', STR_PAD_LEFT) . ' ' . str_pad($ident[4], 2, '0', STR_PAD_LEFT) . ' ' . substr($ident[1], 0, 3) . '-' . ($ident[3] + 2000 - 10);
the PERIOD_DT column is populated from the filename as follows
uses the MMMYY string to create a DD-MMM-YYYY string and then converts it to a string
Example file name AUG14_COF.txt
list($period_str) = explode('_', $file);
$period_dt = date('Y-m-01', strtotime('01-' . substr($period_str, 0, 3) . '-20' . substr($period_str, 3, 2)));
local file is set to the downloaded file name: e.g., AUG14_COF.txt
url_to_cof was set to NULL (future functionality to populate it).
proc_status defaulted to NEW
updt_dt defaulted to current date time
CREATE TABLE IF NOT EXISTS `previews_hdr` (
`pvh_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`period_dt` date NOT NULL,
`period_str` varchar(7) NOT NULL,
`ident_str` varchar(100) NOT NULL,
`local_file` varchar(50) DEFAULT NULL,
`url_to_cof` varchar(300) DEFAULT NULL,
`proc_status` enum('NEW','ERROR','PROCESSED','REPROCESS') NOT NULL DEFAULT 'NEW',
`updt_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`pvh_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=53 ;
INSERT INTO `previews_hdr` (`pvh_id`, `period_dt`, `period_str`, `ident_str`, `local_file`, `url_to_cof`, `proc_status`, `updt_dt`) VALUES (1, '2013-01-01', 'JAN09', 'PREVIEWS VOL 19 JAN-2009 #01', 'JAN09_COF.txt', NULL, 'PROCESSED', '2013-03-26 22:06:23'), (2, '2013-02-01', 'FEB09', 'PREVIEWS VOL 19 FEB-2009 #02', 'FEB09_COF.txt', NULL, 'PROCESSED', '2013-04-06 19:30:50'), (3, '2013-03-01', 'MAR09', 'PREVIEWS VOL 19 MAR-2009 #03', 'MAR09_COF.txt', NULL, 'PROCESSED', '2013-04-06 19:34:04'), (4, '2013-04-01', 'APR09', 'PREVIEWS VOL 19 APR-2009 #04', 'APR09_COF.txt', NULL, 'PROCESSED', '2013-03-26 22:06:23'), (5, '2013-05-01', 'MAY09', 'PREVIEWS VOL 19 MAY-2009 #05', 'MAY09_COF.txt', NULL, 'PROCESSED', '2013-03-26 22:06:23'), (6, '2013-06-01', 'JUN09', 'PREVIEWS VOL 19 JUN-2009 #06', 'JUN09_COF.txt', NULL, 'PROCESSED', '2013-03-26 22:06:23'), (7, '2013-07-01', 'JUL09', 'PREVIEWS VOL 19 JUL-2009 #07', 'JUL09_COF.txt', NULL, 'PROCESSED', '2013-03-26 22:06:23'), (8, '2013-08-01', 'AUG09', 'PREVIEWS VOL 19 AUG-2009 #08', 'AUG09_COF.txt', NULL, 'PROCESSED', '2013-03-26 22:06:23'),
previews_lines
also loaded from the lf.php script
pvl_id will AUTO_INCREMENT
pvh_id set to id from the previews_hdr insert (AUTO_INCREMENT)
pvl_seq set to a counter that is incremented in the while loop that reads the file
line_text set to the line read from the file (with fgets)
override_pvhl_id defaulted to NULL
updt_dt current time stamp
NOTES:
- if the override_pvhl_id is 0 then the pp.php script skips processing that line.
- if non-null and not zero, the heading level & name are looked up (on the pvhl_id)
- the columns: pv_type, hdg_1, h1_id, hdg_2, h2_id, hdg_3, h3_id are set based on the heading level
CREATE TABLE IF NOT EXISTS `previews_lines` (
`pvl_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`pvh_id` bigint(20) unsigned NOT NULL,
`pvl_seq` bigint(20) unsigned NOT NULL,
`line_text` varchar(2000) NOT NULL,
`override_pvhl_id` bigint(20) unsigned DEFAULT NULL,
`updt_dt` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`pvl_id`),
UNIQUE KEY `pvh_id_pvl_seq_unq` (`pvh_id`,`pvl_seq`),
KEY `pvh_id_ndx` (`pvl_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=139453 ;
INSERT INTO `previews_lines` (`pvl_id`, `pvh_id`, `pvl_seq`, `line_text`, `override_pvhl_id`, `updt_dt`) VALUES (1, 1, 1, 'PREVIEWS JAN VOL 19 #01\r\n', NULL, '0000-00-00 00:00:00'), (2, 1, 2, '\r\n', NULL, '0000-00-00 00:00:00'), (3, 1, 3, 'PAGE 30\r\n', NULL, '0000-00-00 00:00:00'), (4, 1, 4, 'PREVIEWS PUBLICATIONS\r\n', NULL, '0000-00-00 00:00:00'), (5, 1, 5, 'FREE COMIC BOOK DAY\r\n', NULL, '0000-00-00 00:00:00'), (6, 1, 6, ' JAN09 0047 FCBD 2009 ORANGE WRIST BAND (Net) (C: 1-0-0) 04/08/09 MSRP: $1.99 = $ \r\n', NULL, '0000-00-00 00:00:00'), (7, 1, 7, ' JAN09 0048 FCBD 2009 BLACK ADJUSTABLE LOGO HAT (Net) 04/08/09 MSRP: $12.99 = $ \r\n', NULL, '0000-00-00 00:00:00'), (8, 1, 8, 'PAGE 31\r\n', NULL, '0000-00-00 00:00:00'), (9, 1, 9, ' JAN09 0049 FCBD 2009 BLACK FCBD09 LOGO T-SHIRT SM (Net) 04/08/09 MSRP: $7.99 = $ \r\n', NULL, '0000-00-00 00:00:00'), (10, 1, 10, ' JAN09 0050 FCBD 2009 BLACK FCBD09 LOGO T-SHIRT MED (Net) 04/08/09 MSRP: $7.99 = $ \r\n', NULL, '0000-00-00 00:00:00'), (11, 1, 11, ' JAN09 0051 FCBD 2009 BLACK FCBD09 LOGO T-SHIRT LG (Net) 04/08/09 MSRP: $7.99 = $ \r\n', NULL, '0000-00-00 00:00:00'), (12, 1, 12, ' JAN09 0052 FCBD 2009 BLACK FCBD09 LOGO T-SHIRT XL (Net) 04/08/09 MSRP: $7.99 = $ \r\n', NULL, '0000-00-00 00:00:00'), (13, 1, 13, ' JAN09 0053 FCBD 2009 BLACK FCBD09 LOGO T-SHIRT XXL (Net) 04/08/09 MSRP: $9.99 = $ \r\n', NULL, '0000-00-00 00:00:00'), (14, 1, 14, ' JAN09 0054 FCBD 2009 BLACK FCBD09 LOGO T-SHIRT XXXL (Net) 04/08/09 MSRP: $9.99 = $ \r\n', NULL, '0000-00-00 00:00:00'), (15, 1, 15, ' JAN09 0055 FCBD 2009 HOODED SWEATSHIRT LG (Net) 04/08/09 MSRP: $24.99 = $ \r\n', NULL, '0000-00-00 00:00:00'),
previews_raw
CREATE TABLE IF NOT EXISTS `previews_raw` (
`pvr_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`pvh_id` bigint(20) unsigned NOT NULL,
`pv_seq` bigint(20) unsigned NOT NULL,
`pvl_id` bigint(20) unsigned DEFAULT NULL,
`pv_type` enum('BLANK','IDENT','PAGE','ITEM','H1','H2','H3','H4','NOTFOUND','UNKNOWN') NOT NULL,
`pv_value` varchar(100) DEFAULT NULL,
`h1_pvhl_id` bigint(20) unsigned DEFAULT NULL,
`h2_pvhl_id` bigint(20) unsigned DEFAULT NULL,
`h3_pvhl_id` bigint(20) unsigned DEFAULT NULL,
`pv_source` varchar(500) DEFAULT NULL,
`sol_page` int(11) DEFAULT NULL,
`sol_code` varchar(9) DEFAULT NULL,
`sol_text` varchar(150) DEFAULT NULL,
`release_dt` date DEFAULT NULL,
`unit_price` decimal(6,2) DEFAULT NULL,
`pi_ind` varchar(1) DEFAULT NULL,
`title` varchar(100) DEFAULT NULL,
`sub_title` varchar(100) DEFAULT NULL,
`title_vol` varchar(2) DEFAULT NULL,
`title_type` varchar(20) DEFAULT NULL,
`title_status` varchar(20) DEFAULT NULL,
`title_designations` varchar(100) DEFAULT NULL,
`book_type` varchar(20) DEFAULT NULL,
`book_vol` varchar(2) DEFAULT NULL,
`book_designations` varchar(100) DEFAULT NULL,
`issue_num` varchar(10) DEFAULT NULL,
`total_issues` varchar(2) DEFAULT NULL,
`printing` varchar(20) DEFAULT NULL,
`cover_variant` varchar(100) DEFAULT NULL,
`cover_type` varchar(20) DEFAULT NULL,
`advisory_code` varchar(20) DEFAULT NULL,
`caution_code` varchar(20) DEFAULT NULL,
`sol_info_codes` varchar(20) DEFAULT NULL,
`prev_sol_code` varchar(20) DEFAULT NULL,
`edition` varchar(100) DEFAULT NULL,
`other_designations` varchar(100) DEFAULT NULL,
`updt_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`pvr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1123424 ;
INSERT INTO `previews_raw` (`pvr_id`, `pvh_id`, `pv_seq`, `pvl_id`, `pv_type`, `pv_value`, `h1_pvhl_id`, `h2_pvhl_id`, `h3_pvhl_id`, `pv_source`, `sol_page`, `sol_code`, `sol_text`, `release_dt`, `unit_price`, `pi_ind`, `title`, `sub_title`, `title_vol`, `title_type`, `title_status`, `title_designations`, `book_type`, `book_vol`, `book_designations`, `issue_num`, `total_issues`, `printing`, `cover_variant`, `cover_type`, `advisory_code`, `caution_code`, `sol_info_codes`, `prev_sol_code`, `edition`, `other_designations`, `updt_dt`) VALUES (1, 1, 1, 1, 'IDENT', 'PREVIEWS JAN VOL 19 #01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (2, 1, 2, 2, 'BLANK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (3, 1, 3, 3, 'PAGE', 'PAGE 30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (4, 1, 4, 4, 'H1', 'PREVIEWS PUBLICATIONS', 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (5, 1, 5, 5, 'H2', 'FREE COMIC BOOK DAY', 9, 237, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (6, 1, 6, 6, 'ITEM', NULL, 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 30, 'JAN090047', 'FCBD 2009 ORANGE WRIST BAND (Net) (C: 1-0-0)', '2009-04-08', '1.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (7, 1, 7, 7, 'ITEM', NULL, 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 30, 'JAN090048', 'FCBD 2009 BLACK ADJUSTABLE LOGO HAT (Net)', '2009-04-08', '12.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (8, 1, 8, 8, 'PAGE', 'PAGE 31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (9, 1, 9, 9, 'ITEM', NULL, 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 31, 'JAN090049', 'FCBD 2009 BLACK FCBD09 LOGO T-SHIRT SM (Net)', '2009-04-08', '7.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (10, 1, 10, 10, 'ITEM', NULL, 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 31, 'JAN090050', 'FCBD 2009 BLACK FCBD09 LOGO T-SHIRT MED (Net)', '2009-04-08', '7.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (11, 1, 11, 11, 'ITEM', NULL, 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 31, 'JAN090051', 'FCBD 2009 BLACK FCBD09 LOGO T-SHIRT LG (Net)', '2009-04-08', '7.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (12, 1, 12, 12, 'ITEM', NULL, 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 31, 'JAN090052', 'FCBD 2009 BLACK FCBD09 LOGO T-SHIRT XL (Net)', '2009-04-08', '7.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (13, 1, 13, 13, 'ITEM', NULL, 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 31, 'JAN090053', 'FCBD 2009 BLACK FCBD09 LOGO T-SHIRT XXL (Net)', '2009-04-08', '9.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (14, 1, 14, 14, 'ITEM', NULL, 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 31, 'JAN090054', 'FCBD 2009 BLACK FCBD09 LOGO T-SHIRT XXXL (Net)', '2009-04-08', '9.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (15, 1, 15, 15, 'ITEM', NULL, 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 31, 'JAN090055', 'FCBD 2009 HOODED SWEATSHIRT LG (Net)', '2009-04-08', '24.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (16, 1, 16, 16, 'ITEM', NULL, 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 31, 'JAN090056', 'FCBD 2009 HOODED SWEATSHIRT XL (Net)', '2009-04-08', '24.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (17, 1, 17, 17, 'ITEM', NULL, 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 31, 'JAN090057', 'FCBD 2009 HOODED SWEATSHIRT XXL (Net)', '2009-04-08', '27.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (18, 1, 18, 18, 'ITEM', NULL, 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 31, 'JAN090058', 'FCBD 2009 BLACK POLO LOGO SHORT SLEEVE SHIRT SM (Net)', '2009-04-08', '24.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (19, 1, 19, 19, 'ITEM', NULL, 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 31, 'JAN090059', 'FCBD 2009 BLACK POLO LOGO SHORT SLEEVE SHIRT MED (Net)', '2009-04-08', '24.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (20, 1, 20, 20, 'ITEM', NULL, 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 31, 'JAN090060', 'FCBD 2009 BLACK POLO LOGO SHORT SLEEVE SHIRT LG (Net)', '2009-04-08', '24.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (21, 1, 21, 21, 'ITEM', NULL, 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 31, 'JAN090061', 'FCBD 2009 BLACK POLO LOGO SHORT SLEEVE SHIRT XL (Net)', '2009-04-08', '24.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (22, 1, 22, 22, 'ITEM', NULL, 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 31, 'JAN090062', 'FCBD 2009 BLACK POLO LOGO SHORT SLEEVE SHIRT XXL (Net)', '2009-04-08', '27.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (23, 1, 23, 23, 'ITEM', NULL, 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 31, 'JAN090063', 'FCBD 2009 BLACK POLO LOGO SHORT SLEEVE SHIRT XXXL (Net)', '2009-04-08', '27.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (24, 1, 24, 24, 'PAGE', 'PAGE 32', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (25, 1, 25, 25, 'ITEM', 'SPOT', 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 32, 'JAN090064', 'PREVIEWS #246 MARCH 2009 (Net)', '2009-02-25', '4.50', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (26, 1, 26, 26, 'ITEM', 'SPOT', 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 32, 'JAN090065', 'MARVEL PREVIEWS MARCH 2009 EXTRAS (Net)', '2009-02-25', '1.25', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (27, 1, 27, 27, 'ITEM', 'SPOT', 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 32, 'JAN090066', 'PREVIEWS #246 MARCH 2009 CUSTOMER ORDER FORM (Net)', '2009-02-25', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (28, 1, 28, 28, 'ITEM', NULL, 9, 237, NULL, 'PREVIEWS PUBLICATIONS / FREE COMIC BOOK DAY', 32, 'JAN090068', 'PREVIEWS ADULT #246 MARCH 2009 (Net)', '2009-02-25', '0.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (29, 1, 29, 29, 'PAGE', 'PAGE 36', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (30, 1, 30, 30, 'H1', 'PREMIER PUBLISHERS', 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (31, 1, 31, 31, 'H2', 'DARK HORSE', 8, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (32, 1, 32, 32, 'ITEM', 'GEM', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 36, 'JAN090073', 'APPLEGEEKS TP VOL 01 FRESHMAN YEAR (C: 0-1-2)', '2009-05-27', '14.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (33, 1, 33, 33, 'PAGE', 'PAGE 37', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (34, 1, 34, 34, 'ITEM', NULL, 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 37, 'JAN090074', 'ACHEWOOD HC VOL 02 WORST SONG PLAYED (C: 0-1-2)', '2009-05-20', '14.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (35, 1, 35, 35, 'PAGE', 'PAGE 38', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (36, 1, 36, 36, 'ITEM', NULL, 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 38, 'JAN090075', 'WONDERMARK TP VOL 02 CLEVER TRICKS STAVE DEATH (C: 0-1-2)', '2009-05-06', '14.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (37, 1, 37, 37, 'PAGE', 'PAGE 39', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (38, 1, 38, 38, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 39, 'JAN090076', 'ACHEWOOD HC VOL 01 GREAT OUTDOOR FIGHT (MAY080062)', '2009-02-18', '14.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (39, 1, 39, 39, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 39, 'JAN090077', 'COMPLETE K CHRONICLES TP (MAR080037)', '2009-02-18', '24.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (40, 1, 40, 40, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 39, 'JAN090078', 'HELP IS ON THE WAY TP (APR080064)', '2009-02-18', '9.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (41, 1, 41, 41, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 39, 'JAN090079', 'MEGATOKYO TP VOL 01 (DEC030059)', '2009-02-18', '9.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (42, 1, 42, 42, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 39, 'JAN090080', 'PENNY ARCADE TP VOL 01 ATTACK OF THE BACON ROBOTS (SEP050024)', '2009-02-18', '12.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (43, 1, 43, 43, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 39, 'JAN090081', 'PENNY ARCADE TP VOL 02 LEGENDS MAGIC SWORD (APR060022)', '2009-02-18', '12.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (44, 1, 44, 44, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 39, 'JAN090082', 'RED STRING TP VOL 01 (SEP060038)', '2009-02-18', '9.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (45, 1, 45, 45, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 39, 'JAN090083', 'WONDERMARK TP VOL 01 BEARDS OF OUR FOREFATHERS (MAR080039)', '2009-02-18', '14.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (46, 1, 46, 46, 'PAGE', 'PAGE 40', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (47, 1, 47, 47, 'ITEM', 'GEM', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 40, 'JAN090084', 'AMAZON #1 (OF 3)', '2009-03-11', '3.50', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (48, 1, 48, 48, 'PAGE', 'PAGE 41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (49, 1, 49, 49, 'ITEM', 'SPOT', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 41, 'JAN090085', 'BORIS KARLOFF TALES OF MYSTERY ARCHIVES HC VOL 01 (C: 0-1-2)', '2009-05-13', '49.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (50, 1, 50, 50, 'PAGE', 'PAGE 42', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (51, 1, 51, 51, 'ITEM', NULL, 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 42, 'JAN090086', 'CONAN THE CIMMERIAN #9', '2009-03-18', '2.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (52, 1, 52, 52, 'PAGE', 'PAGE 43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (53, 1, 53, 53, 'ITEM', NULL, 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 43, 'JAN090087', 'KULL #5 (OF 6)', '2009-03-04', '2.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (54, 1, 54, 54, 'PAGE', 'PAGE 44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (55, 1, 55, 55, 'ITEM', 'SPOT', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 44, 'JAN090088', 'FRANK MILLER THE SPIRIT STORYBOARDS HC (C: 0-1-2)', '2009-05-06', '49.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (56, 1, 56, 56, 'PAGE', 'PAGE 45', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (57, 1, 57, 57, 'ITEM', 'SPOT', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 45, 'JAN090089', 'WILL EISNERS SPIRIT ARCHIVES HC VOL 01 NEW ADV (C: 0-1-2)', '2009-05-20', '49.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (58, 1, 58, 58, 'PAGE', 'PAGE 46', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (59, 1, 59, 59, 'ITEM', NULL, 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 46, 'JAN090090', 'GIGANTIC #5 (OF 5)', '2009-03-25', '3.50', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (60, 1, 60, 60, 'ITEM', NULL, 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 46, 'JAN090091', 'MISTER X CONDEMNED #4 (OF 4)', '2009-03-25', '3.50', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (61, 1, 61, 61, 'PAGE', 'PAGE 47', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (62, 1, 62, 62, 'ITEM', NULL, 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 47, 'JAN090092', 'TARZAN THE JESSE MARSH YEARS HC VOL 01 (C: 0-1-2)', '2009-02-25', '49.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (63, 1, 63, 63, 'ITEM', NULL, 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 47, 'JAN090093', 'TARZAN THE JESSE MARSH YEARS HC VOL 02 (C: 0-1-2)', '2009-05-20', '49.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (64, 1, 64, 64, 'PAGE', 'PAGE 48', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (65, 1, 65, 65, 'ITEM', NULL, 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 48, 'JAN090094', 'LITTLE LULU TP VOL 19 ALAMO & OTHER STORIES (C: 0-1-2)', '2009-05-13', '14.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (66, 1, 66, 66, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 48, 'JAN090095', 'LITTLE LULU TP VOL 14 QUEEN LULU (OCT060029)', '2009-02-18', '9.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (67, 1, 67, 67, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 48, 'JAN090096', 'LITTLE LULU TP VOL 15 THE EXPLORERS (DEC060038)', '2009-02-18', '9.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (68, 1, 68, 68, 'ITEM', 'OA', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 48, 'JAN090097', 'LITTLE LULU TP VOL 16 A HANDY KID (O/A)', '2009-03-25', '10.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (69, 1, 69, 69, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 48, 'JAN090098', 'LITTLE LULU TP VOL 17 THE VALENTINE (JUN070034)', '2009-02-18', '10.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (70, 1, 70, 70, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 48, 'JAN090099', 'LITTLE LULU TP VOL 18 THE EXPERT (SEP070039)', '2009-02-18', '10.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (71, 1, 71, 71, 'ITEM', 'OA', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 48, 'JAN090100', 'LITTLE LULU COLOR SPECIAL TP (O/A)', '2009-03-25', '13.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (72, 1, 72, 72, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 48, 'JAN090101', 'LITTLE LULU VINYL FIGURE (JUN070110)', '2009-02-18', '14.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (73, 1, 73, 73, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 48, 'JAN090102', 'TUBBY VINYL FIGURE (JUN070124)', '2009-02-18', '14.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (74, 1, 74, 74, 'PAGE', 'PAGE 49', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (75, 1, 75, 75, 'ITEM', NULL, 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 49, 'JAN090103', 'USAGI YOJIMBO #119', '2009-03-25', '3.50', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (76, 1, 76, 76, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 49, 'JAN090104', 'USAGI YOJIMBO TP VOL 22 TOMOES STORY (MAR080031)', '2009-02-18', '15.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (77, 1, 77, 77, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 49, 'JAN090105', 'USAGI YOJIMBO TP VOL 21 MOTHER OF MOUNTAINS (MAR070065)', '2009-02-18', '15.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (78, 1, 78, 78, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 49, 'JAN090106', 'USAGI YOJIMBO TP VOL 20 GLIMPSES OF DEATH (APR060027)', '2009-02-18', '15.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (79, 1, 79, 79, 'ITEM', 'OA', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 49, 'JAN090107', 'USAGI YOJIMBO TP VOL 19 FATHERS AND SONS (O/A)', '2009-03-25', '15.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (80, 1, 80, 80, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 49, 'JAN090108', 'USAGI YOJIMBO VINYL FIGURE (JUN070125)', '2009-02-18', '19.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (81, 1, 81, 81, 'PAGE', 'PAGE 50', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (82, 1, 82, 82, 'ITEM', NULL, 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 50, 'JAN090109', 'UMBRELLA ACADEMY DALLAS #5 (OF 6)', '2009-03-25', '2.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (83, 1, 83, 83, 'PAGE', 'PAGE 51', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (84, 1, 84, 84, 'ITEM', NULL, 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 51, 'JAN090110', 'BPRD BLACK GODDESS #3 (OF 5)', '2009-03-11', '2.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (85, 1, 85, 85, 'ITEM', NULL, 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 51, 'JAN090111', 'BPRD TP VOL 10 THE WARNING (C: 0-1-2)', '2009-05-06', '17.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (86, 1, 86, 86, 'PAGE', 'PAGE 52', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (87, 1, 87, 87, 'ITEM', NULL, 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 52, 'JAN090112', 'HELLBOY WILD HUNT #4 (OF 8)', '2009-03-04', '2.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (88, 1, 88, 88, 'PAGE', 'PAGE 53', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (89, 1, 89, 89, 'ITEM', NULL, 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 53, 'JAN090113', 'CLEANERS #3 (OF 4)', '2009-03-11', '2.99', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (90, 1, 90, 90, 'PAGE', 'PAGE 54', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (91, 1, 91, 91, 'ITEM', 'SPOT', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 54, 'JAN090114', 'BTVS SEASON 8 TP VOL 04 TIME OF YOUR LIFE (C: 0-1-2)', '2009-05-06', '15.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (92, 1, 92, 92, 'PAGE', 'PAGE 55', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (93, 1, 93, 93, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 55, 'JAN090115', 'BTVS AUTUMNAL TP (STAR14936) (C: 1-0-0)', '2009-02-18', '9.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (94, 1, 94, 94, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 55, 'JAN090116', 'BTVS BAD BLOOD TP (STAR11048) (C: 1-0-0)', '2009-02-18', '9.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (95, 1, 95, 95, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 55, 'JAN090117', 'BTVS CRASH TEST DEMONS TP (STAR11415) (C: 1-0-0)', '2009-02-18', '9.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (96, 1, 96, 96, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 55, 'JAN090118', 'BTVS DUST WALTZ TP (STAR08424) (C: 1-0-0)', '2009-02-18', '9.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (97, 1, 97, 97, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 55, 'JAN090119', 'BTVS OUT OF THE WOODWORK TP (STAR15560) (C: 1-0-0)', '2009-02-18', '12.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (98, 1, 98, 98, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 55, 'JAN090120', 'BTVS PALE REFLECTIONS TP (STAR12027) (MR) (C: 1-0-0)', '2009-02-18', '9.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (99, 1, 99, 99, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 55, 'JAN090121', 'BTVS PAST LIVES TP (STAR14727) (C: 1-0-0)', '2009-02-18', '12.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'), (100, 1, 100, 100, 'ITEM', 'SS', 8, 13, NULL, 'PREMIER PUBLISHERS / DARK HORSE', 55, 'JAN090122', 'BTVS RING OF FIRE GN (STAR11743) (C: 1-0-0)', '2009-02-18', '9.95', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-03-26 21:35:10'),
