That didn't work. Here's more documentation:
Actions
Displays Sample SQL
Totals:
Number Of Actions [All, From Mailings, From Shares] aggregate
 {{variation}} choice of variations
 int\_format{ value } choice of formats
Actions
select int\_format{ count(distinct core\_action.id) } as actions from core\_action
Actions From Mailings
select int\_format{ count(distinct if(core\_action.mailing\_id, core\_action.id, null)) } as mail\_actions from core\_action
Actions From Shares
select int\_format{ count(distinct if(share\_action.id, core\_action.id, null)) } as share\_actions from core\_action left join share\_action on share\_action.action\_id = core\_action.id
Number Of Unique Users aggregate
 int\_format{ value } choice of formats
select int\_format{ count(distinct core\_action.user\_id) } as distinct\_users from core\_action
Number Of Users [Created/Subscribed/Unsubscribed] aggregate
 {{variation}} choice of variations
 int\_format{ value } choice of formats
Created
select int\_format{ sum(core\_action.created\_user) } as {{variation}}\_users from core\_action
Subscribed
select int\_format{ sum( core\_action.subscribed\_user ) } as {{variation}}\_users from core\_action
Unsubscribed
select int\_format{ sum( ( select count(\*) from core\_unsubscribeaction where core\_unsubscribeaction.action\_ptr\_id = core\_action.id ) ) } as {{variation}}\_users from core\_action
Number Of TAF Emails Sent aggregate
 int\_format{ value } choice of formats
select int\_format{ sum( core\_action.taf\_emails\_sent ) } as taf\_emails\_sent from core\_action
Number Of Shares Created aggregate
 int\_format{ value } choice of formats
select int\_format{ sum( ( select count(\*) from share\_link where share\_link.action\_id = core\_action.id ) ) } as shares\_created from core\_action
Action:
Action ID
select core\_action.id as action\_id from core\_action
Date and Time [Created/Updated]
 {{variation}} choice of variations
 datetime\_format{ value } choice of formats
First Created
select datetime\_format{ core\_action.created\_at } as created\_at from core\_action
Last Updated
select datetime\_format{ core\_action.updated\_at } as updated\_at from core\_action
IP Address
select core\_action.ip\_address as ip\_address from core\_action
Source
select core\_action.source as source from core\_action
From Mailing
 mailing\_id\_format{ value } choice of formats
select mailing\_id\_format{ core\_action.mailing\_id } as mailing from core\_action
From Share
 share\_id\_format{ value } choice of formats
select share\_id\_format{ share\_action.id } as share from core\_action left join share\_action on share\_action.action\_id = core\_action.id
All Custom Action Fields
select ( select group\_concat( concat( core\_actionfield.name, ': ', core\_actionfield.value ) separator ', ' ) from core\_actionfield where core\_actionfield.parent\_id = core\_action.id ) as custom\_fields from core\_action
Custom Action Field [Field Name]
 {{fieldname}}: string
select ( select group\_concat( core\_actionfield.value separator ', ' ) from core\_actionfield where core\_actionfield.parent\_id = core\_action.id and core\_actionfield.name = {{fieldname}} ) as custom\_field\_{{fieldname}} from core\_action
Status
select core\_action.status as status from core\_action
Is Completed?
 boolean\_format{ value } choice of formats
select boolean\_format{ core\_action.status = 'complete' } as action\_completed from core\_action
Is Spam?
 boolean\_format{ value } choice of formats
select boolean\_format{ core\_action.status = 'spam' } as action\_spam from core\_action
Did Action Create User?
 boolean\_format{ value } choice of formats
select boolean\_format{ core\_action.created\_user } as created\_user from core\_action
Did Action Subscribe User?
 boolean\_format{ value } choice of formats
select boolean\_format{ core\_action.subscribed\_user } as subscribed\_user from core\_action
Did User Send TAF Emails?
 boolean\_format{ value } choice of formats
select boolean\_format{ if( core\_action.taf\_emails\_sent > 0, 1, 0 ) } as taf\_email\_sent from core\_action
Page:
Page
 page\_id\_format{ value } choice of formats
select page\_id\_format{ core\_action.page\_id } as page\_id from core\_action
Page Type
select ( select core\_page.type from core\_page where core\_action.page\_id = core\_page.id ) as page\_type from core\_action
Page Tags
 string-tags\_format{ value } choice of formats
