Marketing P. 7

Page 14 of 21

3 Critical Issues in Internet Retailing

April 1, 2007 | MARKETING

Managing returns, structuring the physical distribution network and deploying product inventories are all key.

More
Finding the Right Job For Your Product

Clayton M. Christensen, Scott D. Anthony, Gerald Berstell, Denise Nitterhouse

April 1, 2007 | MARKETING

Most companies segment their markets by customer demographics or product characteristics and differentiate their offerings by adding features and functions. But the consumer has a different view of the marketplace. He simply has a job to be done and is seeking to & #x201C;hire” the best product or service to do it. Marketers must adopt that perspective.

More
The Art of Managing New Product Transitions

Prof. Feryal Erhun feryal.erhun@stanford.edu, Prof. Paulo GonÌ¤alves paulog@miami.edu, Mr. Jay Hopman jay.hopman@intel.com

April 1, 2007 | MARKETING

Faster time to market and shorter product life cycles are pushing companies to introduce new products more frequently. While new products can offer tremendous value, product introductions and transitions pose enormous challenges to managers. In studying product introductions, the authors found that a common handicap was the lack of a formal process to guide managerial decisions. Drawing from research at Intel and examples from General Motors and Cisco Systems, the article develops a process to facilitate decision making during new product transitions. The proposed process analyzes the risks impacting a transition, identifies a set of factors across departments tracking those risks, monitors the evolution of these factors over time, and develops playbook mapping scenarios of risks and responses. The process helps level expectations across the organization, lessens the chance and impact of unanticipated outcomes, and helps synchronize responses among different departments. It assists managers in designing and implementing appropriate policies to ramp up sales for new products and ramp down sales for existing products, balancing the supply and the demand for both so that combined sales can grow smoothly.

More
The Continuing Power of Mass Advertising

Mr. Paul F. Nunes paul.f.nunes@accenture.com , Mr. Jeffrey Merrihue Jeffrey.merrihue@accenture.com

January 1, 2007 | MARKETING

For several years now, marketers have been urged to embrace one-to-one marketing and to offer microsegmented consumers customized products and services through targeted outreach. While the "market of one" approach can pay off, says the author, it requires a significant upfront investment, including: implementing customer relationship management software applications; filtering, enhancing and cleaning customer data; and personalizing interactions (e-mail, billing, offers and so on). These activities take time and coordination of multiple parts of the organization (marketing, customer service, sales, information technology), which can be daunting for companies trying to react quickly to a changing environment. In addition, those systems have often produced disappointing results because their use was not well integrated with corporate strategy. Also, micro-marketing strategy, on its own, is too narrow. Companies still need to reach broad groups of people with messages that are not dependent on an individual's decision to open an envelope (whether virtual or physical), pick up the phone or click on a box. But broad-based, broadcast media is ineffective and expensive. Fortunately, there are alternative solutions, such as one-to-one targeting and the broadcasting of 30-second television spots. The author's research on trends in marketing spending and consumer attitudes about advertising reveals four strategies available to companies that want to reach broad groups of people without breaking their marketing budget. The strategies are liberally illustrated with examples of Nike, Microsoft, UBS, Delta, Sony, Procter & Gamble, Citibank, Nextel, Honda, Nokia and McDonald's, among others.

More
Systems Marketing for the Information Age

Dr. John G. Singer

October 1, 2006 | MARKETING

Globalization, at its core, is about a new operating theory of the world based on connectedness between, across, above, below and through preexisting political, social, economic, thematic, geographic and security boundaries. The connections and interactions can be so intense and transformative, says the author, that we can no longer distinguish between actors and their environments. Advances in telecommunication have linked the information and economic domains of customer, competitor and collaborator as never before. And, because all players have access to virtually the same information and information technologies, and can therefore equally target a demographic with precision, there is no compelling competitive advantage in any digital marketing capability. At the end of the day, marketers confront the same dilemma they turned to the Internet and information technology to solve: consumers opting out in ever greater numbers. To grow a business today, says the author, companies must take a marketing ecosystems view, which shifts away from the logic of "brand" as the primary unit for business strategy. Citing Microsoft, Google, AT&T and McKinsey, among others, the author suggests that the only sensible way for a company to compete is not by offering new products with similar functional attributes, but by being better than its rivals at molding the ecosystem in which the competition takes place.

