| | |
All  |
| in select tp.id as id,tp.short_name as name from publication_types tp,clients c,client_publicationgroups cp,publicationgroup_publications p where c.referrer_client_id=71 and c.id=cp.client_id and cp.id=p.publicationgroup_id and p.type_id=tp.id and p.in_kiosk_private=1 and custom_id =1 Group by tp.id order by name |