Show: 

CHAPTER & EXTENDED STORY
ISBN/Order # Type Price Cart Add:
9781611811148 1 EACH OF 14 TITLES $99.50 QTY:
9781611811155 6 EACH OF 14(84) TITLES $585.50 QTY:

 
8 queries took 15 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT COUNT(*) AS count FROM `collections` AS `Collection` WHERE (`Collection`.`status` = 1) AND (`Collection`.`chapter_book` = 1) 111
2SELECT `Collection`.`id`, `Collection`.`isbn`, `Collection`.`price`, `Collection`.`order`, `Collection`.`created`, `Collection`.`modified`, `Collection`.`type`, `Collection`.`name`, `Collection`.`description`, `Collection`.`booknumber`, `Collection`.`img`, `Collection`.`spanish_title`, `Collection`.`chapter_book`, `Collection`.`approved`, `Collection`.`new_book`, `Collection`.`best_seller`, `Collection`.`fiction`, `Collection`.`nonfiction`, `Collection`.`emergent`, `Collection`.`early`, `Collection`.`transitional`, `Collection`.`trans_fluent`, `Collection`.`fluent`, `Collection`.`advanced_fluent`, `Collection`.`K`, `Collection`.`1`, `Collection`.`2`, `Collection`.`3`, `Collection`.`4`, `Collection`.`5`, `Collection`.`6`, `Collection`.`7_8`, `Collection`.`language`, `Collection`.`math`, `Collection`.`science`, `Collection`.`social`, `Collection`.`rrl`, `Collection`.`grl`, `Collection`.`dra`, `Collection`.`stage`, `Collection`.`types`, `Collection`.`interest`, `Collection`.`theme`, `Collection`.`curriculum`, `Collection`.`author`, `Collection`.`illustrator`, `Collection`.`author2`, `Collection`.`illustrator2`, `Collection`.`lexile`, `Collection`.`common`, `Collection`.`subject`, `Collection`.`status` FROM `collections` AS `Collection` WHERE (`Collection`.`status` = 1) AND (`Collection`.`chapter_book` = 1) ORDER BY `Collection`.`order` ASC LIMIT 25111
3SELECT `Product`.`id`, `Product`.`parent_id`, `Product`.`parent_type`, `Product`.`unit_num`, `Product`.`label`, `Product`.`price` FROM `products` AS `Product` WHERE `Product`.`parent_type` = 'Collection' AND `Product`.`parent_id` = '00000040' ORDER BY `Product`.`price` ASC229
4SELECT `Book`.`id`, `Book`.`isbn`, `Book`.`created`, `Book`.`modified`, `Book`.`name`, `Book`.`description`, `Book`.`price`, `Book`.`author`, `Book`.`illustrator`, `Book`.`author2`, `Book`.`illustrator2`, `Book`.`rrl`, `Book`.`grl`, `Book`.`dra`, `Book`.`lexile`, `Book`.`stage`, `Book`.`emergent`, `Book`.`early`, `Book`.`transitional`, `Book`.`trans_fluent`, `Book`.`fluent`, `Book`.`advanced_fluent`, `Book`.`types`, `Book`.`fiction`, `Book`.`nonfiction`, `Book`.`interest`, `Book`.`k`, `Book`.`1`, `Book`.`2`, `Book`.`3`, `Book`.`4`, `Book`.`5`, `Book`.`6`, `Book`.`7_8`, `Book`.`theme`, `Book`.`approved`, `Book`.`words`, `Book`.`pages`, `Book`.`curriculum`, `Book`.`spanish_title`, `Book`.`common`, `Book`.`chapter_book`, `Book`.`new_book`, `Book`.`best_seller`, `Book`.`character`, `Book`.`language`, `Book`.`math`, `Book`.`science`, `Book`.`social`, `Book`.`img`, `Book`.`inv`, `Book`.`pub`, `Book`.`status`, `Book`.`subject` FROM `books` AS `Book` JOIN `collections_books` ON `collections_books`.`collection_id` = '00000040' AND `collections_books`.`book_id` = `Book`.`id` WHERE 1 = 114141
5SELECT `Audio`.`id`, `Audio`.`created`, `Audio`.`modified`, `Audio`.`name`, `Audio`.`description`, `Audio`.`isbn`, `Audio`.`price`, `Audio`.`img`, `Audio`.`curriculum`, `Audio`.`author`, `Audio`.`author2`, `Audio`.`illustrator`, `Audio`.`illustrator2`, `Audio`.`stage`, `Audio`.`types`, `Audio`.`interest`, `Audio`.`theme`, `Audio`.`status` FROM `audios` AS `Audio` JOIN `collections_audios` ON `collections_audios`.`collection_id` = '00000040' AND `collections_audios`.`audio_id` = `Audio`.`id` WHERE 1 = 1000
6SELECT `OtherProduct`.`id`, `OtherProduct`.`isbn`, `OtherProduct`.`created`, `OtherProduct`.`modified`, `OtherProduct`.`name`, `OtherProduct`.`description`, `OtherProduct`.`price`, `OtherProduct`.`author`, `OtherProduct`.`illustrator`, `OtherProduct`.`author2`, `OtherProduct`.`illustrator2`, `OtherProduct`.`rrl`, `OtherProduct`.`grl`, `OtherProduct`.`dra`, `OtherProduct`.`stage`, `OtherProduct`.`types`, `OtherProduct`.`interest`, `OtherProduct`.`theme`, `OtherProduct`.`approved`, `OtherProduct`.`words`, `OtherProduct`.`pages`, `OtherProduct`.`curriculum`, `OtherProduct`.`spanish_title`, `OtherProduct`.`chapter_book`, `OtherProduct`.`new_book`, `OtherProduct`.`best_seller`, `OtherProduct`.`character`, `OtherProduct`.`img`, `OtherProduct`.`inv`, `OtherProduct`.`status` FROM `other_products` AS `OtherProduct` JOIN `collections_other_products` ON `collections_other_products`.`collection_id` = '00000040' AND `collections_other_products`.`other_product_id` = `OtherProduct`.`id` WHERE 1 = 1000
7SELECT `DiscountGroup`.`id`, `DiscountGroup`.`created`, `DiscountGroup`.`modified`, `DiscountGroup`.`type`, `DiscountGroup`.`name`, `DiscountGroup`.`description`, `DiscountGroup`.`product_list`, `DiscountGroup`.`img`, `DiscountGroup`.`status` FROM `discount_groups` AS `DiscountGroup` JOIN `discount_groups_collections` ON `discount_groups_collections`.`collection_id` = '00000040' AND `discount_groups_collections`.`discount_group_id` = `DiscountGroup`.`id` WHERE 1 = 11146: Table 'kaeden_dev.discount_groups_collections' doesn't exist0
8SELECT `DistBook`.`id`, `DistBook`.`isbn`, `DistBook`.`created`, `DistBook`.`modified`, `DistBook`.`name`, `DistBook`.`description`, `DistBook`.`price`, `DistBook`.`author`, `DistBook`.`illustrator`, `DistBook`.`rrl`, `DistBook`.`grl`, `DistBook`.`dra`, `DistBook`.`lexile`, `DistBook`.`stage`, `DistBook`.`emergent`, `DistBook`.`early`, `DistBook`.`transitional`, `DistBook`.`trans_fluent`, `DistBook`.`fluent`, `DistBook`.`advanced_fluent`, `DistBook`.`types`, `DistBook`.`fiction`, `DistBook`.`nonfiction`, `DistBook`.`interest`, `DistBook`.`k`, `DistBook`.`1`, `DistBook`.`2`, `DistBook`.`3`, `DistBook`.`4`, `DistBook`.`5`, `DistBook`.`6`, `DistBook`.`7_8`, `DistBook`.`theme`, `DistBook`.`approved`, `DistBook`.`words`, `DistBook`.`pages`, `DistBook`.`subject`, `DistBook`.`common`, `DistBook`.`language`, `DistBook`.`math`, `DistBook`.`science`, `DistBook`.`social`, `DistBook`.`img`, `DistBook`.`inv`, `DistBook`.`spanish_title`, `DistBook`.`pub`, `DistBook`.`status` FROM `dist_books` AS `DistBook` JOIN `collections_dist_books` ON `collections_dist_books`.`collection_id` = '00000040' AND `collections_dist_books`.`dist_book_id` = `DistBook`.`id` WHERE 1 = 114143