More
Merging the Brands and Branding the Merger

Richard Ettenson, Jonathan Knowles

July 1, 2006 | MARKETING

When one company acquires another, executives have 10 distinct options for the corporate rebranding.

More
Rethinking Consumer Boycotts

Mr. Richard Ettenson , Mr. N. Craig Smill , Jill Klein , Mr. Andrew John

July 1, 2006 | MARKETING

INTELLIGENCE: New developments, research and ideas in management

More
So You Think You Know Your Brand?

Dan Stiff

July 1, 2006 | MARKETING

A company must have a three-dimensional view of its brand.

More
Throttling the Customer

July 1, 2006 | MARKETING

Netflix’s allocation policy is part of a growing trend.

More
How to Prevent Your Customers From Failing

Stephen S. Tax , Mark Colgate , David E. Bowen

April 1, 2006 | MARKETING

As companies use self-service technologies, responsibility for service quality shifts to customers.

More

Loading Time: Base Classes	0.0006
My Controller Construct	0.0003
Build Nav	0.0005
Controller Execution Time ( Products / Route )	0.0531
Total Execution Time	0.0537

$_GET['cat_id']	247
$_GET['offset']	130

0.0003	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0002	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0002	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0003	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0002	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = 'b558da1b290647f27553e20a7d5da1de' ORDER BY `created_at` DESC
0.0002	SELECT `parent_id` FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `sku` IN ('marketin', 'marketinP', 'marketinC', 'marketinX') AND `type_id` = 'V' LIMIT 1
0.0002	SELECT SQL_CALC_FOUND_ROWS cat_id FROM (`product_categories`) WHERE `status_id` = 'A' AND `url_friendly` = 'marketing' AND `parent_id` = 1
0.0029	SELECT c.parent_id, c.format_id FROM products AS p, products AS c, product_categories__products WHERE p.prod_id = c.parent_id AND p.prod_id = product_categories__products.prod_id AND c.avail_id IN ('A','B','D') AND c.type_id = 'V' AND product_categories__products.cat_id = 247 AND ( c.sku = 'marketing' OR if(c.format_id = 'Certificate', '', p.url_friendly) = 'marketing' ) LIMIT 1
0.0005	SELECT `cat_id` AS id, `parent_id` AS parent, `status_id`, `name`, `description`, `url_friendly`, `page_title`, `meta_keywords`, `meta_description`, `position`, `updated_at` FROM (`product_categories`) WHERE `cat_id` != 1 ORDER BY `parent_id`, IF(position = 0, 1, 0) ASC , `position`, `name`
0.0003	SELECT SQL_CALC_FOUND_ROWS media_id, position FROM (`media`) WHERE `foreign_key_table` = 'product_categories' AND `foreign_key_column` = 'cat_id' AND `foreign_key_value` = '247' AND `kind` = 'hero_image' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0056	SELECT SQL_CALC_FOUND_ROWS p.prod_id AS parent_id, p.pool_id AS parent_pool_id, p.type_id AS parent_type_id, p.title AS parent_title, p.description AS parent_description, p.url_friendly AS parent_url_friendly, p.product_type, p.publication_date, c.prod_id, c.avail_id, c.type_id, c.sku, c.title, c.price, c.sale_price, c.toggle_inventory_api, c.qty_available, c.expected_date, product_categories__products.cat_id, COALESCE(product_categories.name, '') as category_name FROM (`products` AS p) JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id` LEFT JOIN (product_categories__products) ON `p`.`prod_id` = `product_categories__products`.`prod_id` LEFT JOIN (product_categories) ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id` WHERE `c`.`type_id` = 'V' AND `c`.`format_id` != "Certificate" AND c.avail_id IN ('A','B','D') AND product_categories__products.cat_id IN ('247','282','285','283','299','296') GROUP BY `c`.`parent_id` ORDER BY `p`.`pool_id`, `p`.`position`, `p`.`publication_date` DESC, `p`.`title`, `c`.`title` LIMIT 10 OFFSET 130
0.0001	SELECT FOUND_ROWS() AS total
0.0004	SELECT `parent_id` FROM (`products`) WHERE `prod_id` = '1222'
0.0002	SELECT * FROM (`products`) WHERE `products`.`prod_id` = '1221'
0.0002	SELECT `product_categories__products`.`cat_id` FROM (`product_categories__products`) JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id` WHERE `product_categories__products`.`prod_id` = '1221' AND `product_categories`.`parent_id` = 1 AND `product_categories__products`.`cat_id` NOT IN (1, 261)
0.0004	SELECT `cat_id` AS id, `parent_id` AS parent, `status_id`, `name`, `description`, `url_friendly`, `page_title`, `meta_keywords`, `meta_description`, `position`, `updated_at` FROM (`product_categories`) WHERE `cat_id` != 1 ORDER BY `parent_id`, IF(position = 0, 1, 0) ASC , `position`, `name`
0.0003	SELECT * FROM (`authors`) JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id` WHERE `products__authors`.`prod_id` = '1221' ORDER BY `sort` ASC
0.0001	SELECT * FROM (`product_flags__products`) WHERE `prod_id` = '1221'
0.0001	SELECT `sku` FROM (`products__xsell`) WHERE `prod_id` = '1221' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0002	SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price` FROM (`products` AS p) JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id` WHERE `c`.`avail_id` IN ('A', 'B', 'D') AND `c`.`type_id` = 'V' AND `c`.`parent_id` = '1221'
0.0004	SELECT * FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `parent_id` = '1221' AND `type_id` = 'V' ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title`
0.0003	SELECT SQL_CALC_FOUND_ROWS media_id, position FROM (`media`) WHERE `foreign_key_table` = 'products' AND `foreign_key_column` = 'prod_id' AND `foreign_key_value` = '1221' AND `kind` = 'image_600x600' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0001	SELECT * FROM (`media`) WHERE `media`.`media_id` = '596'
0.0001	SELECT * FROM (`mime_types`) WHERE `mime_types`.`extension` = 'jpg'
0.0001	SELECT * FROM (`media_metadata`) WHERE `media_id` = '596'
0.0001	SELECT `parent_id` FROM (`products`) WHERE `prod_id` = '1212'
0.0002	SELECT * FROM (`products`) WHERE `products`.`prod_id` = '1211'
0.0002	SELECT `product_categories__products`.`cat_id` FROM (`product_categories__products`) JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id` WHERE `product_categories__products`.`prod_id` = '1211' AND `product_categories`.`parent_id` = 1 AND `product_categories__products`.`cat_id` NOT IN (1, 261)
0.0003	SELECT * FROM (`authors`) JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id` WHERE `products__authors`.`prod_id` = '1211' ORDER BY `sort` ASC
0.0001	SELECT * FROM (`product_flags__products`) WHERE `prod_id` = '1211'
0.0001	SELECT `sku` FROM (`products__xsell`) WHERE `prod_id` = '1211' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0002	SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price` FROM (`products` AS p) JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id` WHERE `c`.`avail_id` IN ('A', 'B', 'D') AND `c`.`type_id` = 'V' AND `c`.`parent_id` = '1211'
0.0002	SELECT * FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `parent_id` = '1211' AND `type_id` = 'V' ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title`
0.0003	SELECT SQL_CALC_FOUND_ROWS media_id, position FROM (`media`) WHERE `foreign_key_table` = 'products' AND `foreign_key_column` = 'prod_id' AND `foreign_key_value` = '1211' AND `kind` = 'image_600x600' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0001	SELECT * FROM (`media`) WHERE `media`.`media_id` = '591'
0.0001	SELECT * FROM (`mime_types`) WHERE `mime_types`.`extension` = 'jpg'
0.0001	SELECT * FROM (`media_metadata`) WHERE `media_id` = '591'
0.0001	SELECT `parent_id` FROM (`products`) WHERE `prod_id` = '1214'
0.0002	SELECT * FROM (`products`) WHERE `products`.`prod_id` = '1213'
0.0002	SELECT `product_categories__products`.`cat_id` FROM (`product_categories__products`) JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id` WHERE `product_categories__products`.`prod_id` = '1213' AND `product_categories`.`parent_id` = 1 AND `product_categories__products`.`cat_id` NOT IN (1, 261)
0.0002	SELECT * FROM (`authors`) JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id` WHERE `products__authors`.`prod_id` = '1213' ORDER BY `sort` ASC
0.0001	SELECT * FROM (`product_flags__products`) WHERE `prod_id` = '1213'
0.0001	SELECT `sku` FROM (`products__xsell`) WHERE `prod_id` = '1213' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0002	SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price` FROM (`products` AS p) JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id` WHERE `c`.`avail_id` IN ('A', 'B', 'D') AND `c`.`type_id` = 'V' AND `c`.`parent_id` = '1213'
0.0002	SELECT * FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `parent_id` = '1213' AND `type_id` = 'V' ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title`
0.0003	SELECT SQL_CALC_FOUND_ROWS media_id, position FROM (`media`) WHERE `foreign_key_table` = 'products' AND `foreign_key_column` = 'prod_id' AND `foreign_key_value` = '1213' AND `kind` = 'image_600x600' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0001	SELECT * FROM (`media`) WHERE `media`.`media_id` = '592'
0.0001	SELECT * FROM (`mime_types`) WHERE `mime_types`.`extension` = 'jpg'
0.0001	SELECT * FROM (`media_metadata`) WHERE `media_id` = '592'
0.0001	SELECT `parent_id` FROM (`products`) WHERE `prod_id` = '1258'
0.0002	SELECT * FROM (`products`) WHERE `products`.`prod_id` = '1257'
0.0002	SELECT `product_categories__products`.`cat_id` FROM (`product_categories__products`) JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id` WHERE `product_categories__products`.`prod_id` = '1257' AND `product_categories`.`parent_id` = 1 AND `product_categories__products`.`cat_id` NOT IN (1, 261)
0.0002	SELECT * FROM (`authors`) JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id` WHERE `products__authors`.`prod_id` = '1257' ORDER BY `sort` ASC
0.0001	SELECT * FROM (`product_flags__products`) WHERE `prod_id` = '1257'
0.0001	SELECT `sku` FROM (`products__xsell`) WHERE `prod_id` = '1257' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0002	SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price` FROM (`products` AS p) JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id` WHERE `c`.`avail_id` IN ('A', 'B', 'D') AND `c`.`type_id` = 'V' AND `c`.`parent_id` = '1257'
0.0002	SELECT * FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `parent_id` = '1257' AND `type_id` = 'V' ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title`
0.0003	SELECT SQL_CALC_FOUND_ROWS media_id, position FROM (`media`) WHERE `foreign_key_table` = 'products' AND `foreign_key_column` = 'prod_id' AND `foreign_key_value` = '1257' AND `kind` = 'image_600x600' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0001	SELECT * FROM (`media`) WHERE `media`.`media_id` = '614'
0.0002	SELECT * FROM (`mime_types`) WHERE `mime_types`.`extension` = 'jpg'
0.0001	SELECT * FROM (`media_metadata`) WHERE `media_id` = '614'
0.0001	SELECT `parent_id` FROM (`products`) WHERE `prod_id` = '1296'
0.0002	SELECT * FROM (`products`) WHERE `products`.`prod_id` = '1295'
0.0003	SELECT `product_categories__products`.`cat_id` FROM (`product_categories__products`) JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id` WHERE `product_categories__products`.`prod_id` = '1295' AND `product_categories`.`parent_id` = 1 AND `product_categories__products`.`cat_id` NOT IN (1, 261)
0.0002	SELECT * FROM (`authors`) JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id` WHERE `products__authors`.`prod_id` = '1295' ORDER BY `sort` ASC
0.0001	SELECT * FROM (`product_flags__products`) WHERE `prod_id` = '1295'
0.0003	SELECT `sku` FROM (`products__xsell`) WHERE `prod_id` = '1295' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0002	SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price` FROM (`products` AS p) JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id` WHERE `c`.`avail_id` IN ('A', 'B', 'D') AND `c`.`type_id` = 'V' AND `c`.`parent_id` = '1295'
0.0002	SELECT * FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `parent_id` = '1295' AND `type_id` = 'V' ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title`
0.0003	SELECT SQL_CALC_FOUND_ROWS media_id, position FROM (`media`) WHERE `foreign_key_table` = 'products' AND `foreign_key_column` = 'prod_id' AND `foreign_key_value` = '1295' AND `kind` = 'image_600x600' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0001	SELECT * FROM (`media`) WHERE `media`.`media_id` = '633'
0.0001	SELECT * FROM (`mime_types`) WHERE `mime_types`.`extension` = 'jpg'
0.0001	SELECT * FROM (`media_metadata`) WHERE `media_id` = '633'
0.0001	SELECT `parent_id` FROM (`products`) WHERE `prod_id` = '1326'
0.0002	SELECT * FROM (`products`) WHERE `products`.`prod_id` = '1325'
0.0002	SELECT `product_categories__products`.`cat_id` FROM (`product_categories__products`) JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id` WHERE `product_categories__products`.`prod_id` = '1325' AND `product_categories`.`parent_id` = 1 AND `product_categories__products`.`cat_id` NOT IN (1, 261)
0.0002	SELECT * FROM (`authors`) JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id` WHERE `products__authors`.`prod_id` = '1325' ORDER BY `sort` ASC
0.0001	SELECT * FROM (`product_flags__products`) WHERE `prod_id` = '1325'
0.0001	SELECT `sku` FROM (`products__xsell`) WHERE `prod_id` = '1325' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0002	SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price` FROM (`products` AS p) JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id` WHERE `c`.`avail_id` IN ('A', 'B', 'D') AND `c`.`type_id` = 'V' AND `c`.`parent_id` = '1325'
0.0002	SELECT * FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `parent_id` = '1325' AND `type_id` = 'V' ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title`
0.0002	SELECT SQL_CALC_FOUND_ROWS media_id, position FROM (`media`) WHERE `foreign_key_table` = 'products' AND `foreign_key_column` = 'prod_id' AND `foreign_key_value` = '1325' AND `kind` = 'image_600x600' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0001	SELECT * FROM (`media`) WHERE `media`.`media_id` = '648'
0.0001	SELECT * FROM (`mime_types`) WHERE `mime_types`.`extension` = 'jpg'
0.0001	SELECT * FROM (`media_metadata`) WHERE `media_id` = '648'
0.0001	SELECT `parent_id` FROM (`products`) WHERE `prod_id` = '1308'
0.0004	SELECT * FROM (`products`) WHERE `products`.`prod_id` = '1307'
0.0002	SELECT `product_categories__products`.`cat_id` FROM (`product_categories__products`) JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id` WHERE `product_categories__products`.`prod_id` = '1307' AND `product_categories`.`parent_id` = 1 AND `product_categories__products`.`cat_id` NOT IN (1, 261)
0.0003	SELECT * FROM (`authors`) JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id` WHERE `products__authors`.`prod_id` = '1307' ORDER BY `sort` ASC
0.0001	SELECT * FROM (`product_flags__products`) WHERE `prod_id` = '1307'
0.0001	SELECT `sku` FROM (`products__xsell`) WHERE `prod_id` = '1307' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0003	SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price` FROM (`products` AS p) JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id` WHERE `c`.`avail_id` IN ('A', 'B', 'D') AND `c`.`type_id` = 'V' AND `c`.`parent_id` = '1307'
0.0003	SELECT * FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `parent_id` = '1307' AND `type_id` = 'V' ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title`
0.0003	SELECT SQL_CALC_FOUND_ROWS media_id, position FROM (`media`) WHERE `foreign_key_table` = 'products' AND `foreign_key_column` = 'prod_id' AND `foreign_key_value` = '1307' AND `kind` = 'image_600x600' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0001	SELECT * FROM (`media`) WHERE `media`.`media_id` = '639'
0.0001	SELECT * FROM (`mime_types`) WHERE `mime_types`.`extension` = 'jpg'
0.0001	SELECT * FROM (`media_metadata`) WHERE `media_id` = '639'
0.0001	SELECT `parent_id` FROM (`products`) WHERE `prod_id` = '1312'
0.0002	SELECT * FROM (`products`) WHERE `products`.`prod_id` = '1311'
0.0003	SELECT `product_categories__products`.`cat_id` FROM (`product_categories__products`) JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id` WHERE `product_categories__products`.`prod_id` = '1311' AND `product_categories`.`parent_id` = 1 AND `product_categories__products`.`cat_id` NOT IN (1, 261)
0.0003	SELECT * FROM (`authors`) JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id` WHERE `products__authors`.`prod_id` = '1311' ORDER BY `sort` ASC
0.0001	SELECT * FROM (`product_flags__products`) WHERE `prod_id` = '1311'
0.0001	SELECT `sku` FROM (`products__xsell`) WHERE `prod_id` = '1311' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0002	SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price` FROM (`products` AS p) JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id` WHERE `c`.`avail_id` IN ('A', 'B', 'D') AND `c`.`type_id` = 'V' AND `c`.`parent_id` = '1311'
0.0002	SELECT * FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `parent_id` = '1311' AND `type_id` = 'V' ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title`
0.0003	SELECT SQL_CALC_FOUND_ROWS media_id, position FROM (`media`) WHERE `foreign_key_table` = 'products' AND `foreign_key_column` = 'prod_id' AND `foreign_key_value` = '1311' AND `kind` = 'image_600x600' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0001	SELECT * FROM (`media`) WHERE `media`.`media_id` = '641'
0.0001	SELECT * FROM (`mime_types`) WHERE `mime_types`.`extension` = 'jpg'
0.0001	SELECT * FROM (`media_metadata`) WHERE `media_id` = '641'
0.0001	SELECT `parent_id` FROM (`products`) WHERE `prod_id` = '1332'
0.0002	SELECT * FROM (`products`) WHERE `products`.`prod_id` = '1331'
0.0002	SELECT `product_categories__products`.`cat_id` FROM (`product_categories__products`) JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id` WHERE `product_categories__products`.`prod_id` = '1331' AND `product_categories`.`parent_id` = 1 AND `product_categories__products`.`cat_id` NOT IN (1, 261)
0.0002	SELECT * FROM (`authors`) JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id` WHERE `products__authors`.`prod_id` = '1331' ORDER BY `sort` ASC
0.0001	SELECT * FROM (`product_flags__products`) WHERE `prod_id` = '1331'
0.0002	SELECT `sku` FROM (`products__xsell`) WHERE `prod_id` = '1331' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0002	SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price` FROM (`products` AS p) JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id` WHERE `c`.`avail_id` IN ('A', 'B', 'D') AND `c`.`type_id` = 'V' AND `c`.`parent_id` = '1331'
0.0002	SELECT * FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `parent_id` = '1331' AND `type_id` = 'V' ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title`
0.0002	SELECT SQL_CALC_FOUND_ROWS media_id, position FROM (`media`) WHERE `foreign_key_table` = 'products' AND `foreign_key_column` = 'prod_id' AND `foreign_key_value` = '1331' AND `kind` = 'image_600x600' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0001	SELECT * FROM (`media`) WHERE `media`.`media_id` = '651'
0.0001	SELECT * FROM (`mime_types`) WHERE `mime_types`.`extension` = 'jpg'
0.0001	SELECT * FROM (`media_metadata`) WHERE `media_id` = '651'
0.0001	SELECT `parent_id` FROM (`products`) WHERE `prod_id` = '1338'
0.0002	SELECT * FROM (`products`) WHERE `products`.`prod_id` = '1337'
0.0002	SELECT `product_categories__products`.`cat_id` FROM (`product_categories__products`) JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id` WHERE `product_categories__products`.`prod_id` = '1337' AND `product_categories`.`parent_id` = 1 AND `product_categories__products`.`cat_id` NOT IN (1, 261)
0.0002	SELECT * FROM (`authors`) JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id` WHERE `products__authors`.`prod_id` = '1337' ORDER BY `sort` ASC
0.0001	SELECT * FROM (`product_flags__products`) WHERE `prod_id` = '1337'
0.0002	SELECT `sku` FROM (`products__xsell`) WHERE `prod_id` = '1337' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0002	SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price` FROM (`products` AS p) JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id` WHERE `c`.`avail_id` IN ('A', 'B', 'D') AND `c`.`type_id` = 'V' AND `c`.`parent_id` = '1337'
0.0002	SELECT * FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `parent_id` = '1337' AND `type_id` = 'V' ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title`
0.0002	SELECT SQL_CALC_FOUND_ROWS media_id, position FROM (`media`) WHERE `foreign_key_table` = 'products' AND `foreign_key_column` = 'prod_id' AND `foreign_key_value` = '1337' AND `kind` = 'image_600x600' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0001	SELECT * FROM (`media`) WHERE `media`.`media_id` = '654'
0.0001	SELECT * FROM (`mime_types`) WHERE `mime_types`.`extension` = 'jpg'
0.0001	SELECT * FROM (`media_metadata`) WHERE `media_id` = '654'
0.0003	SELECT * FROM (`product_categories`) WHERE `status_id` = 'A' AND `parent_id` = 1 AND `cat_id` NOT IN (1, 261) ORDER BY `name`
0.0002	SELECT * FROM (`site_settings`) WHERE `option_key` = 'announcement'

