SELECT COUNT(field_prdt_artistid_value) as Artist_ID_Count^M
      FROM ^M
      field_data_field_prdt_artistid as arid^M
      INNER JOIN field_data_field_prdt_productid fprodid ON fprodid.entity_id = arid.entity_id^M
      INNER JOIN field_data_field_prdt_country fdfpc ON fdfpc.entity_id = arid.entity_id^M
      inner join node as nd on nd.title=fprodid.field_prdt_productid_value^M
      WHERE arid.field_prdt_artistid_value = '7db56d81-fe98-48a2-9ddb-c68866001584' AND fdfpc.field_prdt_country_value = 'america'\G