BuyArt.Club partners with Art Galleries, Artists and Art Dealers to bring the Best Selection of Art. Spotlight on Latin America, Middle East and Asia. Top Artists Worldwide. Art Advisory Service. Online Art Courses and Coaching. Paintings, Photographs, Drawings and more.
SELECT DISTINCT `e`.*, `at_category_id`.`category_id`, `at_userid`.`userid`, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status`, IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) AS `visibility`, `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 `osn_catalog_product_entity` AS `e`
LEFT JOIN `osn_catalog_category_product` AS `at_category_id` ON (at_category_id.`product_id`=e.entity_id)
LEFT JOIN `osn_marketplace_product` AS `at_userid` ON (at_userid.`mageproductid`=e.entity_id)
INNER JOIN `osn_catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '96') AND `at_status_default`.`store_id` = 0
LEFT JOIN `osn_catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '96') AND (`at_status`.`store_id` = 1)
INNER JOIN `osn_catalog_product_entity_int` AS `at_visibility_default` ON (`at_visibility_default`.`entity_id` = `e`.`entity_id`) AND (`at_visibility_default`.`attribute_id` = '102') AND `at_visibility_default`.`store_id` = 0
LEFT JOIN `osn_catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`entity_id` = `e`.`entity_id`) AND (`at_visibility`.`attribute_id` = '102') AND (`at_visibility`.`store_id` = 1)
INNER JOIN `osn_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 WHERE (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = 1) AND (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) = '4') AND (at_userid.userid IN('12873', '12879', '12880', '7560', '12871', '12872', '12878', '3051', '12874', '3053', '12876', '3048', '3046', '12877', '305', '6768', '6726', '12875', '3052', '6622', '7632', '6712', '12870', '7569', '7558', '6602')) AND (price_index.final_price = price_index.price) GROUP BY `e`.`entity_id` ORDER BY FIELD(at_userid.userid,12873,12879,12880,7560,12871,12872,12878,3051,12874,3053,12876,3048,3046,12877,305,6768,6726,12875,3052,6622,7632,6712,12870,7569,7558,6602)
SELECT DISTINCT `e`.*, `at_category_id`.`category_id`, `at_userid`.`userid`, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status`, IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) AS `visibility`, `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 `osn_catalog_product_entity` AS `e`
LEFT JOIN `osn_catalog_category_product` AS `at_category_id` ON (at_category_id.`product_id`=e.entity_id)
LEFT JOIN `osn_marketplace_product` AS `at_userid` ON (at_userid.`mageproductid`=e.entity_id)
INNER JOIN `osn_catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '96') AND `at_status_default`.`store_id` = 0
LEFT JOIN `osn_catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '96') AND (`at_status`.`store_id` = 1)
INNER JOIN `osn_catalog_product_entity_int` AS `at_visibility_default` ON (`at_visibility_default`.`entity_id` = `e`.`entity_id`) AND (`at_visibility_default`.`attribute_id` = '102') AND `at_visibility_default`.`store_id` = 0
LEFT JOIN `osn_catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`entity_id` = `e`.`entity_id`) AND (`at_visibility`.`attribute_id` = '102') AND (`at_visibility`.`store_id` = 1)
INNER JOIN `osn_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 WHERE (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = 1) AND (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) = '4') AND (at_userid.userid IN('12873', '12879', '12880', '7560', '12871', '12872', '12878', '3051', '12874', '3053', '12876', '3048', '3046', '12877', '305', '6768', '6726', '12875', '3052', '6622', '7632', '6712', '12870', '7569', '7558', '6602')) AND (price_index.final_price = price_index.price) GROUP BY `e`.`entity_id` ORDER BY FIELD(at_userid.userid,12873,12879,12880,7560,12871,12872,12878,3051,12874,3053,12876,3048,3046,12877,305,6768,6726,12875,3052,6622,7632,6712,12870,7569,7558,6602)
Since its inception, Opera Gallery has strived to offer museums, foundations and private international art collectors unique access to a diversity of Modern and Contemporary artists through an exciting programme of curated exhibitions and high profile art fairs. Notable exhibitions include Pablo Picasso in Monaco, Marc Chagall in London, Jean Michel Basquiat & Andy Warhol in Geneva, Jean Dubuffet & Alexander Calder in Geneva and two major Manolo Valdés exhibitions in Paris and Singapore.
Collage Workshop: Building a Narrative
Francis Bacon: Man and Beast
Late Constable
Madeleine Bialke
Donna Huddleston
Hande Sekerciler
Soane Lates
Faberge Egg Pendant
Faberge Egg Pendant
Faberge Secret Garden
Faberge Secret Garden
SURREALISM
LUBAINA HIMID
YAYOI KUSAMA
Yayoi Kusama
Anicka Yi
Drawing Media | Workshop
Talk | Faberge
Katsushika Hokusai
Swiss Prints
