Skip to content

Instantly share code, notes, and snippets.

@absent1706

absent1706/db.sql

Last active October 18, 2016 15:22
Show Gist options
  • Save absent1706/b534d42b37e61ac400cb3d8c5e9d9709 to your computer and use it in GitHub Desktop.
Save absent1706/b534d42b37e61ac400cb3d8c5e9d9709 to your computer and use it in GitHub Desktop.
Download ZIP
Select products with grade order between grade_from and grade_to ( grade_from_id and grade_to_id can be nulls)
Raw
db.sql
-- --------------------------------------------------------
-- Host: 127.0.0.1
-- Server version: 10.1.8-MariaDB - mariadb.org binary distribution
-- Server OS: Win32
-- HeidiSQL Version: 9.3.0.4984
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-- Dumping structure for table knowstory.grade
DROP TABLE IF EXISTS `grade`;
CREATE TABLE IF NOT EXISTS `grade` (
`grade_id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT NULL,
`standard_name` varchar(10) DEFAULT NULL,
`order` smallint(6) DEFAULT NULL,
PRIMARY KEY (`grade_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
-- Dumping data for table knowstory.grade: ~15 rows (approximately)
/*!40000 ALTER TABLE `grade` DISABLE KEYS */;
INSERT INTO `grade` (`grade_id`, `name`, `standard_name`, `order`) VALUES
(1, 'Preschool', NULL, 1),
(2, 'Kindergarten', 'K', 2),
(3, '1', '1', 3),
(4, '2', '2', 4),
(5, '3', '3', 5),
(6, '4', '4', 6),
(7, '5', '5', 7),
(8, '6', '6', 8),
(9, '7', '7', 9),
(10, '8', '8', 10),
(11, '9', '9', 11),
(12, '10', '10', 12),
(13, '11', '11', 13),
(14, '12', '12', 14),
(15, 'Higher Education', NULL, 15);
/*!40000 ALTER TABLE `grade` ENABLE KEYS */;
-- Dumping structure for table knowstory.product
DROP TABLE IF EXISTS `product`;
CREATE TABLE IF NOT EXISTS `product` (
`product_id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) DEFAULT NULL,
`company_id` bigint(20) DEFAULT NULL,
`name` varchar(300) DEFAULT NULL,
`url` varchar(2048) DEFAULT NULL,
`tagline` varchar(200) DEFAULT NULL,
`topic` varchar(300) DEFAULT NULL,
`age_from` smallint(6) DEFAULT NULL,
`age_to` smallint(6) DEFAULT NULL,
`author_name` varchar(100) DEFAULT NULL,
`description` varchar(8192) DEFAULT NULL,
`sell_product` tinyint(1) DEFAULT NULL,
`price` float DEFAULT NULL,
`grade_from_id` bigint(20) DEFAULT NULL,
`grade_to_id` bigint(20) DEFAULT NULL,
`pricing_model_id` bigint(20) DEFAULT NULL,
`integration_compliance_id` bigint(20) DEFAULT NULL,
`target_market_id` bigint(20) DEFAULT NULL,
`public` tinyint(1) DEFAULT NULL,
`completed` tinyint(1) DEFAULT NULL,
`archived` tinyint(1) DEFAULT NULL,
`avg_rating` float DEFAULT NULL,
`avg_ease_of_use` float DEFAULT NULL,
`avg_fit_to_standards` float DEFAULT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`company_name` varchar(200) DEFAULT NULL,
`concept_average_time` int(11) DEFAULT NULL,
`concepts_number` int(11) DEFAULT NULL,
`group_id` bigint(20) DEFAULT NULL,
`object_time_used` int(11) DEFAULT NULL,
`optionality` smallint(6) DEFAULT NULL,
`product_type` smallint(6) NOT NULL,
`subscriptions_number` int(11) DEFAULT NULL,
`version` varchar(100) DEFAULT NULL,
PRIMARY KEY (`product_id`),
KEY `fk_product_company_id_company` (`company_id`),
KEY `fk_product_grade_from_id_grade` (`grade_from_id`),
KEY `fk_product_grade_to_id_grade` (`grade_to_id`),
KEY `fk_product_integration_compliance_id_integration_compliance` (`integration_compliance_id`),
KEY `fk_product_pricing_model_id_pricing_model` (`pricing_model_id`),
KEY `fk_product_target_market_id_target_market` (`target_market_id`),
KEY `fk_product_user_id_user` (`user_id`),
KEY `fk_product_group_id_group` (`group_id`),
FULLTEXT KEY `product_name` (`name`),
CONSTRAINT `fk_product_company_id_company` FOREIGN KEY (`company_id`) REFERENCES `company` (`company_id`),
CONSTRAINT `fk_product_grade_from_id_grade` FOREIGN KEY (`grade_from_id`) REFERENCES `grade` (`grade_id`),
CONSTRAINT `fk_product_grade_to_id_grade` FOREIGN KEY (`grade_to_id`) REFERENCES `grade` (`grade_id`),
CONSTRAINT `fk_product_group_id_group` FOREIGN KEY (`group_id`) REFERENCES `group` (`group_id`),
CONSTRAINT `fk_product_integration_compliance_id_integration_compliance` FOREIGN KEY (`integration_compliance_id`) REFERENCES `integration_compliance` (`integration_compliance_id`),
CONSTRAINT `fk_product_pricing_model_id_pricing_model` FOREIGN KEY (`pricing_model_id`) REFERENCES `pricing_model` (`pricing_model_id`),
CONSTRAINT `fk_product_target_market_id_target_market` FOREIGN KEY (`target_market_id`) REFERENCES `target_market` (`target_market_id`),
CONSTRAINT `fk_product_user_id_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=183 DEFAULT CHARSET=latin1;
-- Dumping data for table knowstory.product: ~182 rows (approximately)
/*!40000 ALTER TABLE `product` DISABLE KEYS */;
INSERT INTO `product` (`product_id`, `user_id`, `company_id`, `name`, `url`, `tagline`, `topic`, `age_from`, `age_to`, `author_name`, `description`, `sell_product`, `price`, `grade_from_id`, `grade_to_id`, `pricing_model_id`, `integration_compliance_id`, `target_market_id`, `public`, `completed`, `archived`, `avg_rating`, `avg_ease_of_use`, `avg_fit_to_standards`, `created`, `modified`, `company_name`, `concept_average_time`, `concepts_number`, `group_id`, `object_time_used`, `optionality`, `product_type`, `subscriptions_number`, `version`) VALUES
(1, 1, NULL, 'Something 0', NULL, NULL, NULL, 3, 17, '', NULL, NULL, 96.23, NULL, NULL, 6, NULL, NULL, 1, 1, 0, 3.5, 3.9, 4.2, '2016-10-17 06:47:36', '2016-10-17 06:47:36', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(2, 11, NULL, 'Something 1', NULL, NULL, NULL, 9, 9, '', NULL, NULL, 85.93, 5, NULL, 9, NULL, NULL, 1, 1, 0, 4, 3.8, 3.7, '2016-10-17 06:47:38', '2016-10-17 06:47:38', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(3, 24, NULL, 'Test Product 2', NULL, NULL, NULL, 10, 21, '', NULL, NULL, 78.02, 12, NULL, 9, NULL, NULL, 1, 1, 0, 4.1, 3.5, 3.8, '2016-10-17 06:47:39', '2016-10-17 06:47:39', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(4, 39, NULL, 'Something 3', NULL, NULL, NULL, 6, 13, '', NULL, NULL, 10.31, 10, 13, 8, NULL, NULL, 1, 1, 0, 3.9, 4, 3.6, '2016-10-17 06:47:39', '2016-10-17 06:47:39', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(5, 50, NULL, 'The Best Book # 4', NULL, NULL, NULL, 6, 17, 'Arthur Benjamin', NULL, NULL, 50.51, 7, 12, 3, NULL, NULL, 1, 1, 0, 4.1, 3.8, 3.9, '2016-10-17 06:47:40', '2016-10-17 06:47:40', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(6, 59, NULL, 'Test Product 5', NULL, NULL, NULL, 2, 21, 'Arthur Benjamin', NULL, NULL, 18.3, 9, 12, 3, NULL, NULL, 1, 1, 0, 4, 4.1, 4.2, '2016-10-17 06:47:40', '2016-10-17 06:47:40', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(7, 62, NULL, 'The Best Book # 6', NULL, NULL, NULL, 5, 7, '', NULL, NULL, 57.67, 8, 13, 7, NULL, NULL, 1, 1, 0, 3.9, 4, 4.2, '2016-10-17 06:47:40', '2016-10-17 06:47:41', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(8, 74, NULL, 'The Best Book # 7', NULL, NULL, NULL, 0, 20, '', NULL, NULL, 56.55, 9, 12, 5, NULL, NULL, 1, 1, 0, 3.6, 3.9, 3.7, '2016-10-17 06:47:41', '2016-10-17 06:47:41', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(9, 88, NULL, 'Something 8', NULL, NULL, NULL, 0, 20, NULL, NULL, NULL, 15.27, 10, 14, 2, NULL, NULL, 1, 1, 0, 4.3, 4.4, 4.2, '2016-10-17 06:47:41', '2016-10-17 06:47:41', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(10, 92, NULL, 'Test Product 9', NULL, NULL, NULL, 2, 8, 'Arthur Benjamin', NULL, NULL, 83.94, 2, 9, 4, NULL, NULL, 1, 1, 0, 4.1, 3.7, 3.5, '2016-10-17 06:47:42', '2016-10-17 06:47:42', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(11, 107, NULL, 'Test Product 10', NULL, NULL, NULL, 2, 3, 'John Smith', NULL, NULL, 26.1, 2, 13, 1, NULL, NULL, 1, 1, 0, 3.9, 3.6, 4.5, '2016-10-17 06:47:42', '2016-10-17 06:47:42', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(12, 120, NULL, 'The Best Book # 11', NULL, NULL, NULL, 6, 10, '', NULL, NULL, 34.18, 1, 8, 1, NULL, NULL, 1, 1, 0, 3.9, 4, 3.6, '2016-10-17 06:47:43', '2016-10-17 06:47:43', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(13, 127, NULL, 'The Best Book # 12', NULL, NULL, NULL, 1, 11, NULL, NULL, NULL, 83.09, 5, 7, 10, NULL, NULL, 1, 1, 0, 3.9, 3.8, 3.8, '2016-10-17 06:47:43', '2016-10-17 06:47:43', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(14, 134, NULL, 'Test Product 13', NULL, NULL, NULL, 4, 9, 'Arthur Benjamin', NULL, NULL, 20.93, 5, 10, 7, NULL, NULL, 1, 1, 0, 4, 3.9, 4.2, '2016-10-17 06:47:44', '2016-10-17 06:47:44', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(15, 141, NULL, 'Test Product 14', NULL, NULL, NULL, 0, 4, NULL, NULL, NULL, 55.57, 4, 12, 8, NULL, NULL, 1, 1, 0, 3.9, 3.7, 3.7, '2016-10-17 06:47:44', '2016-10-17 06:47:45', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(16, 152, NULL, 'Test Product 15', NULL, NULL, NULL, 11, 14, 'Arthur Benjamin', NULL, NULL, 26.67, 7, 8, 2, NULL, NULL, 1, 1, 0, 3.9, 3.8, 4.1, '2016-10-17 06:47:45', '2016-10-17 06:47:45', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(17, 164, NULL, 'Something 16', NULL, NULL, NULL, 13, 16, '', NULL, NULL, 20.25, 13, 13, 7, NULL, NULL, 1, 1, 0, 4.1, 3.8, 4.2, '2016-10-17 06:47:46', '2016-10-17 06:47:46', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(18, 180, NULL, 'The Best Book # 17', NULL, NULL, NULL, 3, 18, 'Arthur Benjamin', NULL, NULL, 46.74, 12, 12, 6, NULL, NULL, 1, 1, 0, 4.6, 3.9, 4.1, '2016-10-17 06:47:46', '2016-10-17 06:47:46', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(19, 184, NULL, 'The Best Book # 18', NULL, NULL, NULL, 15, 15, 'Arthur Benjamin', NULL, NULL, 24.74, 7, 13, 1, NULL, NULL, 1, 1, 0, 4, 4, 3.6, '2016-10-17 06:47:47', '2016-10-17 06:47:47', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(20, 199, NULL, 'Something 19', NULL, NULL, NULL, 9, 14, 'Arthur Benjamin', NULL, NULL, 47.92, 2, 11, 4, NULL, NULL, 1, 1, 0, 4.1, 4.4, 4.1, '2016-10-17 06:47:47', '2016-10-17 06:47:47', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(21, 210, NULL, 'Test Product 20', NULL, NULL, NULL, 2, 15, 'Arthur Benjamin', NULL, NULL, 4.79, 5, 7, 6, NULL, NULL, 1, 1, 0, 3.6, 4.7, 3.8, '2016-10-17 06:47:48', '2016-10-17 06:47:48', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(22, 219, NULL, 'Test Product 21', NULL, NULL, NULL, 8, 20, NULL, NULL, NULL, 30.64, 6, 9, 4, NULL, NULL, 1, 1, 0, 4.5, 3.4, 3.8, '2016-10-17 06:47:48', '2016-10-17 06:47:48', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(23, 226, NULL, 'Test Product 22', NULL, NULL, NULL, 17, 21, '', NULL, NULL, 80.31, 9, 13, 3, NULL, NULL, 1, 1, 0, 3.5, 4, 4.2, '2016-10-17 06:47:49', '2016-10-17 06:47:49', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(24, 233, NULL, 'Test Product 23', NULL, NULL, NULL, 9, 17, NULL, NULL, NULL, 22.02, 13, 15, 5, NULL, NULL, 1, 1, 0, 4.4, 4.3, 4, '2016-10-17 06:47:49', '2016-10-17 06:47:49', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(25, 248, NULL, 'Something 24', NULL, NULL, NULL, 7, 12, 'Arthur Benjamin', NULL, NULL, 67.95, 1, 12, 1, NULL, NULL, 1, 1, 0, 4.1, 3.5, 4, '2016-10-17 06:47:50', '2016-10-17 06:47:50', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(26, 257, NULL, 'Test Product 25', NULL, NULL, NULL, 1, 6, '', NULL, NULL, 77.25, 1, 13, 6, NULL, NULL, 1, 1, 0, 3.9, 3.8, 4, '2016-10-17 06:47:50', '2016-10-17 06:47:50', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(27, 270, NULL, 'The Best Book # 26', NULL, NULL, NULL, 9, 17, NULL, NULL, NULL, 46.03, 2, 12, 4, NULL, NULL, 1, 1, 0, 4.3, 4.2, 3.6, '2016-10-17 06:47:50', '2016-10-17 06:47:50', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(28, 275, NULL, 'The Best Book # 27', NULL, NULL, NULL, 2, 7, 'John Smith', NULL, NULL, 33.54, 2, 3, 2, NULL, NULL, 1, 1, 0, 3.8, 4, 4.4, '2016-10-17 06:47:51', '2016-10-17 06:47:51', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(29, 283, NULL, 'Something 28', NULL, NULL, NULL, 8, 12, NULL, NULL, NULL, 14.35, 6, 13, 5, NULL, NULL, 1, 1, 0, 4.2, 4.3, 3.9, '2016-10-17 06:47:51', '2016-10-17 06:47:51', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(30, 297, NULL, 'Something 29', NULL, NULL, NULL, 1, 4, '', NULL, NULL, 29.24, 4, 8, 10, NULL, NULL, 1, 1, 0, 4, 4, 4.3, '2016-10-17 06:47:52', '2016-10-17 06:47:52', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(31, 328, NULL, 'Invenstory Group Product 1', NULL, NULL, NULL, 1, 7, NULL, NULL, NULL, 73.97, 4, 11, 4, NULL, NULL, 1, 1, 0, 3.9, 3.9, 4.2, '2016-10-17 06:47:53', '2016-10-17 06:47:53', NULL, 0, 0, 1600, 0, NULL, 2, 0, NULL),
(32, 337, NULL, 'Invenstory Group Product 2', NULL, NULL, NULL, 2, 11, 'Arthur Benjamin', NULL, NULL, 37.4, 12, 13, 1, NULL, NULL, 1, 1, 0, 3.9, 3.9, 4.4, '2016-10-17 06:47:53', '2016-10-17 06:47:53', NULL, 0, 0, 1600, 0, NULL, 2, 0, NULL),
(33, 352, NULL, 'Invenstory Group Product 3', NULL, NULL, NULL, 10, 14, NULL, NULL, NULL, 31.45, 7, 14, 9, NULL, NULL, 1, 1, 0, 4, 3.8, 4, '2016-10-17 06:47:54', '2016-10-17 06:47:54', NULL, 0, 0, 1602, 0, NULL, 2, 0, NULL),
(34, 361, NULL, 'Invenstory Group Product 4', NULL, NULL, NULL, 3, 19, 'John Smith', NULL, NULL, 5.88, 10, 14, 1, NULL, NULL, 1, 1, 0, 3.6, 4, 3.9, '2016-10-17 06:47:54', '2016-10-17 06:47:54', NULL, 0, 0, 1602, 0, NULL, 2, 0, NULL),
(35, 370, NULL, 'Invenstory Group Product 5', NULL, NULL, NULL, 11, 16, '', NULL, NULL, 34, 11, 11, 8, NULL, NULL, 1, 1, 0, 4.2, 3.9, 4.1, '2016-10-17 06:47:54', '2016-10-17 06:47:54', NULL, 0, 0, 1602, 0, NULL, 2, 0, NULL),
(36, 382, NULL, 'Invenstory Group Product 6', NULL, NULL, NULL, 14, 20, NULL, NULL, NULL, 51.26, 12, 15, 10, NULL, NULL, 1, 1, 0, 3.9, 4.1, 3.7, '2016-10-17 06:47:55', '2016-10-17 06:47:55', NULL, 0, 0, 1602, 0, NULL, 2, 0, NULL),
(37, 393, NULL, 'Invenstory Group Product 7', NULL, NULL, NULL, 8, 20, 'Arthur Benjamin', NULL, NULL, 90.33, 5, 10, 9, NULL, NULL, 1, 1, 0, 3.9, 4.1, 4.6, '2016-10-17 06:47:55', '2016-10-17 06:47:55', NULL, 0, 0, 1603, 0, NULL, 2, 0, NULL),
(38, 397, NULL, 'Invenstory Group Product 8', NULL, NULL, NULL, 2, 6, 'Arthur Benjamin', NULL, NULL, 99.09, 5, 15, 8, NULL, NULL, 1, 1, 0, 3.7, 4.6, 4, '2016-10-17 06:47:56', '2016-10-17 06:47:56', NULL, 0, 0, 1603, 0, NULL, 2, 0, NULL),
(39, 412, NULL, 'Invenstory Group Product 9', NULL, NULL, NULL, 0, 3, NULL, NULL, NULL, 68.97, 2, 3, 2, NULL, NULL, 1, 1, 0, 3.5, 4.1, 3.8, '2016-10-17 06:47:56', '2016-10-17 06:47:56', NULL, 0, 0, 1603, 0, NULL, 2, 0, NULL),
(40, 422, NULL, 'Invenstory Group Product 10', NULL, NULL, NULL, 16, 21, 'Arthur Benjamin', NULL, NULL, 80.44, 6, 13, 9, NULL, NULL, 1, 1, 0, 3.8, 4.3, 3.9, '2016-10-17 06:47:56', '2016-10-17 06:47:56', NULL, 0, 0, 1604, 0, NULL, 2, 0, NULL),
(41, 426, NULL, 'Invenstory Group Product 11', NULL, NULL, NULL, 4, 20, NULL, NULL, NULL, 47.61, 5, 14, 5, NULL, NULL, 1, 1, 0, 3.9, 3.7, 4.1, '2016-10-17 06:47:57', '2016-10-17 06:47:57', NULL, 0, 0, 1604, 0, NULL, 2, 0, NULL),
(42, 301, NULL, 'Invenstory Educator Product 12', NULL, NULL, NULL, 0, 18, NULL, NULL, NULL, 2.73, 2, 2, 3, NULL, NULL, 1, 1, 0, 4.2, 4.3, 4.3, '2016-10-17 06:47:57', '2016-10-17 06:47:57', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(43, 301, NULL, 'Invenstory Educator Product 13', NULL, NULL, NULL, 11, 16, '', NULL, NULL, 58.19, 9, 11, 7, NULL, NULL, 1, 1, 0, 3.9, 3.5, 3.7, '2016-10-17 06:47:57', '2016-10-17 06:47:58', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(44, 301, NULL, 'Invenstory Educator Product 14', NULL, NULL, NULL, 12, 16, NULL, NULL, NULL, 85.52, 3, 9, 5, NULL, NULL, 1, 1, 0, 3.9, 3.6, 3.8, '2016-10-17 06:47:58', '2016-10-17 06:47:58', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(45, 301, NULL, 'Invenstory Educator Product 15', NULL, NULL, NULL, 13, 20, 'Arthur Benjamin', NULL, NULL, 45.5, 3, 13, 10, NULL, NULL, 1, 1, 0, 4, 4, 3.9, '2016-10-17 06:47:58', '2016-10-17 06:47:58', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(46, 301, NULL, 'Invenstory Educator Product 16', NULL, NULL, NULL, 10, 17, 'John Smith', NULL, NULL, 38.08, 3, 9, 9, NULL, NULL, 1, 1, 0, 4.1, 3.9, 4, '2016-10-17 06:47:58', '2016-10-17 06:47:58', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(47, 303, NULL, 'Invenstory Educator Product 17', NULL, NULL, NULL, 12, 18, 'John Smith', NULL, NULL, 54.05, 1, 9, 3, NULL, NULL, 1, 1, 0, 3.7, 4.4, 3.9, '2016-10-17 06:47:59', '2016-10-17 06:47:59', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(48, 303, NULL, 'Invenstory Educator Product 18', NULL, NULL, NULL, 17, 21, 'John Smith', NULL, NULL, 63.93, 4, 12, 10, NULL, NULL, 1, 1, 0, 3.9, 4.1, 4.3, '2016-10-17 06:47:59', '2016-10-17 06:47:59', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(49, 303, NULL, 'Invenstory Educator Product 19', NULL, NULL, NULL, 1, 6, 'Arthur Benjamin', NULL, NULL, 74.17, 3, 12, 4, NULL, NULL, 1, 1, 0, 4.1, 4, 4.3, '2016-10-17 06:47:59', '2016-10-17 06:48:00', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(50, 303, NULL, 'Invenstory Educator Product 20', NULL, NULL, NULL, 4, 16, '', NULL, NULL, 14.68, 4, 5, 3, NULL, NULL, 1, 1, 0, 4.4, 4.1, 3.6, '2016-10-17 06:48:00', '2016-10-17 06:48:00', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(51, 303, NULL, 'Invenstory Educator Product 21', NULL, NULL, NULL, 6, 20, 'Arthur Benjamin', NULL, NULL, 83.16, 11, 15, 6, NULL, NULL, 1, 1, 0, 3.5, 4.1, 4.2, '2016-10-17 06:48:00', '2016-10-17 06:48:00', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(52, 304, NULL, 'Invenstory Educator Product 22', NULL, NULL, NULL, 4, 20, 'Arthur Benjamin', NULL, NULL, 96.26, 1, 14, 9, NULL, NULL, 1, 1, 0, 4.2, 4.1, 4.3, '2016-10-17 06:48:01', '2016-10-17 06:48:01', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(53, 304, NULL, 'Invenstory Educator Product 23', NULL, NULL, NULL, 5, 11, '', NULL, NULL, 70.08, 4, 10, 4, NULL, NULL, 1, 1, 0, 4.3, 4, 3.8, '2016-10-17 06:48:01', '2016-10-17 06:48:01', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(54, 304, NULL, 'Invenstory Educator Product 24', NULL, NULL, NULL, 6, 21, NULL, NULL, NULL, 74.4, 5, 12, 10, NULL, NULL, 1, 1, 0, 4.1, 4.3, 4.3, '2016-10-17 06:48:01', '2016-10-17 06:48:01', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(55, 305, NULL, 'Invenstory Educator Product 25', NULL, NULL, NULL, 0, 18, 'Arthur Benjamin', NULL, NULL, 67.07, 6, 12, 7, NULL, NULL, 1, 1, 0, 3.7, 4.1, 4.1, '2016-10-17 06:48:02', '2016-10-17 06:48:02', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(56, 305, NULL, 'Invenstory Educator Product 26', NULL, NULL, NULL, 12, 12, NULL, NULL, NULL, 80.16, 11, 14, 6, NULL, NULL, 1, 1, 0, 3.9, 4.2, 4.3, '2016-10-17 06:48:02', '2016-10-17 06:48:02', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(57, 305, NULL, 'Invenstory Educator Product 27', NULL, NULL, NULL, 1, 5, 'Arthur Benjamin', NULL, NULL, 34.21, 2, 8, 5, NULL, NULL, 1, 1, 0, 4, 4.4, 4, '2016-10-17 06:48:02', '2016-10-17 06:48:02', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(58, 305, NULL, 'Invenstory Educator Product 28', NULL, NULL, NULL, 4, 13, '', NULL, NULL, 58.05, 1, 6, 9, NULL, NULL, 1, 1, 0, 4.2, 3.8, 4.5, '2016-10-17 06:48:03', '2016-10-17 06:48:03', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(59, 306, NULL, 'Invenstory Educator Product 29', NULL, NULL, NULL, 4, 8, '', NULL, NULL, 66.37, 2, 3, 10, NULL, NULL, 1, 1, 0, 4, 4.3, 4.1, '2016-10-17 06:48:03', '2016-10-17 06:48:03', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(60, 306, NULL, 'Invenstory Educator Product 30', NULL, NULL, NULL, 10, 20, '', NULL, NULL, 75.27, 11, 13, 1, NULL, NULL, 1, 1, 0, 4, 3.6, 4, '2016-10-17 06:48:04', '2016-10-17 06:48:04', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(61, 306, NULL, 'Invenstory Educator Product 31', NULL, NULL, NULL, 14, 17, NULL, NULL, NULL, 14.22, 6, 6, 8, NULL, NULL, 1, 1, 0, 3.9, 3.6, 3.7, '2016-10-17 06:48:04', '2016-10-17 06:48:04', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(62, 307, NULL, 'Invenstory Educator Product 32', NULL, NULL, NULL, 3, 8, NULL, NULL, NULL, 64.72, 7, 14, 9, NULL, NULL, 1, 1, 0, 3.6, 3.9, 3.6, '2016-10-17 06:48:05', '2016-10-17 06:48:05', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(63, 307, NULL, 'Invenstory Educator Product 33', NULL, NULL, NULL, 2, 5, '', NULL, NULL, 39.29, 6, 6, 1, NULL, NULL, 1, 1, 0, 4.1, 3.6, 3.7, '2016-10-17 06:48:05', '2016-10-17 06:48:05', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(64, 307, NULL, 'Invenstory Educator Product 34', NULL, NULL, NULL, 5, 20, '', NULL, NULL, 78.86, 4, 7, 8, NULL, NULL, 1, 1, 0, 4, 3.6, 3.8, '2016-10-17 06:48:05', '2016-10-17 06:48:05', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(65, 308, NULL, 'Invenstory Educator Product 35', NULL, NULL, NULL, 0, 15, NULL, NULL, NULL, 41.35, 6, 7, 2, NULL, NULL, 1, 1, 0, 4.3, 4.4, 4.3, '2016-10-17 06:48:06', '2016-10-17 06:48:06', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(66, 308, NULL, 'Invenstory Educator Product 36', NULL, NULL, NULL, 10, 21, '', NULL, NULL, 47.92, 1, 13, 9, NULL, NULL, 1, 1, 0, 3.8, 4.3, 4.2, '2016-10-17 06:48:06', '2016-10-17 06:48:06', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(67, 308, NULL, 'Invenstory Educator Product 37', NULL, NULL, NULL, 3, 5, 'Arthur Benjamin', NULL, NULL, 98.43, 2, 3, 2, NULL, NULL, 1, 1, 0, 4.1, 3.9, 3.7, '2016-10-17 06:48:06', '2016-10-17 06:48:06', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(68, 311, NULL, 'Invenstory Educator Product 38', NULL, NULL, NULL, 4, 16, NULL, NULL, NULL, 67.77, 2, 7, 9, NULL, NULL, 1, 1, 0, 4.2, 4.2, 3.9, '2016-10-17 06:48:07', '2016-10-17 06:48:07', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(69, 311, NULL, 'Invenstory Educator Product 39', NULL, NULL, NULL, 1, 15, NULL, NULL, NULL, 30.04, 1, 2, 6, NULL, NULL, 1, 1, 0, 3.8, 4, 4.1, '2016-10-17 06:48:07', '2016-10-17 06:48:07', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(70, 311, NULL, 'Invenstory Educator Product 40', NULL, NULL, NULL, 4, 13, 'Arthur Benjamin', NULL, NULL, 86.17, 3, 11, 5, NULL, NULL, 1, 1, 0, 4.3, 4.1, 4.3, '2016-10-17 06:48:08', '2016-10-17 06:48:08', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(71, 311, NULL, 'Invenstory Educator Product 41', NULL, NULL, NULL, 5, 12, 'John Smith', NULL, NULL, 47.49, 8, 10, 9, NULL, NULL, 1, 1, 0, 3.9, 3.9, 4, '2016-10-17 06:48:08', '2016-10-17 06:48:09', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(72, 311, NULL, 'Invenstory Educator Product 42', NULL, NULL, NULL, 9, 10, 'John Smith', NULL, NULL, 41.81, 3, 4, 8, NULL, NULL, 1, 1, 0, 4, 4.4, 4.3, '2016-10-17 06:48:09', '2016-10-17 06:48:09', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(73, 312, NULL, 'Invenstory Educator Product 43', NULL, NULL, NULL, 6, 6, NULL, NULL, NULL, 89.32, 2, 7, 4, NULL, NULL, 1, 1, 0, 4.4, 3.4, 3.9, '2016-10-17 06:48:10', '2016-10-17 06:48:10', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(74, 312, NULL, 'Invenstory Educator Product 44', NULL, NULL, NULL, 1, 6, '', NULL, NULL, 46.11, 10, 11, 10, NULL, NULL, 1, 1, 0, 3.9, 3.9, 4.3, '2016-10-17 06:48:11', '2016-10-17 06:48:11', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(75, 312, NULL, 'Invenstory Educator Product 45', NULL, NULL, NULL, 11, 17, 'John Smith', NULL, NULL, 21.05, 1, 6, 2, NULL, NULL, 1, 1, 0, 4.4, 4, 3.6, '2016-10-17 06:48:11', '2016-10-17 06:48:12', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(76, 312, NULL, 'Invenstory Educator Product 46', NULL, NULL, NULL, 1, 16, 'John Smith', NULL, NULL, 36.1, 13, 13, 2, NULL, NULL, 1, 1, 0, 4.4, 4.2, 3.8, '2016-10-17 06:48:12', '2016-10-17 06:48:12', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(77, 312, NULL, 'Invenstory Educator Product 47', NULL, NULL, NULL, 10, 16, NULL, NULL, NULL, 16.57, 1, 4, 4, NULL, NULL, 1, 1, 0, 4.3, 4, 4.1, '2016-10-17 06:48:12', '2016-10-17 06:48:12', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(78, 313, NULL, 'Invenstory Educator Product 48', NULL, NULL, NULL, 7, 19, NULL, NULL, NULL, 56.96, 5, 9, 1, NULL, NULL, 1, 1, 0, 4.3, 3.8, 4.5, '2016-10-17 06:48:13', '2016-10-17 06:48:13', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(79, 313, NULL, 'Invenstory Educator Product 49', NULL, NULL, NULL, 6, 6, 'Arthur Benjamin', NULL, NULL, 74.5, 5, 7, 4, NULL, NULL, 1, 1, 0, 4.1, 3.8, 4.1, '2016-10-17 06:48:13', '2016-10-17 06:48:13', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(80, 313, NULL, 'Invenstory Educator Product 50', NULL, NULL, NULL, 2, 3, 'John Smith', NULL, NULL, 20.42, 4, 15, 8, NULL, NULL, 1, 1, 0, 4.2, 4, 4.3, '2016-10-17 06:48:14', '2016-10-17 06:48:14', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(81, 313, NULL, 'Invenstory Educator Product 51', NULL, NULL, NULL, 10, 18, NULL, NULL, NULL, 55.6, 10, 14, 8, NULL, NULL, 1, 1, 0, 3.8, 4, 4.1, '2016-10-17 06:48:15', '2016-10-17 06:48:15', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(82, 314, NULL, 'Invenstory Educator Product 52', NULL, NULL, NULL, 9, 16, NULL, NULL, NULL, 56.25, 3, 9, 2, NULL, NULL, 1, 1, 0, 4.3, 4, 4.5, '2016-10-17 06:48:15', '2016-10-17 06:48:16', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(83, 314, NULL, 'Invenstory Educator Product 53', NULL, NULL, NULL, 2, 4, '', NULL, NULL, 49.76, 1, 10, 3, NULL, NULL, 1, 1, 0, 4.2, 4.2, 4.1, '2016-10-17 06:48:16', '2016-10-17 06:48:16', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(84, 314, NULL, 'Invenstory Educator Product 54', NULL, NULL, NULL, 1, 13, 'Arthur Benjamin', NULL, NULL, 27.81, 8, 10, 6, NULL, NULL, 1, 1, 0, 3.9, 4.5, 4.2, '2016-10-17 06:48:16', '2016-10-17 06:48:16', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(85, 315, NULL, 'Invenstory Educator Product 55', NULL, NULL, NULL, 0, 21, 'John Smith', NULL, NULL, 23.01, 8, 15, 5, NULL, NULL, 1, 1, 0, 4.2, 3.9, 4.1, '2016-10-17 06:48:17', '2016-10-17 06:48:17', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(86, 315, NULL, 'Invenstory Educator Product 56', NULL, NULL, NULL, 11, 15, 'John Smith', NULL, NULL, 51.63, 12, 12, 9, NULL, NULL, 1, 1, 0, 3.6, 4, 4.2, '2016-10-17 06:48:17', '2016-10-17 06:48:17', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(87, 315, NULL, 'Invenstory Educator Product 57', NULL, NULL, NULL, 9, 12, '', NULL, NULL, 79.91, 7, 9, 4, NULL, NULL, 1, 1, 0, 3.8, 4.2, 3.9, '2016-10-17 06:48:18', '2016-10-17 06:48:18', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(88, 315, NULL, 'Invenstory Educator Product 58', NULL, NULL, NULL, 9, 15, 'John Smith', NULL, NULL, 34.53, 8, 14, 1, NULL, NULL, 1, 1, 0, 4.1, 3.6, 3.6, '2016-10-17 06:48:19', '2016-10-17 06:48:19', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(89, 315, NULL, 'Invenstory Educator Product 59', NULL, NULL, NULL, 11, 16, NULL, NULL, NULL, 13.11, 6, 6, 1, NULL, NULL, 1, 1, 0, 4.1, 4.1, 4.1, '2016-10-17 06:48:19', '2016-10-17 06:48:19', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(90, 316, NULL, 'Invenstory Educator Product 60', NULL, NULL, NULL, 12, 20, 'John Smith', NULL, NULL, 27.42, 12, 12, 2, NULL, NULL, 1, 1, 0, 4.1, 3.9, 3.7, '2016-10-17 06:48:19', '2016-10-17 06:48:20', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(91, 316, NULL, 'Invenstory Educator Product 61', NULL, NULL, NULL, 5, 12, NULL, NULL, NULL, 79.42, 9, 10, 4, NULL, NULL, 1, 1, 0, 3.8, 3.7, 3.8, '2016-10-17 06:48:20', '2016-10-17 06:48:20', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(92, 316, NULL, 'Invenstory Educator Product 62', NULL, NULL, NULL, 8, 9, 'John Smith', NULL, NULL, 97.33, 7, 9, 8, NULL, NULL, 1, 1, 0, 4.7, 3.9, 4.2, '2016-10-17 06:48:20', '2016-10-17 06:48:20', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(93, 317, NULL, 'Invenstory Educator Product 63', NULL, NULL, NULL, 2, 2, NULL, NULL, NULL, 67.05, 5, 13, 2, NULL, NULL, 1, 1, 0, 4, 3.7, 3.8, '2016-10-17 06:48:21', '2016-10-17 06:48:21', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(94, 317, NULL, 'Invenstory Educator Product 64', NULL, NULL, NULL, 7, 20, 'John Smith', NULL, NULL, 96.09, 1, 10, 7, NULL, NULL, 1, 1, 0, 4, 4.5, 3.9, '2016-10-17 06:48:21', '2016-10-17 06:48:21', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(95, 317, NULL, 'Invenstory Educator Product 65', NULL, NULL, NULL, 7, 19, NULL, NULL, NULL, 72.01, 3, 9, 2, NULL, NULL, 1, 1, 0, 3.7, 4.1, 4, '2016-10-17 06:48:22', '2016-10-17 06:48:22', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(96, 317, NULL, 'Invenstory Educator Product 66', NULL, NULL, NULL, 1, 11, '', NULL, NULL, 60.77, 3, 3, 6, NULL, NULL, 1, 1, 0, 4, 3.8, 3.9, '2016-10-17 06:48:22', '2016-10-17 06:48:22', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(97, 317, NULL, 'Invenstory Educator Product 67', NULL, NULL, NULL, 4, 14, NULL, NULL, NULL, 43.7, 7, 8, 1, NULL, NULL, 1, 1, 0, 4, 3.9, 4.1, '2016-10-17 06:48:22', '2016-10-17 06:48:22', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(98, 318, NULL, 'Invenstory Educator Product 68', NULL, NULL, NULL, 19, 20, NULL, NULL, NULL, 85.69, 1, 5, 8, NULL, NULL, 1, 1, 0, 4, 4.3, 4, '2016-10-17 06:48:23', '2016-10-17 06:48:23', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(99, 318, NULL, 'Invenstory Educator Product 69', NULL, NULL, NULL, 3, 19, 'John Smith', NULL, NULL, 82.75, 4, 5, 1, NULL, NULL, 1, 1, 0, 3.8, 3.8, 3.6, '2016-10-17 06:48:23', '2016-10-17 06:48:23', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(100, 318, NULL, 'Invenstory Educator Product 70', NULL, NULL, NULL, 16, 17, 'Arthur Benjamin', NULL, NULL, 44.38, 3, 15, 2, NULL, NULL, 1, 1, 0, 3.8, 4, 4.1, '2016-10-17 06:48:24', '2016-10-17 06:48:24', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(101, 319, NULL, 'Invenstory Educator Product 71', NULL, NULL, NULL, 4, 10, 'John Smith', NULL, NULL, 91.24, 13, 14, 9, NULL, NULL, 1, 1, 0, 3.6, 4.1, 3.9, '2016-10-17 06:48:24', '2016-10-17 06:48:24', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(102, 319, NULL, 'Invenstory Educator Product 72', NULL, NULL, NULL, 15, 20, 'Arthur Benjamin', NULL, NULL, 38.45, 13, 13, 9, NULL, NULL, 1, 1, 0, 3.6, 3.9, 4.2, '2016-10-17 06:48:25', '2016-10-17 06:48:25', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(103, 319, NULL, 'Invenstory Educator Product 73', NULL, NULL, NULL, 0, 11, NULL, NULL, NULL, 9.96, 12, 15, 10, NULL, NULL, 1, 1, 0, 4, 3.9, 3.7, '2016-10-17 06:48:25', '2016-10-17 06:48:25', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(104, 319, NULL, 'Invenstory Educator Product 74', NULL, NULL, NULL, 3, 9, 'John Smith', NULL, NULL, 35.72, 1, 14, 5, NULL, NULL, 1, 1, 0, 4.1, 4.3, 3.8, '2016-10-17 06:48:26', '2016-10-17 06:48:26', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(105, 320, NULL, 'Invenstory Educator Product 75', NULL, NULL, NULL, 4, 18, 'Arthur Benjamin', NULL, NULL, 85.08, 10, 11, 9, NULL, NULL, 1, 1, 0, 4.1, 4, 4.2, '2016-10-17 06:48:26', '2016-10-17 06:48:26', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(106, 320, NULL, 'Invenstory Educator Product 76', NULL, NULL, NULL, 2, 8, 'John Smith', NULL, NULL, 69.86, 9, 15, 6, NULL, NULL, 1, 1, 0, 4.1, 4, 4.1, '2016-10-17 06:48:26', '2016-10-17 06:48:26', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(107, 320, NULL, 'Invenstory Educator Product 77', NULL, NULL, NULL, 5, 13, NULL, NULL, NULL, 42.45, 8, 9, 5, NULL, NULL, 1, 1, 0, 4.1, 3.7, 4, '2016-10-17 06:48:27', '2016-10-17 06:48:27', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(108, 320, NULL, 'Invenstory Educator Product 78', NULL, NULL, NULL, 7, 12, 'John Smith', NULL, NULL, 15.64, 10, 12, 7, NULL, NULL, 1, 1, 0, 4.7, 4.2, 4.1, '2016-10-17 06:48:27', '2016-10-17 06:48:27', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(109, 321, NULL, 'Invenstory Educator Product 79', NULL, NULL, NULL, 9, 17, NULL, NULL, NULL, 46.14, 3, 10, 7, NULL, NULL, 1, 1, 0, 4, 3.8, 4.8, '2016-10-17 06:48:28', '2016-10-17 06:48:28', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(110, 321, NULL, 'Invenstory Educator Product 80', NULL, NULL, NULL, 3, 6, 'Arthur Benjamin', NULL, NULL, 44.6, 7, 15, 5, NULL, NULL, 1, 1, 0, 4.3, 3.9, 4.2, '2016-10-17 06:48:28', '2016-10-17 06:48:28', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(111, 321, NULL, 'Invenstory Educator Product 81', NULL, NULL, NULL, 4, 14, 'Arthur Benjamin', NULL, NULL, 24.9, 3, 14, 10, NULL, NULL, 1, 1, 0, 3.8, 3.9, 3.8, '2016-10-17 06:48:29', '2016-10-17 06:48:29', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(112, 322, NULL, 'Invenstory Educator Product 82', NULL, NULL, NULL, 8, 20, '', NULL, NULL, 34.29, 5, 9, 4, NULL, NULL, 1, 1, 0, 4, 4.1, 4.1, '2016-10-17 06:48:29', '2016-10-17 06:48:29', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(113, 323, NULL, 'Invenstory Educator Product 83', NULL, NULL, NULL, 2, 18, 'John Smith', NULL, NULL, 29.05, 5, 13, 4, NULL, NULL, 1, 1, 0, 4.4, 4.2, 3.8, '2016-10-17 06:48:29', '2016-10-17 06:48:30', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(114, 323, NULL, 'Invenstory Educator Product 84', NULL, NULL, NULL, 6, 9, 'Arthur Benjamin', NULL, NULL, 15.62, 4, 10, 9, NULL, NULL, 1, 1, 0, 4.7, 4.3, 4.5, '2016-10-17 06:48:30', '2016-10-17 06:48:30', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(115, 324, NULL, 'Invenstory Educator Product 85', NULL, NULL, NULL, 4, 14, '', NULL, NULL, 88.73, 11, 14, 7, NULL, NULL, 1, 1, 0, 4.2, 4.4, 4, '2016-10-17 06:48:30', '2016-10-17 06:48:30', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(116, 324, NULL, 'Invenstory Educator Product 86', NULL, NULL, NULL, 2, 16, NULL, NULL, NULL, 91.42, 3, 3, 4, NULL, NULL, 1, 1, 0, 3.8, 3.7, 3.6, '2016-10-17 06:48:31', '2016-10-17 06:48:31', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(117, 324, NULL, 'Invenstory Educator Product 87', NULL, NULL, NULL, 0, 13, 'Arthur Benjamin', NULL, NULL, 64.34, 2, 10, 7, NULL, NULL, 1, 1, 0, 4.1, 4.1, 4.2, '2016-10-17 06:48:31', '2016-10-17 06:48:31', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(118, 325, NULL, 'Invenstory Educator Product 88', NULL, NULL, NULL, 0, 8, NULL, NULL, NULL, 93.76, 9, 10, 2, NULL, NULL, 1, 1, 0, 4.2, 4.4, 4.2, '2016-10-17 06:48:31', '2016-10-17 06:48:31', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(119, 325, NULL, 'Invenstory Educator Product 89', NULL, NULL, NULL, 8, 18, '', NULL, NULL, 97.77, 4, 12, 2, NULL, NULL, 1, 1, 0, 4, 4, 3.7, '2016-10-17 06:48:32', '2016-10-17 06:48:32', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(120, 325, NULL, 'Invenstory Educator Product 90', NULL, NULL, NULL, 7, 13, NULL, NULL, NULL, 81.17, 4, 13, 6, NULL, NULL, 1, 1, 0, 3.9, 4.2, 4, '2016-10-17 06:48:32', '2016-10-17 06:48:32', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(121, 325, NULL, 'Invenstory Educator Product 91', NULL, NULL, NULL, 4, 4, '', NULL, NULL, 59.74, 5, 6, 6, NULL, NULL, 1, 1, 0, 4.5, 3.9, 3.8, '2016-10-17 06:48:33', '2016-10-17 06:48:33', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(122, 325, NULL, 'Invenstory Educator Product 92', NULL, NULL, NULL, 1, 10, '', NULL, NULL, 67.07, 3, 9, 8, NULL, NULL, 1, 1, 0, 3.8, 4, 3.7, '2016-10-17 06:48:33', '2016-10-17 06:48:33', NULL, 0, 0, NULL, 0, NULL, 2, 0, NULL),
(123, 1344, NULL, 'My Product 0', NULL, NULL, NULL, 0, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(124, 1344, NULL, 'My Product 1', NULL, NULL, NULL, 1, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(125, 1344, NULL, 'My Product 2', NULL, NULL, NULL, 2, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(126, 1344, NULL, 'My Product 3', NULL, NULL, NULL, 3, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(127, 1344, NULL, 'My Product 4', NULL, NULL, NULL, 4, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(128, 1344, NULL, 'My Product 5', NULL, NULL, NULL, 5, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(129, 1344, NULL, 'My Product 6', NULL, NULL, NULL, 6, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(130, 1344, NULL, 'My Product 7', NULL, NULL, NULL, 7, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(131, 1344, NULL, 'My Product 8', NULL, NULL, NULL, 8, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(132, 1344, NULL, 'My Product 9', NULL, NULL, NULL, 9, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(133, 1344, NULL, 'My Product 10', NULL, NULL, NULL, 10, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(134, 1344, NULL, 'My Product 11', NULL, NULL, NULL, 11, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(135, 1344, NULL, 'My Product 12', NULL, NULL, NULL, 12, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(136, 1344, NULL, 'My Product 13', NULL, NULL, NULL, 13, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(137, 1344, NULL, 'My Product 14', NULL, NULL, NULL, 14, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(138, 1344, NULL, 'My Product 15', NULL, NULL, NULL, 15, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(139, 1344, NULL, 'My Product 16', NULL, NULL, NULL, 16, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(140, 1344, NULL, 'My Product 17', NULL, NULL, NULL, 17, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(141, 1344, NULL, 'My Product 18', NULL, NULL, NULL, 18, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(142, 1344, NULL, 'My Product 19', NULL, NULL, NULL, 19, 21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(143, NULL, NULL, 'Library Product 0', NULL, NULL, NULL, 0, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(144, NULL, NULL, 'Library Product 1', NULL, NULL, NULL, 1, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(145, NULL, NULL, 'Library Product 2', NULL, NULL, NULL, 2, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(146, NULL, NULL, 'Library Product 3', NULL, NULL, NULL, 3, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(147, NULL, NULL, 'Library Product 4', NULL, NULL, NULL, 4, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(148, NULL, NULL, 'Library Product 5', NULL, NULL, NULL, 5, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(149, NULL, NULL, 'Library Product 6', NULL, NULL, NULL, 6, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(150, NULL, NULL, 'Library Product 7', NULL, NULL, NULL, 7, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(151, NULL, NULL, 'Library Product 8', NULL, NULL, NULL, 8, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(152, NULL, NULL, 'Library Product 9', NULL, NULL, NULL, 9, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(153, NULL, NULL, 'Library Product 10', NULL, NULL, NULL, 10, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(154, NULL, NULL, 'Library Product 11', NULL, NULL, NULL, 11, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(155, NULL, NULL, 'Library Product 12', NULL, NULL, NULL, 12, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(156, NULL, NULL, 'Library Product 13', NULL, NULL, NULL, 13, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(157, NULL, NULL, 'Library Product 14', NULL, NULL, NULL, 14, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(158, NULL, NULL, 'Library Product 15', NULL, NULL, NULL, 15, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(159, NULL, NULL, 'Library Product 16', NULL, NULL, NULL, 16, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(160, NULL, NULL, 'Library Product 17', NULL, NULL, NULL, 17, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(161, NULL, NULL, 'Library Product 18', NULL, NULL, NULL, 18, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(162, NULL, NULL, 'Library Product 19', NULL, NULL, NULL, 19, 21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:05', '2016-10-17 06:49:05', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(163, NULL, NULL, 'Wishlist Product 0', NULL, NULL, NULL, 0, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:08', '2016-10-17 06:49:08', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(164, NULL, NULL, 'Wishlist Product 1', NULL, NULL, NULL, 1, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:08', '2016-10-17 06:49:08', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(165, NULL, NULL, 'Wishlist Product 2', NULL, NULL, NULL, 2, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:08', '2016-10-17 06:49:08', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(166, NULL, NULL, 'Wishlist Product 3', NULL, NULL, NULL, 3, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:08', '2016-10-17 06:49:08', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(167, NULL, NULL, 'Wishlist Product 4', NULL, NULL, NULL, 4, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:08', '2016-10-17 06:49:08', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(168, NULL, NULL, 'Wishlist Product 5', NULL, NULL, NULL, 5, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:08', '2016-10-17 06:49:08', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(169, NULL, NULL, 'Wishlist Product 6', NULL, NULL, NULL, 6, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:08', '2016-10-17 06:49:08', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(170, NULL, NULL, 'Wishlist Product 7', NULL, NULL, NULL, 7, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:08', '2016-10-17 06:49:08', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(171, NULL, NULL, 'Wishlist Product 8', NULL, NULL, NULL, 8, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:08', '2016-10-17 06:49:08', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(172, NULL, NULL, 'Wishlist Product 9', NULL, NULL, NULL, 9, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:08', '2016-10-17 06:49:08', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(173, NULL, NULL, 'Wishlist Product 10', NULL, NULL, NULL, 10, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:08', '2016-10-17 06:49:08', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(174, NULL, NULL, 'Wishlist Product 11', NULL, NULL, NULL, 11, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:08', '2016-10-17 06:49:08', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(175, NULL, NULL, 'Wishlist Product 12', NULL, NULL, NULL, 12, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:08', '2016-10-17 06:49:08', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(176, NULL, NULL, 'Wishlist Product 13', NULL, NULL, NULL, 13, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:08', '2016-10-17 06:49:08', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(177, NULL, NULL, 'Wishlist Product 14', NULL, NULL, NULL, 14, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:08', '2016-10-17 06:49:08', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(178, NULL, NULL, 'Wishlist Product 15', NULL, NULL, NULL, 15, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:08', '2016-10-17 06:49:08', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(179, NULL, NULL, 'Wishlist Product 16', NULL, NULL, NULL, 16, 18, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:08', '2016-10-17 06:49:08', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(180, NULL, NULL, 'Wishlist Product 17', NULL, NULL, NULL, 17, 19, NULL, NULL, NULL, NULL, 13, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:08', '2016-10-17 06:49:08', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(181, NULL, NULL, 'Wishlist Product 18', NULL, NULL, NULL, 18, 20, NULL, NULL, NULL, NULL, NULL, 12, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:08', '2016-10-17 06:49:08', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL),
(182, NULL, NULL, 'Wishlist Product 19', NULL, NULL, NULL, 19, 21, NULL, NULL, NULL, NULL, 12, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, '2016-10-17 06:49:08', '2016-10-17 06:49:08', NULL, 0, 0, NULL, 0, NULL, 1, 0, NULL);
/*!40000 ALTER TABLE `product` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Raw
sql-case-select-values-in-range.sql
select p.name, p.grade_from_id, p.grade_to_id,
-- grade exists or no
CASE
WHEN (gf.order is null and gt.order is null) THEN 0
ELSE 1
END
as 'grade_exists',
-- gf.order
CASE
WHEN (gf.order is null) THEN -1
ELSE gf.order
END
as 'grade_from_order',
-- gt.order
CASE
WHEN (gt.order is null) THEN 999
ELSE gt.order
END
as 'grade_to_order'
from product p
left join grade gf on gf.grade_id = p.grade_from_id
left join grade gt on gt.grade_id = p.grade_to_id
where
# grade exists = 1
(CASE
WHEN (gf.order is null and gt.order is null) THEN 0
ELSE 1
END) = 1
and
(
(
# 10 in grade range
10 between
CASE
WHEN (gf.order is null) THEN -1
ELSE gf.order
END
and
CASE
WHEN (gt.order is null) THEN 999
ELSE gt.order
END
)
or
(
# 11 in grade range
11 between
CASE
WHEN (gf.order is null) THEN -1
ELSE gf.order
END
and
CASE
WHEN (gt.order is null) THEN 999
ELSE gt.order
END
)
# cyclic add for all values
)
Raw
with where exists.sql
select p.name, p.grade_from_id, p.grade_to_id
from product p
where
(p.grade_from_id is not null or p.grade_to_id is not null )
and
exists
(
select 1 from grade gf , grade gt
where
(gf.grade_id = p.grade_from_id or p.grade_from_id is null)
and (gt.grade_id = p.grade_to_id or p.grade_to_id is null)
and
(
(
# 10 in grade range
6 between
CASE
WHEN (gf.order is null) THEN -1
ELSE gf.order
END
and
CASE
WHEN (gt.order is null) THEN 999
ELSE gt.order
END
)
or
(
# 11 in grade range
5 between
CASE
WHEN (gf.order is null) THEN -1
ELSE gf.order
END
and
CASE
WHEN (gt.order is null) THEN 999
ELSE gt.order
END
)
# cyclic add for all values
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment