Egyptian Art

FILTERS:

SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `e`.`name`, `e`.`sku`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`color`, `e`.`color_value`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`url_key`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`giftcard_amounts`, `e`.`allow_open_amount`, `e`.`open_amount_min`, `e`.`open_amount_max`, `e`.`tax_class_id`, `e`.`swatch_image`, `e`.`was_price`, `e`.`member_price`, `e`.`member_was_price`, `e`.`launch_date`, `e`.`book_language`, `e`.`book_language_value`, `e`.`giftcard_amt`, `e`.`giftcard_amt_value`, `e`.`more_ways_to_shop`, `e`.`size_2`, `e`.`size_2_value`, `e`.`hover_image`, `e`.`bv_feed_exclude`, `e`.`sale_badge`, `e`.`am_shipping_type`, `e`.`am_shipping_type_value`, `e`.`price_range`, `e`.`bv_category_id`, `e`.`bv_category_id_value`, `e`.`custom_product_badge_block`, `e`.`pricing_details`, `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`, `product_entity`.`row_id`, `stock_status_index`.`stock_status` AS `is_salable`, `e_entity`.`row_id` FROM `catalog_product_flat_1` 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 `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_entity` ON product_entity.entity_id = e.entity_id AND (product_entity.created_in '1701957660') LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 INNER JOIN `catalog_product_entity` AS `e_entity` ON e_entity.entity_id = e.entity_id AND (e_entity.created_in '1701957660') WHERE (e.entity_id IN (193477, 193513, 192910, 193474, 193819, 186748, 7561, 12646, 8302, 88736, 88916, 187134, 189081, 184846, 186913, 190046, 9943, 9946, 190055, 12250, 189824, 185572, 194329, 186406, 9940, 195559, 11746, 184498, 7738, 193375, 187140, 188652, 163342, 163330, 186868, 186754, 186751, 15493, 20631, 34488, 162899, 34491, 34503, 165673, 191086, 38363)) ORDER BY FIELD(e.entity_id,193477,193513,192910,193474,193819,186748,7561,12646,8302,88736,88916,187134,189081,184846,186913,190046,9943,9946,190055,12250,189824,185572,194329,186406,9940,195559,11746,184498,7738,193375,187140,188652,163342,163330,186868,186754,186751,15493,20631,34488,162899,34491,34503,165673,191086,38363)
  1. Royal Egyptian Beaded Lapis Necklace
    Best Seller
    Royal Egyptian Beaded Lapis Necklace
    $125.00
    $125.00
    Royal Egyptian Beaded Lapis Necklace 1 5 5 1
  2. Middle Kingdom Cylindrical Bead Bangles
    $105.00
    $105.00
    Middle Kingdom Cylindrical Bead Bangles 15 4.8 5 1
  3. Middle Kingdom Cylindrical Bead Necklace
    $100.00
    As low as $100.00
    Middle Kingdom Cylindrical Bead Necklace 32 5 5 1
  4. Middle Kingdom Cylindrical Bead Earrings
    $60.00
    $60.00
    Middle Kingdom Cylindrical Bead Earrings 27 3.8 5 1
  5. Egyptian Fringe Collar Necklace
    $235.00
    $235.00
    Egyptian Fringe Collar Necklace 1 5 5 1
  6. Egyptian Cat Sculpture
    Best Seller
    Egyptian Cat Sculpture
    $345.00
    $345.00
    Egyptian Cat Sculpture 11 4.7 5 1
  7. Small Egyptian Cat Sculpture
    $45.00
    $45.00
    Small Egyptian Cat Sculpture 26 4.8 5 1
  8. Bastet Plush
    $24.95
    As low as $24.95
    Bastet Plush 10 4.9 5 1
  9. William Hippo Plush
    Best Seller
    William Hippo Plush
    $24.95
    $24.95
    William Hippo Plush 2 5 5 1
  10. Statuette of a Hippopotamus Sculpture
    $68.00
    $68.00
    Statuette of a Hippopotamus Sculpture 50 4.7 5 1
  11. William Eraser
    $4.95
    $4.95
    William Eraser 3 5 5 1
  12. Fun with Hieroglyphs, New Edition
    $34.99
    $34.99
    Fun with Hieroglyphs, New Edition 17 4.6 5 1
  13. New Kingdom Gems Hinged Cuff
    $175.00
    As low as $175.00
  14. Ancient Talisman Carnelian Necklace
    $98.00
    $98.00
    Ancient Talisman Carnelian Necklace 2 4 5 1
  15. Middle Kingdom Knot Two-Tone Bracelet
    $225.00
    $225.00
    Middle Kingdom Knot Two-Tone Bracelet 2 3.5 5 1
  16. Middle Kingdom Knot Two-Tone Ring
    $95.00
    As low as $95.00
    Middle Kingdom Knot Two-Tone Ring 3 4 5 1
  17. Lotus Bead Drop Earrings
    $38.00
    $38.00
    Lotus Bead Drop Earrings 13 4.5 5 1
  18. Lotus Bead Pendant Necklace
    $40.00
    $40.00
    Lotus Bead Pendant Necklace 2 3.5 5 1
  19. Egyptian Eye Stud Earrings
    $35.00
    $35.00
    Egyptian Eye Stud Earrings 1 5 5 1
  20. Footed Bowl Mini Sculpture
    $28.00
    $28.00
    Footed Bowl Mini Sculpture 3 2.4 5 1