select string-tags\_format{ ( select group\_concat( core\_tag.name separator ', ' ) from core\_page join core\_page\_tags on ( core\_page.id = core\_page\_tags.page\_id ) join core\_tag on ( core\_tag.id = core\_page\_tags.tag\_id ) where core\_action.page\_id = core\_page.id ) } as page\_tags from core\_action
Member Action?
 boolean\_format{ value } choice of formats
select boolean\_format{ core\_page.real\_actions } as member\_action from core\_action left join core\_page on core\_page.id = core\_action.page\_id
List
 list\_id\_format{ value } choice of formats
select list\_id\_format{ core\_page.list\_id } as list from core\_action left join core\_page on core\_page.id = core\_action.page\_id
Language
 {{variation}} choice of variations
 foreign-key\_format{ value } choice of formats
Name and ID
select foreign-key\_format{ concat( core\_language.name, ' (', core\_page.lang\_id , ')' ) } as language\_name\_id from core\_action left join core\_page on core\_page.id = core\_action.page\_id left join core\_language on core\_language.id = core\_page.lang\_id
Name
select foreign-key\_format{ core\_language.name } as language\_name from core\_action left join core\_page on core\_page.id = core\_action.page\_id left join core\_language on core\_language.id = core\_page.lang\_id
ID
select foreign-key\_format{ core\_page.lang\_id } as lang\_id from core\_action left join core\_page on core\_page.id = core\_action.page\_id
Multilingual Campaign
 {{variation}} choice of variations
 foreign-key\_format{ value } choice of formats
Name and ID
select foreign-key\_format{ concat( core\_multilingualcampaign.name, ' (', core\_page.multilingual\_campaign\_id , ')' ) } as multilingual\_name\_id from core\_action left join core\_page on core\_page.id = core\_action.page\_id left join core\_multilingualcampaign on core\_multilingualcampaign.id = core\_page.multilingual\_campaign\_id
Name
select foreign-key\_format{ core\_multilingualcampaign.name } as multilingual\_name from core\_action left join core\_page on core\_page.id = core\_action.page\_id left join core\_multilingualcampaign on core\_multilingualcampaign.id = core\_page.multilingual\_campaign\_id
ID
select foreign-key\_format{ core\_page.multilingual\_campaign\_id } as multilingual\_id from core\_action left join core\_page on core\_page.id = core\_action.page\_id

And here's the error message:
A report SQL error occurred. The error occurred in this SQL statement:

/\* QueryReport unsaved\_query (ID None) (Job ID 3116587) \*/ SELECT DISTINCT core\_user.email AS "user\_email" FROM core\_user JOIN action ON core\_user.id = action.user\_id JOIN core\_page ON action.page\_id = core\_page.id WHERE core\_page.name LIKE '%sticker%'

The error reported by MySQL is:

