Skip to content

Marketing P. 9

Page 19 of 21

  • Surprise as a Marketing Tool

    Customer delight might not always lead to long-term satisfaction and loyalty.

    More

  • Pricing as a Strategic Capability

    If pricing isn't a strategic capability — a contributor to a company's ability to implement its strategy — it's probably a strategic liability.

    More

  • Changing the Channel: A Better Way To Do Trade Promotions

    In theory, trade promotions should benefit everyone involved. In practice, however, manufacturers and retailers often use trade promotions as weapons in a zero-sum game, and consumers are sometimes left out altogether. It need not be that way. Over the past three years, David Bell, an associate professor of marketing at the University of Pennsylvania’s Wharton School, and Xavier Dr_ze, a visiting assistant professor of marketing at UCLA’s Anderson School, have examined the theoretical and practical problems associated with trade promotions, and they explain how the right kind of deal can be created & #8212; a transparent system that generates mutual trust and provides benefits to both manufacturers and retailers. The key is proper implementation of what is thus far a little understood tool: the pay-for-performance trade promotion, in which retailers get rewarded according to how much they sell, not how much they buy. The authors explain how the most accepted way of doing promotions today & #8212; which rewards retailers for effective buying rather than effective marketing & #8212; creates a variety of inefficiencies that drain resources from their intended purpose. Using a hypothetical case involving much-simplified mathematics, they go on to demonstrate how manufacturers can design pay-for-performance options that retailers can embrace. They also illustrate how one national beverage company made pay-for-performance deals work in practice. Finally, they offer practical advice to help senior managers rethink the elements of organizational culture that stand in the way of a more effective approach to trade promotions & #8212; and, by extension, block better, more profitable relationships all along the channel.

    More

  • The Real Value of Customer Loyalty

    Customer-lifetime value is more than a metric; it's a way of thinking and of doing business.

    More

  • How Much Will People Pay for That?

    A new, easy-to-use procedure can help marketers determine customers' willingness to pay.

    More

  • Attention, Retailers! How Convenient Is Your Convenience Strategy?

    Many retailers proudly declare their commitment to customer convenience. However, few define convenience from the customer's point of view or systematically craft a convenience strategy. Confronting more retail options than ever, customers value speed and ease at every stage of the retail transaction. Pressed for time, they place a premium on such store features as one-stop shopping, clearly marked aisles, in-stock merchandise, clearly presented pricing, sufficient staffing, efficient checkouts, expanded hours, and easy returns. The retailer that meets these needs and spares its customers needless delays wins their loyalty and outperforms the competition. Some high-performing retailers demonstrate genuine respect for customers' time and effort by viewing the retail experience as an integrated whole consisting of distinct but related parts. These stores enhance the convenience of their market offerings in four main ways: by ensuring that the store's services and products are easy to reach, by enabling customers to speedily identify and select the products they want, by making it easy for customers to obtain desired products, and by expediting the purchase and return of products. The authors cite many real-life examples, including Walgreen, Staples, LensCsrafters, Dell, L.L. Bean, and Dial-A-Mattress, which demonstrate the innovative ways companies address forms of convenience. For example, access considerations may include physical location, parking, store hours, proximity to other stores, and telephone and Internet access. Intelligent store design and layout, knowledgeable salespeople, customer interactive systems, and clear signage are also critical aids in expediting the shopping experience. In regard to providing what a customer wants, in-stock merchandise, timely production, and timely delivery are relevant factors. Self-scanning at checkout counters, drive-through windows, and purchase guarantees are among the ways that retailers can make it easy for customers to complete or adjust their purchases. The most successful retailers invest in all four forms of convenience.

    More

  • Understanding Customer Delight and Outrage

    Evidence indicates that satisfied customers defect at a high rate in many industries. Because satisfaction alone does not translate linearly into outcomes such as loyalty in terms of purchases, businesses must strive for 100 percent, or total, customer satisfaction and even delight to achieve the kind of loyalty they desire. Current studies attribute a higher degree of emotionality to the dissatisfaction end of the satisfaction continuum than in the past. For example, customers who have experienced service failures feel annoyed or victimized. Although victimization is felt at a deeper emotional level than irritation, both can result in outrage. By focusing on more intense customer emotions, such as outrage and delight, the authors explore the dynamics of customer emotions and their effect on customer behavior and loyalty. Schneider and Bowen base their conceptualization on people's needs rather than the more conventional model that focuses on customer expectations about their interactions with a firm. The authors propose a complementary needs-based model for service businesses that assumes customer delight and outrage originate with the handling of three basic human needs -- security, justice, and self-esteem. By recasting a situation as one that has violated any of a customer's fundamental needs, the deeper emotional outcome (e.g., outrage) does not seem incongruous. The authors describe each need and offer specific managerial tactics for avoiding outrage and creating delight. Recent emphasis on relationship marketing -- that is, attracting, developing, and retaining customers -- is pertinent because building relationships requires that companies view customers as people first and consumers second. Service is an exchange relationship in which customers swap their money and loyalty for what Schneider and Bowen argue is need gratification -- a psychological contract with service firms to have their needs gratified. The authors discuss strategies that help firms gratify and, in some cases, delight customers, while avoiding the perception that they do not respect customer needs. Companies must manage how they show concern for customer needs in all actions, including the activities of the back office (e.g., billing, shipping), not just front-office personnel who directly contact the customer.

    More

  • Winning in Smart Markets

    Smart markets, or markets defined by frequent turnover in the general stock of knowledge or information embodied in products and possessed by competitors and consumers, are based on new kinds of products, competitors, and customers. As a result, companies seek to understand the degree to which their own capabilities and motivations as information-processing "organisms" are crucial in enabling them to extract maximum value from their customer information assets. Firms that have gained a significant competitive advantage are distinguished by their ability to see beyond their IT infrastructure and view information itself as the core asset and the management of information as the company's main priority. Understanding how consumers are adapting their behavior to the demands of an increasingly information-intensive environment has been a starting point for companies that have achieved success in smart markets. By observing the activities of these firms across industries, it is possible to identify generic strategies and develop a preliminary taxonomy, or categorization scheme, that can be used to compare and contrast them. The placement of individual strategies within a conceptual framework guides managers in making customer-management decisions. The organizing tool, or asset around which the full range of strategies is based, is the customer information file (CIF) -- a single virtual database that captures all relevant information about a firm's customers. Underlying the notion of the CIF as the key asset is the assumption that the firm's operational goal is to maximize communication with its customers -- to look for every opportunity to "talk" with them. After all, the data collected from these interactions are the raw material from which companies craft their information-intensive strategies. A company thus sets as its main objective the maximizing of returns to the CIF. It then chooses any one of several strategies to accomplish that objective. This approach represents a shift in performance goals. In particular, concepts such as profitability or market share per product are being replaced with concepts such as profitability per customer (sometimes referred to as "lifetime value of a customer") or customer share (the total share of a customer's purchases in a broadly defined product category).

    More

  • A Dynamic View of Strategy

    Choosing a distinctive strategic position involves making tough choices on three dimensions: who to target as customers, what products to offer, and how to undertake related activities efficiently. The most common source of strategic failure is the inability to make clear, explicit choices on these three dimensions. Unfortunately, not only will aggressive competitors imitate attractive positions, but, perhaps more importantly, new strategic positions will be emerging continually. In industry after industry, once formidable companies with seemingly unassailable strategic positions are humbled by relatively unknown companies that base their attacks on creating and exploiting new strategic positions. Markides describes incursions into established markets by strategic innovators such as Canon and the brokerage firm Edward Jones. The hallmark of their success is strategic innovation -- proactively establishing distinctive strategic positions that are critical to shifting market share or creating new markets. To prepare for the inevitable strategic innovation that will disrupt its market, an organization should: -- Identify turning points before a crisis occurs by regularly monitoring indicators of strategic rather than financial health in the market. -- Prevent cultural and structural inertia by creating a culture that welcomes change and is ready to accept new strategic innovation even if it disrupts the status quo. -- Develop processes that allow experimenting with new ideas to reveal the potential of a new innovation. -- Develop the required competencies and skills. -- Manage a transition to the new strategic position by clearly deciding whether to adopt the new position and by ensuring that old and new coexist harmoniously. Designing a successful strategy is a never-ending, dynamic process of identifying and colonizing a distinctive strategic position; excelling in this position while concurrently searching for, finding, and cultivating another viable strategic position; simultaneously managing both positions; slowly making a transition to the new position as the old one matures and declines; and starting the cycle again.

    More

  BENCHMARKS  
