Aesthethic Meeting - ASAPS Online Catalog

user warning: Unknown column 'products' in 'where clause' query: SELECT COUNT(DISTINCT(n.nid)) FROM node n INNER JOIN term_node tn ON n.vid = tn.vid INNER JOIN uc_products AS p ON n.vid = p.vid INNER JOIN node_access na ON na.nid = n.nid INNER JOIN member_type_product m_tp ON (m_tp.nid=n.nid) INNER JOIN asaps_ubercart_products a_up ON (a_up.nid=n.nid) WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'asaps_forum_access_roles') OR (na.gid = 0 AND na.realm = 'asaps_forum_access_user'))) AND ((m_tp.member_type_id IN (5) AND m_tp.price>0) || (a_up.is_reference=1)) AND ( n.status = 1 AND n.type IN ('donation','product','product_nontaxable','product_kit') AND tn.tid IN (1000222, 1000476, 1000477, 1000480, 1000483, 1000148, 1000490, 1000497, 1000496, 1000495, products)) in /var/www/sites/surgery.org/sites/all/modules/asaps/asaps_ubercart/asaps_ubercart.module on line 2195.
user warning: Unknown column 'products' in 'where clause' query: SELECT DISTINCT(n.nid), n.sticky, n.title, n.created, p.model, p.sell_price, p.ordering FROM node n INNER JOIN term_node tn ON n.vid = tn.vid INNER JOIN uc_products AS p ON n.vid = p.vid INNER JOIN node_access na ON na.nid = n.nid INNER JOIN member_type_product m_tp ON (m_tp.nid=n.nid) INNER JOIN asaps_ubercart_products a_up ON (a_up.nid=n.nid) WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'asaps_forum_access_roles') OR (na.gid = 0 AND na.realm = 'asaps_forum_access_user'))) AND ((m_tp.member_type_id IN (5) AND m_tp.price>0) || (a_up.is_reference=1)) AND ( n.status = 1 AND n.type IN ('donation','product','product_nontaxable','product_kit') AND tn.tid IN (1000222, 1000476, 1000477, 1000480, 1000483, 1000148, 1000490, 1000497, 1000496, 1000495, products) )ORDER BY n.sticky DESC, n.promote DESC, p.ordering, n.title DESC, n.nid LIMIT 0, 10 in /var/www/sites/surgery.org/sites/all/modules/asaps/asaps_ubercart/asaps_ubercart.module on line 2195.

DAM08-709 DVD - An International Perspective of Soft Tissue Fillers

SKU: DAM08-709

$102.00

Price: $102.00

DVD - An International Perspective of Soft Tissue Fillers DAM08-709 Ute Bauer, MD, Catherine Bergeret-Galley, MD, Sydney R. Coleman, MD, Claudio L. DeLorenzi, MD, Malcolm D. Paul, MD, Massimo Signorini, MD 120 minutes