Figures, Portraits
SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `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` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='1432'
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_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_product_index_eav` AS `layered_nav_name_of_artist` ON `layered_nav_name_of_artist`.`entity_id` = `e`.`entity_id` AND `layered_nav_name_of_artist`.`attribute_id` = '190' AND `layered_nav_name_of_artist`.`store_id` = '1' AND `layered_nav_name_of_artist`.`value` IN (3994,2731,2808) ORDER BY `cat_index`.`position` ASC
LIMIT 32
/Subject/Figures, Portraits
Shop By
Now Shopping by
Shopping Options
- Artist Razzia Remove This Item
- Artist Schmidt Remove This Item
- Artist Gould Remove This Item
Artist
- Gainsborough 1 item
- Valdes 1 item
- Adami 1 item
- Artschwager 1 item
- Aubert 1 item
- Baird 12 items
- Baj 2 items
- Barford 1 item
- Barnet 5 items
- Barney 1 item
- Baselitz 1 item
- Basquiat 1 item
- Bearden 2 items
- Beardsley 1 item
- Beaulieu 1 item
- Ben-Zion 2 items
- Berard 2 items
- Blake 1 item
- Blum 2 items
- Blumenfeld 2 items
- Bonnard 3 items
- Botero 15 items
- Boudet 1 item
- Brianchon 3 items
- Bridge 1 item
- Britto 1 item
- Britz 3 items
- Brouwer 1 item
- Brown 1 item
- Bull 1 item
- Cahen 1 item
- Cassatt 1 item
- Cesar 1 item
- Chagall 52 items
- Chardin 1 item
- Cheret 1 item
- Christus 1 item
- Chwast 2 items
- Clarke 1 item
- Clerisse 1 item
- Colbert 8 items
- Crook 1 item
- Croswell 1 item
- Da Correggio 1 item
- Da Vinci 3 items
- Dali 6 items
- Danby 1 item
- Darfeuil 1 item
- Daumier 2 items
- Davies and Douglas 1 item
- Davis 1 item
- De Saint 1 item
- De Stael 1 item
- Degas 3 items
- Depero 1 item
- Derain 1 item
- Dine 6 items
- Doisneau 2 items
- Draeger 2 items
- Dubin 2 items
- Dubuffet 2 items
- Duchamp 1 item
- Dufour 1 item
- Durer 1 item
- Edwards 5 items
- Ernst 1 item
- Erte 32 items
- Esler 1 item
- Farland 1 item
- Fischl 2 items
- Flandrin 1 item
- Folon 7 items
- Fragonard 1 item
- Frasconi 1 item
- Garache 1 item
- Geddes 1 item
- Giacometti 3 items
- Glaser 7 items
- Godunow 1 item
- Gonzales 1 item
- Gorman 3 items
- Gossaert 1 item
- Graf 1 item
- Graham 1 item
- Grau 1 item
- Greenblat 1 item
- Gruau 1 item
- Guys 2 items
- Halsman 1 item
- Hamilton 1 item
- Haring 5 items
- Helnwein 8 items
- Herge 6 items
- Hey 1 item
- Hiroshige 2 items
- Hockney 19 items
- Holbein 1 item
- Homer 1 item
- Hopper 1 item
- Indiana 3 items
- Ingres 2 items
- Jenkins 1 item
- Jichosai 1 item
- Kahlo 1 item
- Katz 2 items
- Keller 1 item
- Kim 1 item
- Kirchner 1 item
- Klee 3 items
- Klimt 2 items
- Laurencin 3 items
- Lavreince 2 items
- Lawrence 1 item
- Leger 7 items
- Leu 1 item
- Lichtenstein 13 items
- Lorjou 1 item
- Macke 1 item
- Magnelli 1 item
- Magritte 11 items
- Maillol 4 items
- Man Hoi 1 item
- Man Ray 4 items
- Manet 2 items
- Mariani 1 item
- Marisol 1 item
- Masson 1 item
- Matieu 1 item
- Meisel 2 items
- Menzel 1 item
- Miller 1 item
- Minaux 1 item
- Miralda 1 item
- Modigliani 7 items
- Monahan 1 item
- Moore 3 items
- Moreau 1 item
- Mori 1 item
- Nagel 3 items
- Nauman 1 item
- Neiman 3 items
- Oldenburg 1 item
- Patterson 1 item
- Peyton 1 item
- Pfeffer 1 item
- Picasso 70 items
- Porter 1 item
- Prendergast 2 items
- Ramos 1 item
- Rauschenberg 2 items
- Razzia 2 items
- Rebeyrolle 3 items
- Rembrandt 10 items
- Renoir 4 items
- Richter 1 item
- Rivera 3 items
- Rockwell 17 items
- Rodin 2 items
- Rosenquist 2 items
- Rouault 7 items
- Rousseau 3 items
- Saint Exupery 10 items
- Saint Phalle 3 items
- Salle 1 item
- Sandler 1 item
- Santi 2 items
- Saura 1 item
- Schiele 1 item
- Schlemmer 1 item
- Schmidt 1 item
- Schnabel 4 items
- Schonzeit 1 item
- Shahn 21 items
- Sherman 3 items
- Sieff 1 item
- Signac 1 item
- Simpson 1 item
- Smith 1 item
- Sorrenti 1 item
- Soyer 2 items
- Spruance 13 items
- Steinberg 2 items
- Sum 2 items
- Tarkay 1 item
- Tatafiore 5 items
- Thomas 2 items
- Ting 2 items
- Tobiasse 3 items
- Toulouse-Lautrec 24 items
- Tremois 1 item
- Trova 2 items
- Turner 1 item
- van Dongen 1 item
- van Gogh 1 item
- van Velde 1 item
- Various Artists 1 item
- Velazquez 1 item
- Vernet 1 item
- Villon 1 item
- Vincent 1 item
- Voinquel 1 item
- Warhol 48 items
- Weber 2 items
- Weld 1 item
- Wesselmann 7 items
- Wilson 2 items
- Wood 2 items
- Wunderlich 1 item
- Yokoo 1 item
- Chanel 1 item
- Blais 1 item
- Cassandre 5 items
- Calder 3 items
- Bacon 11 items
- Chagall 5 items
- Matisse 28 items
- Mucha 8 items
- Braque 3 items
- Lindner 7 items
- Rivers 2 items
- Close 3 items
- Baldessari 1 item
- Marshall 3 items
- Halsband 1 item
- Le Yaouanc 1 item
- Kunichika 1 item
- Malevich 1 item
- Kand 1 item
- Farin 1 item
- Echo 1 item
- Riefenstahl 1 item
- Field 1 item
- Helleu 1 item
- Cunningham 1 item
- Marini 4 items
- German School 1 item
- Flemish School 1 item
- Leclercq 1 item
- Unknown 93 items
- Auld 1 item
- Nathon 1 item
- Boisrond 1 item
- Pongracz 1 item
- Tuymans 1 item
- Piccillo 2 items
- Cortez 1 item
- Brueghel 1 item
- Raphael 1 item
- Starn 1 item
- Gould 1 item
- Hart Benton 1 item
- Kanovitz 1 item
- Carlu 1 item
- Heckel 1 item
- Lewis 1 item
- Beham 1 item
- Currin 1 item
- Abramovic 1 item
- Seidner 1 item
- Greenfield-Sanders 1 item
- Tanner 1 item
- Riml 1 item
- V.N. 1 item
- Coupon 1 item
- De Clerck 1 item
- Stark 1 item
- Tomek & Eryk 5 items
- Sikora 1 item
- Quijano 6 items
- Rafuse 1 item
- de Brunhoff 1 item
- Zucca 1 item
- Schoefft 1 item
- IIani 1 item
- Opitz 1 item
- Alys 1 item
- Mylnikov 1 item
- Lombardo 1 item
- McCavitt 1 item
- de Haan 1 item
- Griffit 1 item
- Appleton 1 item
- Donev 1 item
- de Bray 1 item
- Rogier 1 item
- Barrat 1 item
- Satok 1 item
- Hadi 1 item
- Derfler 1 item
- Carmi 1 item
- Girsch 1 item
- Amotz 1 item
- Coffin 1 item
- Kratzman 1 item
- Sharir 1 item
- De Mejo 1 item
- Van Hoeydock 2 items
- Mazonowicz 1 item
- Bachs 1 item
- McKowen 15 items
- Sanzio 1 item
- Bartholomew 1 item
- McCarthy 1 item
- Dempier 1 item
- Danska 6 items
- Fournier-Vitoria 1 item
Price
Color Profile
Shape
Space
Wish List