pqr select tasks action_id task_results created_at tasks rule_id task_

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
pqr=> select tasks.action_id, task_results.created_at, tasks.rule_id, task_results.data from task_results join tasks on task_results.task_id=tasks.id where task_results.campaign_id=128 and task_results.resource='770529' order by task_results.created_at;
-[ RECORD 1 ]-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
action_id | CUT_PLACEMENT
created_at | 2021-01-15 12:03:58.794509+00
rule_id | 219
data | [{"voluum__placement__1d_roi":-1,"voluum__placement__cost":4.4544,"voluum__placement__cps":0.4049454545454545,"voluum__placement__id":"770529","voluum__placement__lps_aff":-0.4049454545454545,"voluum__placement__pjlps":0.2231272727272727,"voluum__placement__revenue":0,"voluum__placement__roi":-100,"voluum__placement__visits":66}]+
|
-[ RECORD 2 ]-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
action_id | CUT_PLACEMENT
created_at | 2021-01-15 12:19:01.321521+00
rule_id | 219
data | [{"voluum__placement__1d_roi":-1,"voluum__placement__cost":4.4544,"voluum__placement__cps":0.4049454545454545,"voluum__placement__id":"770529","voluum__placement__lps_aff":-0.4049454545454545,"voluum__placement__pjlps":0.2231272727272727,"voluum__placement__revenue":0,"voluum__placement__roi":-100,"voluum__placement__visits":66}]