All 'A-E' Artists, A-Z Artists
 |
|||||||
| Order By: | |||||||
|
|||||||
|
|||||||
|
|
|
Exhibition filter:
1317 - Query execution was interrupted
select s.subject_id, REPLACE(s.subject, ' ', ' ') as subject, count(distinct ps.subject_professional_id) as subject_live_tuition from common_subject s INNER JOIN professional_member_subject ps ON ps.subject_id = s.subject_id inner join customers c on c.customers_id = ps.subject_professional_id inner join professional_member_media tpm on tpm.media_professional_id = c.customers_id and tpm.media_id = 41 where c.customers_publish_professiona_page = 1 and c.customers_publish_exhibitions = 1 and tpm.media_professional_id = c.customers_id and tpm.media_id = 41 and c.customers_county = 56 group by ps.subject_id order by s.subject[query]
[TEP STOP]
select s.subject_id, REPLACE(s.subject, ' ', ' ') as subject, count(distinct ps.subject_professional_id) as subject_live_tuition from common_subject s INNER JOIN professional_member_subject ps ON ps.subject_id = s.subject_id inner join customers c on c.customers_id = ps.subject_professional_id inner join professional_member_media tpm on tpm.media_professional_id = c.customers_id and tpm.media_id = 41 where c.customers_publish_professiona_page = 1 and c.customers_publish_exhibitions = 1 and tpm.media_professional_id = c.customers_id and tpm.media_id = 41 and c.customers_county = 56 group by ps.subject_id order by s.subject[query]
[TEP STOP]