Books & Guides

Books & Guides
Shop By
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 (11696, 14304, 14305, 179306, 46505, 46507, 46509, 46511, 46514, 18625, 18626, 20294, 21298, 21305, 21306, 81284, 16513, 16514, 17431, 17432, 17433, 17434, 17435, 14661, 14662, 16192)) 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,11696,14304,14305,179306,46505,46507,46509,46511,46514,18625,18626,20294,21298,21305,21306,81284,16513,16514,17431,17432,17433,17434,17435,14661,14662,16192)
View as Grid List

26 Items

per page
Set Ascending Direction
  1. Ammonite Press Nikon D5100: The Expanded Guide
    USD $17.97
    Out of stock
    SKU: AMM-19935
    Model: 19935
    Condition: New-In-Box
  2. Ammonite Press Lenses for Digital SLRS Expanded Guide
    USD $17.97
    Out of stock
    SKU: AMM-19544
    Model: 9781907708343
    Condition: New-In-Box
  3. Ammonite Press HDR Photography
    USD $17.97
    Out of stock
    SKU: AMM-20226
    Model: 9781907708541
    Condition: New-In-Box
  4. The Expanded Guide: Canon EOS 80D
    Ammonite Press The Expanded Guide: Canon EOS 80D
    USD $23.95
    Out of stock
    SKU: AMM-26796
    Model: 9781781452813
    Condition: New-In-Box
  5. The Expanded Guide: Nikon D750
    Ammonite Press The Expanded Guide: Nikon D750
    USD $17.97
    Out of stock
    SKU: AMM-24768
    Model: 9781781451427
    Condition: New-In-Box
  6. The Expanded Guide: Canon EOS 7D Mark II
    Ammonite Press The Expanded Guide: Canon EOS 7D Mark II
    USD $17.97
    Out of stock
    SKU: AMM-24805
    Model: 9781781451434
    Condition: New-In-Box
  7. The Expanded Guide: Nikon D5500
    Ammonite Press The Expanded Guide: Nikon D5500
    USD $17.97
    Out of stock
    SKU: AMM-25397
    Model: 9781781452080
    Condition: New-In-Box
  8. The Expanded Guide: Canon EOS Rebel T6s/760D and T6i/750D
    SKU: AMM-25471
    Model: 9781781452219
    Condition: New-In-Box
  9. The Expanded Guide: Nikon D7200
    Ammonite Press The Expanded Guide: Nikon D7200
    USD $17.97
    Out of stock
    SKU: AMM-25528
    Model: 9781781452295
    Condition: New-In-Box
  10. Ammonite Press Nikon D3300: The Expanded Guide
    USD $17.97
    Out of stock
    SKU: AMM-23609
    Model: 9781781451045
    Condition: New-In-Box
  11. Ammonite Press Canon's Rebel T5/EOS1200D: The Expanded Guide
    USD $17.97
    Out of stock
    SKU: AMM-23869
    Model: 9781781451069
    Condition: New-In-Box
  12. Ammonite Press Nikon D810: The Expanded Guide
    USD $17.97
    Out of stock
    SKU: AMM-24439
    Model: 9781781451151
    Condition: New-In-Box
  13. Ammonite Press Canon EOS 6D: The Expanded Guide
    USD $17.97
    Out of stock
    SKU: AMM-21520
    Model: 9781781450376
    Condition: New-In-Box
  14. Ammonite Press Nikon D7100: The Expanded Guide
    USD $17.97
    Out of stock
    SKU: AMM-22342
    Model: 9781781450543
    Condition: New-In-Box
  15. Canon Rebel T5i: The Expanded Guide
    Ammonite Press Canon Rebel T5i: The Expanded Guide
    USD $17.97
    Out of stock
    SKU: AMM-22552
    Model: 9781781450574
    Condition: New-In-Box
  16. The Expanded Guide : Canon Rebel T6/EOS 1300D
    Ammonite Press The Expanded Guide : Canon Rebel T6/EOS 1300D
    USD $23.95
    Out of stock
    SKU: AMM-26886
    Model: 26886
    Condition: New-In-Box
  17. Ammonite Press Nikon D3200: The Expanded Guide
    USD $17.97
    Out of stock
    SKU: AMM-21011
    Model: 21011
    Condition: New-In-Box
  18. Ammonite Press Canon Rebel T4i/EOS 650D: The Expanded Guide
    USD $17.97
    Out of stock
    SKU: AMM-21365
    Model: 9781907708961
    Condition: New-In-Box
  19. Digital Macro and Close-up Photography: Revised and Expanded Edition
    SKU: AMM-20462
    Model: 9781907708763
    Condition: New-In-Box
  20. Ammonite Press Understanding Composition
    USD $19.97
    Out of stock
    SKU: AMM-22267
    Model: 9781781450512
    Condition: New-In-Box
  21. Ammonite Press Mastering Composition
    USD $29.97
    Out of stock
    SKU: AMM-22692
    Model: 9781781450635
    Condition: New-In-Box
  22. Ammonite Press Canon EOS 70D: The Expanded Guide
    USD $19.97
    Out of stock
    SKU: AMM-22834
    Model: 9781781450697
    Condition: New-In-Box
  23. Ammonite Press The Expanded Guide: Nikon D5300
    USD $19.97
    Out of stock
    SKU: AMM-23287
    Model: 9781781450963
    Condition: New-In-Box
  24. Ammonite Press Sony SLT-A77: The Expanded Guide
    USD $17.97
    Out of stock
    SKU: AMM-20762
    Model: 9781907708855
    Condition: New-In-Box
  25. Nikon D800 and D800E: The Expanded Guide
    Ammonite Press Nikon D800 and D800E: The Expanded Guide
    USD $17.97
    Out of stock
    SKU: AMM-20761
    Model: 9781907708862
    Condition: New-In-Box
  26. Canon EOS 5D Mark III: The Expanded Guide
    Ammonite Press Canon EOS 5D Mark III: The Expanded Guide
    USD $17.97
    Out of stock
    SKU: AMM-20980
    Model: 9781907708930
    Condition: New-In-Box
View as Grid List

26 Items

per page
Set Ascending Direction