Loading Time: Base Classes  0.0006
My Controller Construct  0.0003
Build Nav  0.0008
Controller Execution Time ( Products / Route )  0.0646
Total Execution Time  0.0652
  GET DATA  
$_GET['cat_id']   247
$_GET['offset']   180
  MEMORY USAGE  
1.9483 MB
  POST DATA  
No POST data exists
  URI STRING  
store/marketing
  CLASS/METHOD  
products/route
  DATABASE:  MITSLOAN_DEV   QUERIES: 147  (Hide)
0.0003  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0003  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '54efeb354dd4b71a4c1918e1aee984a0'
ORDER BY `created_atDESC 
0.0004  

SELECT `parent_id`
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
skuIN ('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` =  
0.0038  

SELECT c.parent_idc.format_id
                    FROM products 
AS pproducts AS cproduct_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.0007  

SELECT `cat_idAS id, `parent_idAS 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 010) AS, `position`, `name
0.0003  

SELECT SQL_CALC_FOUND_ROWS media_idposition
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 010) AS, `position
0.0063  

SELECT SQL_CALC_FOUND_ROWS p.prod_id AS parent_idp.pool_id AS parent_pool_idp.type_id AS parent_type_idp.title AS parent_titlep.description AS parent_descriptionp.url_friendly AS parent_url_friendlyp.product_typep.publication_datec.prod_idc.avail_idc.type_idc.skuc.titlec.pricec.sale_pricec.toggle_inventory_apic.qty_availablec.expected_dateproduct_categories__products.cat_idCOALESCE(product_categories.name'') as category_name
FROM 
(`productsAS 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_dateDESC, `p`.`title`, `c`.`title`
LIMIT 10 OFFSET 180 
0.0001  

SELECT FOUND_ROWS() AS total 

0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '1844' 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1843' 
0.0002  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categoriesON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1843'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0004  

SELECT `cat_idAS id, `parent_idAS 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 010) AS, `position`, `name
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authorsON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1843'
ORDER BY `sortAS
0.0001  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1843' 
0.0002  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1843'
ORDER BY IF(position 010) AS, `position
0.0002  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_idIN ('A''B''D') 
AND `
c`.`type_id` =  'V'
AND `c`.`parent_id` =  '1843' 
0.0002  

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1843'
AND `type_id` =  'V'
ORDER BY IF(position 010) AS, `position`, `title
0.0002  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1843'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0002  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '1914' 
0.0003  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1913' 
0.0004  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categoriesON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1913'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0005  

SELECT *
FROM (`authors`)
JOIN `products__authorsON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1913'
ORDER BY `sortAS
0.0001  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1913' 
0.0002  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1913'
ORDER BY IF(position 010) AS, `position
0.0002  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_idIN ('A''B''D') 
AND `
c`.`type_id` =  'V'
AND `c`.`parent_id` =  '1913' 
0.0002  

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1913'
AND `type_id` =  'V'
ORDER BY IF(position 010) AS, `position`, `title
0.0003  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1913'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0003  

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '894' 
0.0001  

SELECT *
FROM (`mime_types`)
WHERE `mime_types`.`extension` =  'jpg' 
0.0001  

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '894' 
0.0002  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '1948' 
0.0006  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1947' 
0.0002  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categoriesON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1947'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0003  

SELECT *
FROM (`authors`)
JOIN `products__authorsON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1947'
ORDER BY `sortAS
0.0001  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1947' 
0.0001  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1947'
ORDER BY IF(position 010) AS, `position
0.0004  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_idIN ('A''B''D') 
AND `
c`.`type_id` =  'V'
AND `c`.`parent_id` =  '1947' 
0.0003  

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1947'
AND `type_id` =  'V'
ORDER BY IF(position 010) AS, `position`, `title
0.0005  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1947'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '904' 
0.0001  

SELECT *
FROM (`mime_types`)
WHERE `mime_types`.`extension` =  'jpg' 
0.0001  

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '904' 
0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '1966' 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1965' 
0.0005  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categoriesON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1965'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authorsON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1965'
ORDER BY `sortAS
0.0001  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1965' 
0.0002  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1965'
ORDER BY IF(position 010) AS, `position
0.0002  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_idIN ('A''B''D') 
AND `
c`.`type_id` =  'V'
AND `c`.`parent_id` =  '1965' 
0.0003  

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1965'
AND `type_id` =  'V'
ORDER BY IF(position 010) AS, `position`, `title
0.0003  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1965'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '2008' 
0.0001  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '2007' 
0.0003  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categoriesON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '2007'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authorsON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '2007'
ORDER BY `sortAS
0.0001  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '2007' 
0.0003  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '2007'
ORDER BY IF(position 010) AS, `position
0.0002  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_idIN ('A''B''D') 
AND `
c`.`type_id` =  'V'
AND `c`.`parent_id` =  '2007' 
0.0005  

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '2007'
AND `type_id` =  'V'
ORDER BY IF(position 010) AS, `position`, `title
0.0002  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '2007'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '2000' 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1999' 
0.0002  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categoriesON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1999'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authorsON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1999'
ORDER BY `sortAS
0.0002  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1999' 
0.0001  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1999'
ORDER BY IF(position 010) AS, `position
0.0003  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_idIN ('A''B''D') 
AND `
c`.`type_id` =  'V'
AND `c`.`parent_id` =  '1999' 
0.0003  

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1999'
AND `type_id` =  'V'
ORDER BY IF(position 010) AS, `position`, `title
0.0002  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1999'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0002  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '2160' 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '2159' 
0.0003  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categoriesON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '2159'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authorsON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '2159'
ORDER BY `sortAS
0.0001  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '2159' 
0.0003  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '2159'
ORDER BY IF(position 010) AS, `position
0.0002  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_idIN ('A''B''D') 
AND `
c`.`type_id` =  'V'
AND `c`.`parent_id` =  '2159' 
0.0002  

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '2159'
AND `type_id` =  'V'
ORDER BY IF(position 010) AS, `position`, `title
0.0011  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '2159'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '967' 
0.0001  

SELECT *
FROM (`mime_types`)
WHERE `mime_types`.`extension` =  'jpg' 
0.0001  

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '967' 
0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '2182' 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '2181' 
0.0002  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categoriesON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '2181'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authorsON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '2181'
ORDER BY `sortAS
0.0001  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '2181' 
0.0002  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '2181'
ORDER BY IF(position 010) AS, `position
0.0002  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_idIN ('A''B''D') 
AND `
c`.`type_id` =  'V'
AND `c`.`parent_id` =  '2181' 
0.0002  

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '2181'
AND `type_id` =  'V'
ORDER BY IF(position 010) AS, `position`, `title
0.0004  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '2181'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0002  

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '978' 
0.0001  

SELECT *
FROM (`mime_types`)
WHERE `mime_types`.`extension` =  'jpg' 
0.0002  

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '978' 
0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '2196' 
0.0003  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '2195' 
0.0004  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categoriesON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '2195'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authorsON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '2195'
ORDER BY `sortAS
0.0002  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '2195' 
0.0001  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '2195'
ORDER BY IF(position 010) AS, `position
0.0003  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_idIN ('A''B''D') 
AND `
c`.`type_id` =  'V'
AND `c`.`parent_id` =  '2195' 
0.0003  

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '2195'
AND `type_id` =  'V'
ORDER BY IF(position 010) AS, `position`, `title
0.0004  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '2195'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '985' 
0.0002  

SELECT *
FROM (`mime_types`)
WHERE `mime_types`.`extension` =  'jpg' 
0.0001  

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '985' 
0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '2206' 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '2205' 
0.0003  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categoriesON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '2205'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0004  

SELECT *
FROM (`authors`)
JOIN `products__authorsON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '2205'
ORDER BY `sortAS
0.0002  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '2205' 
0.0003  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '2205'
ORDER BY IF(position 010) AS, `position
0.0003  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_idIN ('A''B''D') 
AND `
c`.`type_id` =  'V'
AND `c`.`parent_id` =  '2205' 
0.0004  

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '2205'
AND `type_id` =  'V'
ORDER BY IF(position 010) AS, `position`, `title
0.0003  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '2205'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '990' 
0.0003  

SELECT *
FROM (`mime_types`)
WHERE `mime_types`.`extension` =  'jpg' 
0.0001  

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '990' 
0.0004  

SELECT *
FROM (`product_categories`)
WHERE `status_id` =  'A'
AND `parent_id` =  1
AND `cat_idNOT IN (1261) 
ORDER BY `name
0.0002  

SELECT *
FROM (`site_settings`)
WHERE `option_key` =  'announcement' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)