HTTP_ACCEPT	/
HTTP_USER_AGENT	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_CONNECTION
SERVER_PORT	443
SERVER_NAME	mit-sloan.rarebirdinc.com
REMOTE_ADDR	3.137.217.235
SERVER_SOFTWARE	Apache
HTTP_ACCEPT_LANGUAGE
SCRIPT_NAME	/index.php
REQUEST_METHOD	GET
HTTP_HOST
REMOTE_HOST
CONTENT_TYPE
SERVER_PROTOCOL	HTTP/2.0
QUERY_STRING	cat_id=247&offset=130
HTTP_ACCEPT_ENCODING	gzip, br, zstd, deflate
HTTP_X_FORWARDED_FOR

session_id	27682f31e42cf1e45349c7da06638228
ip_address	3.137.217.235
user_agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
last_activity	1739455400
user_data
cart	Array ( [cart_id] => b558da1b290647f27553e20a7d5da1de [subtotal] => Array ( [Physical] => 0 [PDF] => 0 [Zip] => 0 [Audio] => 0 [Video] => 0 [Digital Replica] => 0 [eBook] => 0 [Certificate] => 0 [Print Sub] => 0 [Digital Sub] => 0 [Combo Sub] => 0 [Shippable] => 0 ) [item_count] => Array ( [Physical] => 0 [PDF] => 0 [Zip] => 0 [Audio] => 0 [Video] => 0 [Digital Replica] => 0 [eBook] => 0 [Certificate] => 0 [Print Sub] => 0 [Digital Sub] => 0 [Combo Sub] => 0 [Shippable] => 0 ) [contains_books] => 0 )

