Here's some documentation:
Page:
Page ID
select core\_page.id as page\_id from core\_page
Date and Time [Created/Updated]
 {{variation}} choice of variations
 datetime\_format{ value } choice of formats
First Created
select datetime\_format{ core\_page.created\_at } as created\_at from core\_page
Last Updated
select datetime\_format{ core\_page.updated\_at } as updated\_at from core\_page
Title
select core\_page.title as title from core\_page
Short Name
select core\_page.name as name from core\_page
Admin Notes
select notes as notes from core\_page
Page Type
 string-choice\_format{ value } choice of formats
select string-choice\_format{ core\_page.type } as type from core\_page
Tags
 string-tags\_format{ value } choice of formats
select string-tags\_format{ ( select group\_concat( core\_tag.name order by core\_tag.name separator ', ' ) from core\_page\_tags join core\_tag on core\_page\_tags.tag\_id = core\_tag.id where core\_page\_tags.page\_id = core\_page.id ) } as tags from core\_page
Target Groups
 {{variation}} choice of variations
ID
select if( core\_page.type = 'Call', ( select group\_concat( page\_target.targetgroup\_id separator ', ' ) from core\_callpage\_target\_groups as page\_target where page\_target.callpage\_id = core\_page.id ), if( core\_page.type = 'Letter', ( select group\_concat( page\_target.targetgroup\_id separator ', ' ) from core\_letterpage\_target\_groups as page\_target where page\_target.letterpage\_id = core\_page.id ), if( core\_page.type = 'Petition', ( select group\_concat( page\_target.targetgroup\_id separator ', ' ) from core\_petitionpage\_target\_groups as page\_target where page\_target.petitionpage\_id = core\_page.id ), if( core\_page.type = 'Whipcount', ( select group\_concat( page\_target.targetgroup\_id separator ', ' ) from core\_whipcountpage\_target\_groups as page\_target where page\_target.whipcountpage\_id = core\_page.id ), null ) ) ) ) as target\_id from core\_page
Name
select if( core\_page.type = 'Call', ( select group\_concat( core\_targetgroup.name separator ', ' ) from core\_callpage\_target\_groups as page\_target join core\_targetgroup on page\_target.targetgroup\_id = core\_targetgroup.id where page\_target.callpage\_id = core\_page.id ), if( core\_page.type = 'Letter', ( select group\_concat( core\_targetgroup.name separator ', ' ) from core\_letterpage\_target\_groups as page\_target join core\_targetgroup on page\_target.targetgroup\_id = core\_targetgroup.id where page\_target.letterpage\_id = core\_page.id ), if( core\_page.type = 'Petition', ( select group\_concat( core\_targetgroup.name separator ', ' ) from core\_petitionpage\_target\_groups as page\_target join core\_targetgroup on page\_target.targetgroup\_id = core\_targetgroup.id where page\_target.petitionpage\_id = core\_page.id ), if( core\_page.type = 'Whipcount', ( select group\_concat( core\_targetgroup.name separator ', ' ) from core\_whipcountpage\_target\_groups as page\_target join core\_targetgroup on page\_target.targetgroup\_id = core\_targetgroup.id where page\_target.whipcountpage\_id = core\_page.id ), null ) ) ) ) as target\_name from core\_page
Name and ID
select if( core\_page.type = 'Call', ( select group\_concat( concat( core\_targetgroup.name, ' (', core\_targetgroup.id, ')' ) separator ', ' ) from core\_callpage\_target\_groups as page\_target join core\_targetgroup on page\_target.targetgroup\_id = core\_targetgroup.id where page\_target.callpage\_id = core\_page.id ), if( core\_page.type = 'Letter', ( select group\_concat( concat( core\_targetgroup.name, ' (', core\_targetgroup.id, ')' ) separator ', ' ) from core\_letterpage\_target\_groups as page\_target join core\_targetgroup on page\_target.targetgroup\_id = core\_targetgroup.id where page\_target.letterpage\_id = core\_page.id ), if( core\_page.type = 'Petition', ( select group\_concat( concat( core\_targetgroup.name, ' (', core\_targetgroup.id, ')' ) separator ', ' ) from core\_petitionpage\_target\_groups as page\_target join core\_targetgroup on page\_target.targetgroup\_id = core\_targetgroup.id where page\_target.petitionpage\_id = core\_page.id ), if( core\_page.type = 'Whipcount', ( select group\_concat( concat( core\_targetgroup.name, ' (', core\_targetgroup.id, ')' ) separator ', ' ) from core\_whipcountpage\_target\_groups as page\_target join core\_targetgroup on page\_target.targetgroup\_id = core\_targetgroup.id where page\_target.whipcountpage\_id = core\_page.id ), null ) ) ) ) as target\_name\_id from core\_page

Here's a sql script:
select core\_user.email as "user\_email"
from core\_user
group by core\_user.id
Edit the SQL script to return all email addresses that have taken action of a page where the page short name contains "sticker"
다음은 몇 가지 문서입니다:
페이지:
페이지 ID
코어\_페이지에서 페이지\_ID로 코어\_페이지.ID 선택
날짜 및 시간 [생성/업데이트]
 {변형}} 변형 선택
 날짜/시간\_형식{ 값} 형식 선택
