Books & Guides

Books & Guides
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_1` ON mst_sorting_index_1.product_id = e.entity_id AND mst_sorting_index_1.store_id = 1 LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_0` ON mst_sorting_index_0.product_id = e.entity_id AND mst_sorting_index_0.store_id = 0 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id LEFT JOIN `inventory_stock_2` AS `stock_status_index` ON product.sku = stock_status_index.sku WHERE (e.entity_id IN (10917, 10918, 11696, 6264, 8581, 8582, 8584, 8585, 8586, 9406, 9407, 9408, 9410, 9413, 9414, 9415, 9416, 9418, 9419, 9420, 9421, 9423, 9424, 9425, 272, 852, 853, 855, 856, 1612)) ORDER BY IFNULL(mst_sorting_index_1.factor_2_score, IFNULL(mst_sorting_index_0.factor_2_score, 0)) * 50 desc, FIELD(e.entity_id,10917,10918,11696,6264,8581,8582,8584,8585,8586,9406,9407,9408,9410,9413,9414,9415,9416,9418,9419,9420,9421,9423,9424,9425,272,852,853,855,856,1612)
View as Grid List

Items 1-30 of 145

Page
per page
Set Ascending Direction
  1. SKU: COU-00009
    Model: 1435460287
    Condition: New-In-Box
  2. Course Technology David Busch's Nikon D5100 Guide to Digital SLR Photography
    USD $26.97
    Out of stock
    SKU: COU-00009F
    Model: 1435460850
    Condition: New-In-Box
  3. Ammonite Press Nikon D5100: The Expanded Guide
    USD $17.97
    Out of stock
    SKU: AMM-19935
    Model: 19935
    Condition: New-In-Box
  4. Sterling Publishing Co Inc Magic Lantern Guides: Nikon D3000
    USD $17.97
    SKU: STL-00571S
    Model: 9781600596704
    Condition: New-In-Box
  5. Course Technology Photocine: Digital Filmmaking with DSLRs
    USD $26.97
    Out of stock
    SKU: COU-00008E
    Model: 1435457362
    Condition: New-In-Box
  6. Course Technology David Busch's Compact Field Guide for the Canon EOS 7D
    USD $12.59
    Out of stock
    SKU: COU-00008H
    Model: 1435458789
    Condition: New-In-Box
  7. Course Technology David Busch's Compact Field Guide for the Canon EOS 60D
    USD $26.97
    Out of stock
    SKU: COU-00008P
    Model: 1435459380
    Condition: New-In-Box
  8. Course Technology David Busch's Nikon D7000 Guide to Digital SLR Photography
    USD $26.97
    Out of stock
    SKU: COU-00008S
    Model: 1435459427
    Condition: New-In-Box
  9. SKU: COU-00008V
    Model: 1435459441
    Condition: New-In-Box
  10. Course Technology Best Business Practices for Photographers, 2nd Edition
    USD $31.49
    Out of stock
    SKU: COU-00002
    Model: 1435454294
    Condition: New-In-Box
  11. SKU: COU-00002G
    Model: 1435454330
    Condition: New-In-Box
  12. Course Technology David Busch's Nikon D3s/D3x Guide to Digital SLR Photography
    USD $26.97
    Out of stock
    SKU: COU-00003
    Model: 1435454347
    Condition: New-In-Box
  13. Course Technology David Busch's Canon EOS 7D Guide to Digital Photography
    USD $26.97
    Out of stock
    SKU: COU-00008
    Model: 1435456914
    Condition: New-In-Box
  14. Course Technology Mastering Digital Nude Photography
    USD $35.97
    Out of stock
    SKU: COU-00060
    Model: 1598630261
    Condition: New-In-Box
  15. Course Technology David Busch's Quick Snap Guide to Photo Gear
    USD $26.97
    Out of stock
    SKU: COU-00100
    Model: 1598634542
    Condition: New-In-Box
  16. SKU: COU-00105
    Model: 1598635298
    Condition: New-In-Box
  17. Course Technology David Busch's Nikon D300 Guide to Digital SLR Photography
    USD $26.97
    Out of stock
    SKU: COU-00110
    Model: 1598635344
    Condition: New-In-Box
  18. Course Technology David Busch's Quick Snap Guide To Lighting
    USD $26.97
    Out of stock
    SKU: COU-00115
    Model: 1598635484
    Condition: New-In-Box
  19. Course Technology Digital Sports Photography, 2nd Edition
    USD $31.47
    Out of stock
    SKU: COU-00120
    Model: 1598635697
    Condition: New-In-Box
  20. Course Technology David Busch's Nikon D60 Guide to Digital SLR Photography
    USD $26.97
    Out of stock
    SKU: COU-00125
    Model: 1598635778
    Condition: New-In-Box
  21. Course Technology David Busch's Nikon D90 Guide to Digital SLR Photography
    USD $26.97
    Out of stock
    SKU: COU-00128
    Model: 1598639056
    Condition: New-In-Box
  22. Course Technology David Busch's Canon EOS 50D Guide to Digital SLR Photography
    USD $26.97
    Out of stock
    SKU: COU-00135
    Model: 1598639048
    Condition: New-In-Box
  23. Course Technology David Busch's Compact Field Guide for the Nikon D7000
    USD $26.97
    Out of stock
    SKU: COU-00140
    Model: 1598639927
    Condition: New-In-Box
  24. Course Technology Irreverent Photo Tools for Digital Photographers
    USD $26.97
    Out of stock
    SKU: COU-00150
    Model: 1598639951
    Condition: New-In-Box
  25. Photo Retouching with Photoshop
    Amherst Media Photo Retouching with Photoshop
    USD $29.97
    SKU: BOO-00100
    Model: 1584280808
    Condition: New-In-Box
  26. David Busch's Nikon D300S Guide to Digital SLR Photography
    Course Technology David Busch's Nikon D300S Guide to Digital SLR Photography
    USD $26.97
    Out of stock
    SKU: COU-00005
    Model: 1435456319
    Condition: New-In-Box
  27. Thomson Course Technology Digital Black and White Photography
    USD $3.00
    Out of stock
    SKU: COU-00025
    Model: 1592004725
    Condition: New-In-Box
  28. Thomson Course Technology Digital SLR Pro Secrets
    USD $35.97
    Out of stock
    SKU: COU-00055
    Model: 1598630199
    Condition: New-In-Box
  29. Mastering Digital Wedding Photography
    Thomson Course Technology Mastering Digital Wedding Photography
    USD $35.97
    Out of stock
    SKU: COU-00075
    Model: 1598633295
    Condition: New-In-Box
  30. Thomson Course Technology Mastering Digital Photography, 2nd Edition
    USD $35.97
    Out of stock
    SKU: COU-00050
    Model: 1598630172
    Condition: New-In-Box
View as Grid List

Items 1-30 of 145

Page
per page
Set Ascending Direction