base_url	https://mit-sloan.rarebirdinc.com/
index_page
uri_protocol	AUTO
url_suffix
url_allowed_suffixes	Array ( [0] => html )
language	english
charset	UTF-8
enable_hooks	1
subclass_prefix	MY_
permitted_uri_chars	a-z 0-9~%.:_\-
allow_get_array	1
enable_query_strings
controller_trigger	c
function_trigger	m
directory_trigger	d
log_threshold	4
log_path	/var/www/mit-sloan.com/logs/
log_date_format	Y-m-d H:i:s
cache_path
encryption_key	pIck\|3j@rZ
sess_cookie_name	ci_session
sess_expiration	7200
sess_expire_on_close
sess_encrypt_cookie
sess_use_database	1
sess_table_name	sessions
sess_match_ip
sess_match_useragent
sess_time_to_update	3000
cookie_prefix
cookie_domain	.mit-sloan.rarebirdinc.com
cookie_path	/
cookie_secure
global_xss_filtering
csrf_protection
csrf_token_name	csrf_test_name
csrf_cookie_name	csrf_cookie_name
csrf_expire	7200
compress_output
time_reference	local
rewrite_short_tags
proxy_ips
globals	Array ( [org] => SMR [company_name] => MIT Sloan Management Review [cs_address_1] => 238 Main Street E48-570 [cs_address_2] => [cs_city] => Cambridge [cs_state] => MA [cs_zip] => 02142 [cs_phone] => 617-253-7170 [cs_fax] => 617-258-9739 [cs_hours] => 8 a.m. - 5 p.m. [EST] Mon. - Fri. [cs_email] => smr-help@mit.edu [triliteral_email] => orders@triliteral.org [mit_issues_email] => smr-issues@mit.edu [order_confirm_email] => smr-noreply@sloan.mit.edu [webmaster_email] => webmaster@rarebirdinc.com [inventory_recips] => developer@rarebirdinc.com [meta_description] => MIT Sloan Management Review's online store [meta_keywords] => [copyright] => Copyright © Massachusetts Institute of Technology, 2025. All rights reserved. [ga_account] => [recaptcha] => Array ( [public_key] => [private_key] => ) [enable_users] => [doc_root] => /var/www/mit-sloan.com/web [media_path] => /var/www/mit-sloan.com/web/media [data_path] => /var/www/mit-sloan.com/web/../data [csv_path] => /var/www/mit-sloan.com/web/../data/csv [ini_path] => /var/www/mit-sloan.com/web/../data/ini [pdf_path] => /var/www/mit-sloan.com/web/../data/pdf [certificate_pdf_path] => /var/www/mit-sloan.com/web/../data/certificate_pdf [audio_path] => /var/www/mit-sloan.com/web/../data/audio [video_path] => /var/www/mit-sloan.com/web/../data/video [zip_path] => /var/www/mit-sloan.com/web/../data/zip [epub_path] => /var/www/mit-sloan.com/web/../data/epub [mobi_path] => /var/www/mit-sloan.com/web/../data/mobi [cli_path] => /var/www/mit-sloan.com/application/controllers/cli [title_suffix] => - MIT SMR Store [seo] => Array ( [default_title] => MIT SMR Store [og_image] => http://mit-sloan.rarebirdinc.com/assets/images/mit-smr-social-default.png ) [default_meta] => Array ( [description] => MIT Sloan Management Review's online store [keywords] => [copyright] => Copyright © Massachusetts Institute of Technology, 2025. All rights reserved. [author] => MIT Sloan Management Review ) [main_site_url] => http://sloanreview.mit.edu [license_agreement_pdf_url] => /pdf/MgmtReportLicensingAgreement.pdf [permission_to_copy_min_qty] => 5 [adminbghex] => #c9c9c9 [adminfghex] => #e9e9e9 [adminac1hex] => #a9a9a9 [default_product_thumbnail] => /assets/images/MITSMR_cover.jpg [default_product_cover] => /assets/images/MITSMR_cover.jpg [sendgrid_api_key] => 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 )
template	Array ( [default_layout] => layouts/application [enable_view_path_comment] => 1 )
sfg	Array ( [debug] => 0 [log] => 1 [notify] => 1 [timeout] => 10 [test_mode] => [remote_host] => api.sfgnetwork.com [remote_port] => 443 [remote_uri] => /websvcapps/services/https/process_xmlrpc.php [remote_method] => process_xmlrpc [services] => Array ( [ecommerce_order] => Array ( [user] => 122f2eb252faa4e4b86193e483bd2b52 [pass] => 21598fa307e843648856f0c3f41bfbc5 ) [product_status] => Array ( [user] => 1ec0e02302ef35e38fb75f6d13670357 [pass] => 36375bce7741df326faec39f71240d5e ) ) )