(1146, "Table 'ak\_350.action' doesn't exist")
모자가 작동하지 않습니다. 자세한 문서를 참조하세요:Actions샘플 SQL 표시Totals:작업 수 [전체, 메일링에서, 공유에서] 집계 {variation}} 변형 선택 int\_format{ 값 } 형식 선택Actionsselect int\_format{ count(distinct core\_action.id) } as actions from core\_action메일링의 액션select int\_format{ count(distinct if(core\_action.mailing\_id, core\_action.id, null)) } as mail\_actions from core\_action공유의 액션select int\_format{ count(distinct if(share\_action.id, core\_action.id, null)) } as share\_actions from core\_action left join share\_action on share\_action.action\_id = core\_action.id고유 사용자 수 집계 int\_format{ 값 } 형식 선택select int\_format{ count(distinct core\_action.user\_id) } as distinct\_users from core\_action사용자 수 [생성/구독/구독 취소] 집계 {{변형}} 변형 선택 int\_format{ 값 } 형식 선택Createdselect int\_format{ sum(core\_action.created\_user) } as {{variation}}\_users from core\_action구독됨select int\_format{ sum( core\_action.subscribed\_user ) } as {{variation}}\_users from core\_action구독 취소select int\_format{ sum( ( select count(\*) from core\_unsubscribeaction where core\_unsubscribeaction.action\_ptr\_id = core\_action.id ) ) } as {{변형}}\_users from core\_action전송된 TAF 이메일 수 집계 int\_format{ 값 } 형식 선택select int\_format{ sum( core\_action.taf\_emails\_sent ) } as taf\_emails\_sent from core\_action생성된 공유 수 집계 int\_format{ 값 } 형식 선택select int\_format{ sum( ( share\_link에서 count(\*) select share\_link.action\_id = core\_action.id ) ) ) } as shares\_created from core\_action액션:작업 ID코어\_액션에서 액션\_아이디로 코어\_액션.아이디를 선택합니다.날짜 및 시간 [생성/업데이트] {변형}} 변형 선택 날짜/시간\_형식{ 값} 형식 선택최초 생성core\_action에서 created\_at로 datetime\_format{ core\_action.created\_at } 선택마지막 업데이트SELECT DATETIME\_FORMAT{ core\_action.updated\_at } AS UPDATE\_AT FROM core\_actionIP 주소core\_action에서 core\_action.ip\_address를 ip\_address로 선택소스core\_action에서 core\_action.source를 소스로 선택합니다.메일링에서 메일링\_ID\_FORMAT{ 값 } 형식 선택메일링\_id\_형식{ core\_action.mailing\_id }를 core\_action에서 메일링으로 선택공유에서 share\_id\_format{ 값 } 형식 선택share\_id\_format{ share\_action.id }를 core\_action에서 공유로 선택 공유\_action에서 공유\_액션에 왼쪽 조인 공유\_액션에 공유\_액션\_id = 핵심\_액션.id로 선택모든 사용자 지정 작업 필드SELECT ( SELECT 그룹\_컨캣( CONCAT( 코어\_액션필드.이름, ': ', 코어\_액션필드.값 ) 구분 기호 ', ' ) FROM 코어\_액션필드 where 코어\_액션필드.부모\_id = 코어\_액션.id ) AS 사용자 지정\_필드 코어\_액션에서사용자 지정 액션 필드 [필드 이름] {{필드 이름}}: 문자열select ( select group\_concat( core\_actionfield.value 구분 기호 ', ' )에서 core\_actionfield.parent\_id = core\_action.id 및 core\_actionfield.name = {{fieldname}}. )를 core\_action에서 custom\_field\_{{fieldname}}으로 가져옵니다.상태core\_action에서 status로 core\_action.status를 선택합니다.완료되었나요? 부울\_형식{ 값 } 형식 선택boolean\_format{ core\_action.status = '완료' }를 core\_action에서 action\_completed로 선택스팸인가요? boolean\_format{ 값 } 형식 선택core\_action에서 action\_spam으로 boolean\_format{ core\_action.status = '스팸' } 선택액션이 사용자를 생성했나요? boolean\_format{ 값 } 형식 선택select boolean\_format{ core\_action.created\_user } as created\_user from core\_action액션이 사용자를 구독했나요? boolean\_format{ 값 } 형식 선택select boolean\_format{ core\_action.subscribed\_user } as subscribed\_user from core\_action사용자가 TAF 이메일을 보냈나요? boolean\_format{ value } 형식 선택select boolean\_format{ if( core\_action.taf\_emails\_sent > 0, 1, 0 ) } as taf\_email\_sent from core\_actionPage:페이지 페이지\_ID\_형식{ 값 } 형식 선택core\_action에서 page\_id\_format{ core\_action.page\_id }를 page\_id로 선택합니다.페이지 유형코어\_액션에서 페이지\_유형 선택 ( 코어\_액션.페이지\_id = 코어\_페이지.아이디 ) 코어\_액션에서 페이지\_유형으로 코어\_페이지.유형 선택페이지 태그 string-tags\_format{ 값 } 형식 선택select string-tags\_format{ ( select group\_concat( core\_tag.name separator ', ' ) from core\_page join core\_page\_tags on ( core\_page.id = core\_page\_tags.page\_id ) join core\_tag on ( core\_tag.id = core\_page\_tags.tag\_id ) where core\_action.page\_id = core\_page.id ) } as page\_tags from core\_action회원 액션? boolean\_format{ 값 } 형식 선택선택 부울\_형식{ core\_page.real\_actions } as member\_action from core\_action 왼쪽 조인 코어\_페이지에 코어\_페이지.id = 코어\_액션.페이지\_id목록 list\_id\_format{ value } 형식 선택선택 목록\_id\_형식{ core\_page.l