최초 생성
core\_page에서 created\_at로 datetime\_format{ core\_page.created\_at } 선택
마지막 업데이트
SELECT DATETIME\_FORMAT{ core\_page.updated\_at } AS UPDATE\_AT FROM core\_PAGE
제목
core\_page에서 core\_page.title을 제목으로 선택합니다.
짧은 이름
core\_page에서 core\_page.name을 이름으로 선택합니다.
관리자 노트
코어\_페이지에서 메모를 메모로 선택
페이지 유형
 string-choice\_format{ 값 } 형식 선택
core\_page에서 string-choice\_format{ core\_page.type }을 유형으로 선택
태그
 string-tags\_format{ 값 } 형식 선택
select string-tags\_format{ ( select group\_concat( core\_tag.name order by core\_tag.name separator ', ' ) from core\_page\_tags core\_tag join core\_tag on core\_page\_tags.tag\_id = core\_tag.id where core\_page\_tags.page\_id = core\_page.id ) }를 코어\_페이지의 태그로
대상 그룹
 {{변형}} 변형 선택
ID
select if( core\_page.type = '전화', ( select group\_concat( page\_target.targetgroup\_id 구분자 ', ' ) from core\_callpage\_target\_groups as page\_target where page\_target.callpage\_id = core\_page.id ), if( core\_page. type = 'Letter', ( select group\_concat( page\_target.targetgroup\_id separator ', ' ) from core\_letterpage\_target\_groups as page\_target where page\_target.letterpage\_id = core\_page.id ), if( core\_page. type = '청원', ( select group\_concat( page\_target.targetgroup\_id 구분자 ', ' ) from core\_petitionpage\_target\_groups as page\_target where page\_target.petitionpage\_id = core\_page.id ), if( core\_page. type = 'Whipcount', ( select group\_concat( page\_target.targetgroup\_id 구분자 ', ' ) from core\_whipcountpage\_target\_groups as page\_target where page\_target.whipcountpage\_id = core\_page.id ), null ) ) ) ) 코어\_페이지에서 타겟\_아이디로 ) )
Name
select if( core\_page.type = 'Call', ( select group\_concat( core\_targetgroup.name separator ', ' ) from core\_callpage\_target\_groups as page\_target join core\_targetgroup on page\_target.targetgroup\_id = core\_target.targetgroup.id where page\_target.callpage\_id = core\_page.id ), if( core\_page. type = 'Letter', ( select group\_concat( core\_targetgroup.name separator ', ' ) from core\_letterpage\_target\_groups as page\_target join core\_targetgroup on page\_target.targetgroup\_id = core\_target.targetgroup.id where page\_target.letterpage\_id = core\_page.id ), if( core\_page. type = '청원', ( select group\_concat( core\_targetgroup.name separator ', ' ) from core\_petitionpage\_target\_groups as page\_target join core\_targetgroup on page\_target.targetgroup\_id = core\_target.targetgroup.id where page\_target.petitionpage\_id = core\_page.id ), if( core\_page. type = 'Whipcount', ( select group\_concat( core\_targetgroup.name separator ', ' ) from core\_whipcountpage\_target\_groups as page\_target join core\_targetgroup on page\_target.targetgroup\_id = core\_target.targetgroup.id where page\_target.whipcountpage\_id = core\_page.id ), null ) ) ) ) 코어\_페이지에서 타겟\_이름으로) )
이름 및 ID
select if( core\_page.type = 'Call', ( select group\_concat( concat( core\_targetgroup.name, '(', core\_targetgroup. id, ')' ) 구분 기호 ', ' ) from core\_callpage\_target\_groups as page\_target join core\_targetgroup on page\_target.targetgroup\_id = core\_targetgroup.id where page\_target.callpage\_id = core\_page.id ), if( core\_page. type = 'Letter', ( select group\_concat( concat( core\_targetgroup.name, '(', core\_targetgroup.id, ')' ) separator ', ' ) from core\_letterpage\_target\_groups as page\_target join core\_targetgroup on page\_target.targetgroup\_id = core\_target.targetgroup.id where page\_target.letterpage\_id = core\_page.id ), if( core\_page. type = '청원', ( select group\_concat( concat( core\_targetgroup.name, '(', core\_targetgroup.id, ')' ) separator ', ' ) from core\_petitionpage\_target\_groups as page\_target join core\_targetgroup on page\_target. targetgroup\_id = core\_targetgroup.id where page\_target.petitionpage\_id = core\_page.id ), if( core\_page. type = 'Whipcount', ( select group\_concat( concat( core\_targetgroup.name, '(', core\_targetgroup.id, ')' ) separator ', ' ) from core\_whipcountpage\_target\_groups as page\_target join core\_targetgroup on page\_target. targetgroup\_id = core\_targetgroup.id where page\_target.whipcountpage\_id = core\_page.id ), null ) ) ) ) 코어\_페이지에서 대상\_이름\_아이디로) )

다음은 SQL 스크립트입니다:
core\_user.email을 "user\_email"로 선택
FROM core\_user
core\_user.id로 그룹화
페이지 짧은 이름에 "스티커"가 포함된 페이지의 작업을 수행한 모든 이메일 주소를 반환하도록 SQL 스크립트를 편집합니다.