|
94112
|
2026-04-24T10:24:23.369481+00:00
|
9676eafd-ea8f-4e1a-a5f1-de7bdb79c071
|
108
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
90013
|
NULL
|
NULL
|
AXTextArea
|
Editor for laravel.log
|
[2026-04-24 10:24:09] local.INFO: [automated-repo
[2026-04-24 10:24:09] local.INFO: [automated-reports] Started {"correlation_id":"4ef6e232-88d2-4935-87d3-62ff95c3b2d5","trace_id":"6af075f9-940e-4789-b9b4-cb42649b2cf5"}
[2026-04-24 10:24:09] local.INFO: [automated-reports] Checking conditions {"isMonday":false,"isWeekend":false,"isFirstDayOfMonth":false,"currentMonth":4,"isQuarterlyMonth":true} {"correlation_id":"4ef6e232-88d2-4935-87d3-62ff95c3b2d5","trace_id":"6af075f9-940e-4789-b9b4-cb42649b2cf5"}
[2026-04-24 10:24:09] local.INFO: [automated-reports] Processing daily reports {"correlation_id":"4ef6e232-88d2-4935-87d3-62ff95c3b2d5","trace_id":"6af075f9-940e-4789-b9b4-cb42649b2cf5"}
[2026-04-24 10:24:10] local.INFO: [automated-reports] Found 1 daily reports to process {"correlation_id":"4ef6e232-88d2-4935-87d3-62ff95c3b2d5","trace_id":"6af075f9-940e-4789-b9b4-cb42649b2cf5"}
[2026-04-24 10:24:10] local.INFO: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"4f6ca2b5-1993-48aa-99ad-b66f19f15d43","team......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
94129
|
2026-04-24T10:25:28.094871+00:00
|
9676eafd-ea8f-4e1a-a5f1-de7bdb79c071
|
64834
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
90013
|
NULL
|
NULL
|
AXTextArea
|
Editor for laravel.log
|
[2026-04-24 10:24:09] local.INFO: [automated-repo
[2026-04-24 10:24:09] local.INFO: [automated-reports] Started {"correlation_id":"4ef6e232-88d2-4935-87d3-62ff95c3b2d5","trace_id":"6af075f9-940e-4789-b9b4-cb42649b2cf5"}
[2026-04-24 10:24:09] local.INFO: [automated-reports] Checking conditions {"isMonday":false,"isWeekend":false,"isFirstDayOfMonth":false,"currentMonth":4,"isQuarterlyMonth":true} {"correlation_id":"4ef6e232-88d2-4935-87d3-62ff95c3b2d5","trace_id":"6af075f9-940e-4789-b9b4-cb42649b2cf5"}
[2026-04-24 10:24:09] local.INFO: [automated-reports] Processing daily reports {"correlation_id":"4ef6e232-88d2-4935-87d3-62ff95c3b2d5","trace_id":"6af075f9-940e-4789-b9b4-cb42649b2cf5"}
[2026-04-24 10:24:10] local.INFO: [automated-reports] Found 1 daily reports to process {"correlation_id":"4ef6e232-88d2-4935-87d3-62ff95c3b2d5","trace_id":"6af075f9-940e-4789-b9b4-cb42649b2cf5"}
[2026-04-24 10:24:10] local.INFO: [automated-reports] Dispatching Generate Report job for report {"reportUuid":"4f6ca2b5-1993-48aa-99ad-b66f19f15d43","team......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
52829
|
2026-04-17T06:17:24.691425+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
1283935
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
47782
|
NULL
|
NULL
|
AXTextArea
|
Editor for custom.log
|
{
"request_id":"822fa41b-afd3-43a9-a24 {
"request_id":"822fa41b-afd3-43a9-a248-86b0e36f3131",
"status":"completed",
"timestamp":"2026-04-13T01:11:48.648399+00:00",
"s3_url":"s3:\/\/jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/reports\/822fa41b-afd3-43a9-a248-86b0e36f3131.MD",
"report_type":"coaching_profiles",
"podcast_url":"s3:\/\/jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/reports\/822fa41b-afd3-43a9-a248-86b0e36f3131_podcast.txt",
"podcast_audio_url":"s3:\/\/jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/reports\/822fa41b-afd3-43a9-a248-86b0e36f3131_podcast.mp3",
"podcast_ssml_url":"s3:\/\/jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/reports\/822fa41b-afd3-43a9-a248-86b0e36f3131_podcast.ssml"}...
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
52834
|
2026-04-17T06:17:32.868253+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
1292112
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
47782
|
NULL
|
NULL
|
AXTextArea
|
Editor for custom.log
|
{
"request_id":"822fa41b-afd3-43a9-a24 {
"request_id":"822fa41b-afd3-43a9-a248-86b0e36f3131",
"status":"completed",
"timestamp":"2026-04-13T01:11:48.648399+00:00",
"s3_url":"s3:\/\/jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/reports\/822fa41b-afd3-43a9-a248-86b0e36f3131.MD",
"report_type":"coaching_profiles",
"podcast_url":"s3:\/\/jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/reports\/822fa41b-afd3-43a9-a248-86b0e36f3131_podcast.txt",
"podcast_audio_url":"s3:\/\/jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/reports\/822fa41b-afd3-43a9-a248-86b0e36f3131_podcast.mp3",
"podcast_ssml_url":"s3:\/\/jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/reports\/822fa41b-afd3-43a9-a248-86b0e36f3131_podcast.ssml"}...
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
52859
|
2026-04-17T06:18:00.855127+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
1320099
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
47782
|
NULL
|
NULL
|
AXTextArea
|
Editor for custom.log
|
{
"request_id":"822fa41b-afd3-43a9-a24 {
"request_id":"822fa41b-afd3-43a9-a248-86b0e36f3131",
"status":"completed",
"timestamp":"2026-04-13T01:11:48.648399+00:00",
"s3_url":"s3:\/\/jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/reports\/822fa41b-afd3-43a9-a248-86b0e36f3131.MD",
"report_type":"coaching_profiles",
"podcast_url":"s3:\/\/jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/reports\/822fa41b-afd3-43a9-a248-86b0e36f3131_podcast.txt",
"podcast_audio_url":"s3:\/\/jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/reports\/822fa41b-afd3-43a9-a248-86b0e36f3131_podcast.mp3",
"podcast_ssml_url":"s3:\/\/jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/reports\/822fa41b-afd3-43a9-a248-86b0e36f3131_podcast.ssml"}...
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
52879
|
2026-04-17T06:18:48.225292+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
1367469
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
47782
|
NULL
|
NULL
|
AXTextArea
|
Editor for custom.log
|
{
"request_id":"822fa41b-afd3-43a9-a24 {
"request_id":"822fa41b-afd3-43a9-a248-86b0e36f3131",
"status":"completed",
"timestamp":"2026-04-13T01:11:48.648399+00:00",
"s3_url":"s3:\/\/jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/reports\/822fa41b-afd3-43a9-a248-86b0e36f3131.MD",
"report_type":"coaching_profiles",
"podcast_url":"s3:\/\/jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/reports\/822fa41b-afd3-43a9-a248-86b0e36f3131_podcast.txt",
"podcast_audio_url":"s3:\/\/jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/reports\/822fa41b-afd3-43a9-a248-86b0e36f3131_podcast.mp3",
"podcast_ssml_url":"s3:\/\/jiminny.client-data\/5f0f4810-7e77-4086-8f69-93429ae4d70b\/reports\/822fa41b-afd3-43a9-a248-86b0e36f3131_podcast.ssml"}...
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84465
|
2026-04-22T11:23:35.267125+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
18493651
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for custom.log
|
[2026-04-22 11:23:14] local.INFO: $payload
Array
[2026-04-22 11:23:14] local.INFO: $payload
Array
(
[user_question] => Are these activities and give me the most insightful information about them
[call_ids] => Array
(
[0] => 1
[1] => 2
[2] => 3
)
[team_id] => 1
[request_id] => d3037407-091e-438a-8c8e-6745c5bf8df9
[callback_url] => https://qatest:[EMAIL]/webhook/reports/ready
[report_period] => 21 Apr 2026
[report_name] => Search One
)
{"correlation_id":"c786229a-00f6-4af1-b4ec-7553791bafe4","trace_id":"d4cfff0e-85bf-4b35-a8c0-d0752235ffc4"}
...
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84720
|
2026-04-22T11:45:19.511837+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
19797816
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for custom.log
|
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84736
|
2026-04-22T11:46:52.938320+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
19891240
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for custom.log
|
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84775
|
2026-04-22T11:47:52.786152+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
19951086
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for custom.log
|
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84878
|
2026-04-22T11:50:46.280188+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
20124575
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for custom.log
|
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
84889
|
2026-04-22T11:54:10.983590+00:00
|
e7729066-2ab4-4bf0-9d48-0c9790a4ee79
|
20329248
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
44389
|
NULL
|
NULL
|
AXTextArea
|
Editor for custom.log
|
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
91377
|
2026-04-24T06:33:56.376331+00:00
|
d723d582-4d6f-4e04-921c-c054be5f7efc
|
871744
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
90013
|
NULL
|
NULL
|
AXTextArea
|
Editor for custom.log
|
There were 8 failures:
1) Tests\Unit\Services\Kio There were 8 failures:
1) Tests\Unit\Services\Kiosk\AutomatedReports\AutomatedReportsServiceActivitiesCountTest::testGetActivitiesCountPayloadWithWeeklyFrequency
Failed asserting that two strings are equal.
--- Expected
+++ Actual
@@ @@
-'2025-08-05T00:00:00+00:00'
+'2025-08-03T00:00:00+00:00'
/home/circleci/project/tests/Unit/Services/Kiosk/AutomatedReports/AutomatedReportsServiceActivitiesCountTest.php:194
2) Tests\Unit\Services\Kiosk\AutomatedReports\AutomatedReportsServiceActivitiesCountTest::testGetActivitiesCountPayloadWithMonthlyFrequency
Failed asserting that '2025-07-31T23:59:59+00:00' starts with "2025-08-11".
/home/circleci/project/tests/Unit/Services/Kiosk/AutomatedReports/AutomatedReportsServiceActivitiesCountTest.php:226
3) Tests\Unit\Services\Kiosk\AutomatedReports\AutomatedReportsServiceReportGenerationTest::testCalculateFromAndToDateWithWeeklyFrequency
Failed asserting that two strings are equal.
--- Expected
+++ Actual
@@ @@
-'2023-02-08 00:00:00'
+'2023-02-05......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
91386
|
2026-04-24T06:34:53.901681+00:00
|
d723d582-4d6f-4e04-921c-c054be5f7efc
|
929271
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
90013
|
NULL
|
NULL
|
AXTextArea
|
Editor for custom.log
|
There were 8 failures:
1) Tests\Unit\Services\Kio There were 8 failures:
1) Tests\Unit\Services\Kiosk\AutomatedReports\AutomatedReportsServiceActivitiesCountTest::testGetActivitiesCountPayloadWithWeeklyFrequency
Failed asserting that two strings are equal.
--- Expected
+++ Actual
@@ @@
-'2025-08-05T00:00:00+00:00'
+'2025-08-03T00:00:00+00:00'
/home/circleci/project/tests/Unit/Services/Kiosk/AutomatedReports/AutomatedReportsServiceActivitiesCountTest.php:194
2) Tests\Unit\Services\Kiosk\AutomatedReports\AutomatedReportsServiceActivitiesCountTest::testGetActivitiesCountPayloadWithMonthlyFrequency
Failed asserting that '2025-07-31T23:59:59+00:00' starts with "2025-08-11".
/home/circleci/project/tests/Unit/Services/Kiosk/AutomatedReports/AutomatedReportsServiceActivitiesCountTest.php:226
3) Tests\Unit\Services\Kiosk\AutomatedReports\AutomatedReportsServiceReportGenerationTest::testCalculateFromAndToDateWithWeeklyFrequency
Failed asserting that two strings are equal.
--- Expected
+++ Actual
@@ @@
-'2023-02-08 00:00:00'
+'2023-02-05......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
91482
|
2026-04-24T06:41:42.058316+00:00
|
d723d582-4d6f-4e04-921c-c054be5f7efc
|
1337390
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
90013
|
NULL
|
NULL
|
AXTextArea
|
Editor for custom.log
|
There were 8 failures:
1) Tests\Unit\Services\Kio There were 8 failures:
1) Tests\Unit\Services\Kiosk\AutomatedReports\AutomatedReportsServiceActivitiesCountTest::testGetActivitiesCountPayloadWithWeeklyFrequency
Failed asserting that two strings are equal.
--- Expected
+++ Actual
@@ @@
-'2025-08-05T00:00:00+00:00'
+'2025-08-03T00:00:00+00:00'
/home/circleci/project/tests/Unit/Services/Kiosk/AutomatedReports/AutomatedReportsServiceActivitiesCountTest.php:194
2) Tests\Unit\Services\Kiosk\AutomatedReports\AutomatedReportsServiceActivitiesCountTest::testGetActivitiesCountPayloadWithMonthlyFrequency
Failed asserting that '2025-07-31T23:59:59+00:00' starts with "2025-08-11".
/home/circleci/project/tests/Unit/Services/Kiosk/AutomatedReports/AutomatedReportsServiceActivitiesCountTest.php:226
3) Tests\Unit\Services\Kiosk\AutomatedReports\AutomatedReportsServiceReportGenerationTest::testCalculateFromAndToDateWithWeeklyFrequency
Failed asserting that two strings are equal.
--- Expected
+++ Actual
@@ @@
-'2023-02-08 00:00:00'
+'2023-02-05......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
93691
|
2026-04-24T09:01:27.543451+00:00
|
d723d582-4d6f-4e04-921c-c054be5f7efc
|
9722444
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
90013
|
NULL
|
NULL
|
AXTextArea
|
Editor for custom.log
|
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
40974
|
2026-04-16T06:54:10.616627+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
2173626
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
29810
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE name LIKE '%litify%& SELECT * FROM teams WHERE name LIKE '%litify%'; # 1069, 994, 24993
SELECT * FROM users WHERE id = 25061;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 994;
SELECT * FROM crm_profiles WHERE user_id = 25061;
select * from crm_configurations where id = 834;
SELECT * FROM teams WHERE id = 882;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 882 and sa.provider = 'hubspot';
SELECT * FROM crm_configurations where id = 882; # 933 - GoGlobal
SELECT * FROM opportunities WHERE team_id = 933 order by updated_at desc;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 933 and sa.provider = 'hubspot';
......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
41016
|
2026-04-16T06:55:15.527437+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
2238538
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
29810
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM team_features where team_id = 1;
SE SELECT * FROM team_features where team_id = 1;
SELECT * FROM teams WHERE name LIKE '%Vixio%'; # 340,270,11922
SELECT * FROM users WHERE team_id = 340; # 12015
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 340
and sa.provider = 'salesforce';
# and sa.provider = 'salesloft';
select * from crm_fields where crm_configuration_id = 270 and object_type = 'event';
# 125558 - Event Type - Event_Type__c
# 125552 - Event Status - Event_Status__c
SELECT * FROM sidekick_settings WHERE team_id = 340;
SELECT * FROM crm_field_values WHERE crm_field_id in (125552);
select * from activities where crm_configuration_id = 270
and type = 'conference' and crm_provider_id IS NOT NULL
and actual_start_time > '2024-09-16 09:00:00' order by scheduled_start_time;
SELECT * FROM activities WHERE id = 20871677;
SELECT * FROM crm_field_data WHERE activity_id = 20871677;
select * from crm_layouts where crm_configuration_id = 270;
select * from crm_layout_entities w......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
41186
|
2026-04-16T07:03:51.834538+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
2754856
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
29810
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM team_features where team_id = 1;
SE SELECT * FROM team_features where team_id = 1;
SELECT * FROM teams WHERE name LIKE '%Vixio%'; # 340,270,11922
SELECT * FROM users WHERE team_id = 340; # 12015
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 340
and sa.provider = 'salesforce';
# and sa.provider = 'salesloft';
select * from crm_fields where crm_configuration_id = 270 and object_type = 'event';
# 125558 - Event Type - Event_Type__c
# 125552 - Event Status - Event_Status__c
SELECT * FROM sidekick_settings WHERE team_id = 340;
SELECT * FROM crm_field_values WHERE crm_field_id in (125552);
select * from activities where crm_configuration_id = 270
and type = 'conference' and crm_provider_id IS NOT NULL
and actual_start_time > '2024-09-16 09:00:00' order by scheduled_start_time;
SELECT * FROM activities WHERE id = 20871677;
SELECT * FROM crm_field_data WHERE activity_id = 20871677;
select * from crm_layouts where crm_configuration_id = 270;
select * from crm_layout_entities w......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
41195
|
2026-04-16T07:04:20.856779+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
2783879
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
29810
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM team_features where team_id = 1;
SE SELECT * FROM team_features where team_id = 1;
SELECT * FROM teams WHERE name LIKE '%Vixio%'; # 340,270,11922
SELECT * FROM users WHERE team_id = 340; # 12015
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 340
and sa.provider = 'salesforce';
# and sa.provider = 'salesloft';
select * from crm_fields where crm_configuration_id = 270 and object_type = 'event';
# 125558 - Event Type - Event_Type__c
# 125552 - Event Status - Event_Status__c
SELECT * FROM sidekick_settings WHERE team_id = 340;
SELECT * FROM crm_field_values WHERE crm_field_id in (125552);
select * from activities where crm_configuration_id = 270
and type = 'conference' and crm_provider_id IS NOT NULL
and actual_start_time > '2024-09-16 09:00:00' order by scheduled_start_time;
SELECT * FROM activities WHERE id = 20871677;
SELECT * FROM crm_field_data WHERE activity_id = 20871677;
select * from crm_layouts where crm_configuration_id = 270;
select * from crm_layout_entities w......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
41214
|
2026-04-16T07:05:27.281317+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
2850305
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
29810
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM team_features where team_id = 1;
SE SELECT * FROM team_features where team_id = 1;
SELECT * FROM teams WHERE name LIKE '%Vixio%'; # 340,270,11922
SELECT * FROM users WHERE team_id = 340; # 12015
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 340
and sa.provider = 'salesforce';
# and sa.provider = 'salesloft';
select * from crm_fields where crm_configuration_id = 270 and object_type = 'event';
# 125558 - Event Type - Event_Type__c
# 125552 - Event Status - Event_Status__c
SELECT * FROM sidekick_settings WHERE team_id = 340;
SELECT * FROM crm_field_values WHERE crm_field_id in (125552);
select * from activities where crm_configuration_id = 270
and type = 'conference' and crm_provider_id IS NOT NULL
and actual_start_time > '2024-09-16 09:00:00' order by scheduled_start_time;
SELECT * FROM activities WHERE id = 20871677;
SELECT * FROM crm_field_data WHERE activity_id = 20871677;
select * from crm_layouts where crm_configuration_id = 270;
select * from crm_layout_entities w......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
41240
|
2026-04-16T07:05:50.722189+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
2873747
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
29810
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM team_features where team_id = 1;
SE SELECT * FROM team_features where team_id = 1;
SELECT * FROM teams WHERE name LIKE '%Vixio%'; # 340,270,11922
SELECT * FROM users WHERE team_id = 340; # 12015
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 340
and sa.provider = 'salesforce';
# and sa.provider = 'salesloft';
select * from crm_fields where crm_configuration_id = 270 and object_type = 'event';
# 125558 - Event Type - Event_Type__c
# 125552 - Event Status - Event_Status__c
SELECT * FROM sidekick_settings WHERE team_id = 340;
SELECT * FROM crm_field_values WHERE crm_field_id in (125552);
select * from activities where crm_configuration_id = 270
and type = 'conference' and crm_provider_id IS NOT NULL
and actual_start_time > '2024-09-16 09:00:00' order by scheduled_start_time;
SELECT * FROM activities WHERE id = 20871677;
SELECT * FROM crm_field_data WHERE activity_id = 20871677;
select * from crm_layouts where crm_configuration_id = 270;
select * from crm_layout_entities w......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
41251
|
2026-04-16T07:06:21.780178+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
2904805
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
29810
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM team_features where team_id = 1;
SE SELECT * FROM team_features where team_id = 1;
SELECT * FROM teams WHERE name LIKE '%Vixio%'; # 340,270,11922
SELECT * FROM users WHERE team_id = 340; # 12015
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 340
and sa.provider = 'salesforce';
# and sa.provider = 'salesloft';
select * from crm_fields where crm_configuration_id = 270 and object_type = 'event';
# 125558 - Event Type - Event_Type__c
# 125552 - Event Status - Event_Status__c
SELECT * FROM sidekick_settings WHERE team_id = 340;
SELECT * FROM crm_field_values WHERE crm_field_id in (125552);
select * from activities where crm_configuration_id = 270
and type = 'conference' and crm_provider_id IS NOT NULL
and actual_start_time > '2024-09-16 09:00:00' order by scheduled_start_time;
SELECT * FROM activities WHERE id = 20871677;
SELECT * FROM crm_field_data WHERE activity_id = 20871677;
select * from crm_layouts where crm_configuration_id = 270;
select * from crm_layout_entities w......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
41255
|
2026-04-16T07:06:43.248079+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
2926274
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
29810
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM team_features where team_id = 1;
SE SELECT * FROM team_features where team_id = 1;
SELECT * FROM teams WHERE name LIKE '%Vixio%'; # 340,270,11922
SELECT * FROM users WHERE team_id = 340; # 12015
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 340
and sa.provider = 'salesforce';
# and sa.provider = 'salesloft';
select * from crm_fields where crm_configuration_id = 270 and object_type = 'event';
# 125558 - Event Type - Event_Type__c
# 125552 - Event Status - Event_Status__c
SELECT * FROM sidekick_settings WHERE team_id = 340;
SELECT * FROM crm_field_values WHERE crm_field_id in (125552);
select * from activities where crm_configuration_id = 270
and type = 'conference' and crm_provider_id IS NOT NULL
and actual_start_time > '2024-09-16 09:00:00' order by scheduled_start_time;
SELECT * FROM activities WHERE id = 20871677;
SELECT * FROM crm_field_data WHERE activity_id = 20871677;
select * from crm_layouts where crm_configuration_id = 270;
select * from crm_layout_entities w......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
41263
|
2026-04-16T07:06:52.146424+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
2935096
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
29810
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM team_features where team_id = 1;
SE SELECT * FROM team_features where team_id = 1;
SELECT * FROM teams WHERE name LIKE '%Vixio%'; # 340,270,11922
SELECT * FROM users WHERE team_id = 340; # 12015
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 340
and sa.provider = 'salesforce';
# and sa.provider = 'salesloft';
select * from crm_fields where crm_configuration_id = 270 and object_type = 'event';
# 125558 - Event Type - Event_Type__c
# 125552 - Event Status - Event_Status__c
SELECT * FROM sidekick_settings WHERE team_id = 340;
SELECT * FROM crm_field_values WHERE crm_field_id in (125552);
select * from activities where crm_configuration_id = 270
and type = 'conference' and crm_provider_id IS NOT NULL
and actual_start_time > '2024-09-16 09:00:00' order by scheduled_start_time;
SELECT * FROM activities WHERE id = 20871677;
SELECT * FROM crm_field_data WHERE activity_id = 20871677;
select * from crm_layouts where crm_configuration_id = 270;
select * from crm_layout_entities w......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
41281
|
2026-04-16T07:08:07.215231+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
3010165
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
29810
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM team_features where team_id = 1;
SE SELECT * FROM team_features where team_id = 1;
SELECT * FROM teams WHERE name LIKE '%Vixio%'; # 340,270,11922
SELECT * FROM users WHERE team_id = 340; # 12015
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 340
and sa.provider = 'salesforce';
# and sa.provider = 'salesloft';
select * from crm_fields where crm_configuration_id = 270 and object_type = 'event';
# 125558 - Event Type - Event_Type__c
# 125552 - Event Status - Event_Status__c
SELECT * FROM sidekick_settings WHERE team_id = 340;
SELECT * FROM crm_field_values WHERE crm_field_id in (125552);
select * from activities where crm_configuration_id = 270
and type = 'conference' and crm_provider_id IS NOT NULL
and actual_start_time > '2024-09-16 09:00:00' order by scheduled_start_time;
SELECT * FROM activities WHERE id = 20871677;
SELECT * FROM crm_field_data WHERE activity_id = 20871677;
select * from crm_layouts where crm_configuration_id = 270;
select * from crm_layout_entities w......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
41288
|
2026-04-16T07:08:12.494325+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
3015444
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
29810
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM team_features where team_id = 1;
SE SELECT * FROM team_features where team_id = 1;
SELECT * FROM teams WHERE name LIKE '%Vixio%'; # 340,270,11922
SELECT * FROM users WHERE team_id = 340; # 12015
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 340
and sa.provider = 'salesforce';
# and sa.provider = 'salesloft';
select * from crm_fields where crm_configuration_id = 270 and object_type = 'event';
# 125558 - Event Type - Event_Type__c
# 125552 - Event Status - Event_Status__c
SELECT * FROM sidekick_settings WHERE team_id = 340;
SELECT * FROM crm_field_values WHERE crm_field_id in (125552);
select * from activities where crm_configuration_id = 270
and type = 'conference' and crm_provider_id IS NOT NULL
and actual_start_time > '2024-09-16 09:00:00' order by scheduled_start_time;
SELECT * FROM activities WHERE id = 20871677;
SELECT * FROM crm_field_data WHERE activity_id = 20871677;
select * from crm_layouts where crm_configuration_id = 270;
select * from crm_layout_entities w......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
41292
|
2026-04-16T07:08:14.718380+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
3017668
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
29810
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM team_features where team_id = 1;
SE SELECT * FROM team_features where team_id = 1;
SELECT * FROM teams WHERE name LIKE '%Vixio%'; # 340,270,11922
SELECT * FROM users WHERE team_id = 340; # 12015
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 340
and sa.provider = 'salesforce';
# and sa.provider = 'salesloft';
select * from crm_fields where crm_configuration_id = 270 and object_type = 'event';
# 125558 - Event Type - Event_Type__c
# 125552 - Event Status - Event_Status__c
SELECT * FROM sidekick_settings WHERE team_id = 340;
SELECT * FROM crm_field_values WHERE crm_field_id in (125552);
select * from activities where crm_configuration_id = 270
and type = 'conference' and crm_provider_id IS NOT NULL
and actual_start_time > '2024-09-16 09:00:00' order by scheduled_start_time;
SELECT * FROM activities WHERE id = 20871677;
SELECT * FROM crm_field_data WHERE activity_id = 20871677;
select * from crm_layouts where crm_configuration_id = 270;
select * from crm_layout_entities w......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
41302
|
2026-04-16T07:08:29.552498+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
3032502
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
29810
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM team_features where team_id = 1;
SE SELECT * FROM team_features where team_id = 1;
SELECT * FROM teams WHERE name LIKE '%Vixio%'; # 340,270,11922
SELECT * FROM users WHERE team_id = 340; # 12015
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 340
and sa.provider = 'salesforce';
# and sa.provider = 'salesloft';
select * from crm_fields where crm_configuration_id = 270 and object_type = 'event';
# 125558 - Event Type - Event_Type__c
# 125552 - Event Status - Event_Status__c
SELECT * FROM sidekick_settings WHERE team_id = 340;
SELECT * FROM crm_field_values WHERE crm_field_id in (125552);
select * from activities where crm_configuration_id = 270
and type = 'conference' and crm_provider_id IS NOT NULL
and actual_start_time > '2024-09-16 09:00:00' order by scheduled_start_time;
SELECT * FROM activities WHERE id = 20871677;
SELECT * FROM crm_field_data WHERE activity_id = 20871677;
select * from crm_layouts where crm_configuration_id = 270;
select * from crm_layout_entities w......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
41307
|
2026-04-16T07:08:37.944964+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
3040894
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
29810
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM team_features where team_id = 1;
SE SELECT * FROM team_features where team_id = 1;
SELECT * FROM teams WHERE name LIKE '%Vixio%'; # 340,270,11922
SELECT * FROM users WHERE team_id = 340; # 12015
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 340
and sa.provider = 'salesforce';
# and sa.provider = 'salesloft';
select * from crm_fields where crm_configuration_id = 270 and object_type = 'event';
# 125558 - Event Type - Event_Type__c
# 125552 - Event Status - Event_Status__c
SELECT * FROM sidekick_settings WHERE team_id = 340;
SELECT * FROM crm_field_values WHERE crm_field_id in (125552);
select * from activities where crm_configuration_id = 270
and type = 'conference' and crm_provider_id IS NOT NULL
and actual_start_time > '2024-09-16 09:00:00' order by scheduled_start_time;
SELECT * FROM activities WHERE id = 20871677;
SELECT * FROM crm_field_data WHERE activity_id = 20871677;
select * from crm_layouts where crm_configuration_id = 270;
select * from crm_layout_entities w......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
41311
|
2026-04-16T07:09:05.000456+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
3067950
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
29810
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM team_features where team_id = 1;
SE SELECT * FROM team_features where team_id = 1;
SELECT * FROM teams WHERE name LIKE '%Vixio%'; # 340,270,11922
SELECT * FROM users WHERE team_id = 340; # 12015
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 340
and sa.provider = 'salesforce';
# and sa.provider = 'salesloft';
select * from crm_fields where crm_configuration_id = 270 and object_type = 'event';
# 125558 - Event Type - Event_Type__c
# 125552 - Event Status - Event_Status__c
SELECT * FROM sidekick_settings WHERE team_id = 340;
SELECT * FROM crm_field_values WHERE crm_field_id in (125552);
select * from activities where crm_configuration_id = 270
and type = 'conference' and crm_provider_id IS NOT NULL
and actual_start_time > '2024-09-16 09:00:00' order by scheduled_start_time;
SELECT * FROM activities WHERE id = 20871677;
SELECT * FROM crm_field_data WHERE activity_id = 20871677;
select * from crm_layouts where crm_configuration_id = 270;
select * from crm_layout_entities w......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
41347
|
2026-04-16T07:11:54.722152+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
3237672
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
29810
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM team_features where team_id = 1;
SE SELECT * FROM team_features where team_id = 1;
SELECT * FROM teams WHERE name LIKE '%Vixio%'; # 340,270,11922
SELECT * FROM users WHERE team_id = 340; # 12015
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 340
and sa.provider = 'salesforce';
# and sa.provider = 'salesloft';
select * from crm_fields where crm_configuration_id = 270 and object_type = 'event';
# 125558 - Event Type - Event_Type__c
# 125552 - Event Status - Event_Status__c
SELECT * FROM sidekick_settings WHERE team_id = 340;
SELECT * FROM crm_field_values WHERE crm_field_id in (125552);
select * from activities where crm_configuration_id = 270
and type = 'conference' and crm_provider_id IS NOT NULL
and actual_start_time > '2024-09-16 09:00:00' order by scheduled_start_time;
SELECT * FROM activities WHERE id = 20871677;
SELECT * FROM crm_field_data WHERE activity_id = 20871677;
select * from crm_layouts where crm_configuration_id = 270;
select * from crm_layout_entities w......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
42014
|
2026-04-16T07:36:44.608571+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
4727529
|
click
|
1049
|
680
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
Google Chrome
|
NULL
|
New Tab - Google Chrome – Integration (pipedrive.j New Tab - Google Chrome – Integration (pipedrive.jiminny.com)...
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE id = 1;
select * from c SELECT * FROM teams WHERE id = 1;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 283;
SELECT * FROM crm_fields WHERE id = 2234;
SELECT * FROM crm_field_values WHERE crm_field_id = 2234;
select * from crm_profiles where user_id = 143;
select * from record_types where crm_configuration_id = 39; # 0121K000001MHElQAO,0121K000001MHEqQAO
select * from business_processes where crm_configuration_id = 39;
# 01941000000H669AAC, 0194......
|
Editor for console.sql
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
42041
|
2026-04-16T07:38:08.010572+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
4810930
|
click
|
1062
|
284
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
Google Chrome
|
NULL
|
New Tab - Google Chrome – Integration (pipedrive.j New Tab - Google Chrome – Integration (pipedrive.jiminny.com)...
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE id = 1;
select * from c SELECT * FROM teams WHERE id = 1;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 283;
SELECT * FROM crm_fields WHERE id = 2234;
SELECT * FROM crm_field_values WHERE crm_field_id = 2234;
select * from crm_profiles where user_id = 143;
select * from record_types where crm_configuration_id = 39; # 0121K000001MHElQAO,0121K000001MHEqQAO
select * from business_processes where crm_configuration_id = 39;
# 01941000000H669AAC, 0194......
|
Editor for console.sql
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
42043
|
2026-04-16T07:38:10.365006+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
4813285
|
click
|
1219
|
287
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
Google Chrome
|
NULL
|
New Tab - Google Chrome – Integration (pipedrive.j New Tab - Google Chrome – Integration (pipedrive.jiminny.com)...
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE id = 1;
select * from c SELECT * FROM teams WHERE id = 1;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 283;
SELECT * FROM crm_fields WHERE id = 2234;
SELECT * FROM crm_field_values WHERE crm_field_id = 2234;
select * from crm_profiles where user_id = 143;
select * from record_types where crm_configuration_id = 39; # 0121K000001MHElQAO,0121K000001MHEqQAO
select * from business_processes where crm_configuration_id = 39;
# 01941000000H669AAC, 0194......
|
Editor for console.sql
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
42066
|
2026-04-16T07:39:27.719752+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
4890639
|
click
|
1105
|
585
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
Google Chrome
|
NULL
|
New Tab - Google Chrome – Integration (pipedrive.j New Tab - Google Chrome – Integration (pipedrive.jiminny.com)...
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE id = 1;
select * from c SELECT * FROM teams WHERE id = 1;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 283;
SELECT * FROM crm_fields WHERE id = 2234;
SELECT * FROM crm_field_values WHERE crm_field_id = 2234;
select * from crm_profiles where user_id = 143;
select * from record_types where crm_configuration_id = 39; # 0121K000001MHElQAO,0121K000001MHEqQAO
select * from business_processes where crm_configuration_id = 39;
# 01941000000H669AAC, 0194......
|
Editor for console.sql
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
42153
|
2026-04-16T07:41:31.805257+00:00
|
953ffef1-5bd0-402d-b591-728d43b1e00a
|
5014724
|
click
|
1092
|
582
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
Google Chrome
|
NULL
|
New Tab - Google Chrome – Integration (pipedrive.j New Tab - Google Chrome – Integration (pipedrive.jiminny.com)...
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE id = 1;
select * from c SELECT * FROM teams WHERE id = 1;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 283;
SELECT * FROM crm_fields WHERE id = 2234;
SELECT * FROM crm_field_values WHERE crm_field_id = 2234;
select * from crm_profiles where user_id = 143;
select * from record_types where crm_configuration_id = 39; # 0121K000001MHElQAO,0121K000001MHEqQAO
select * from business_processes where crm_configuration_id = 39;
# 01941000000H669AAC, 0194......
|
Editor for console.sql
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
52396
|
2026-04-17T05:59:48.078217+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
227340
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
47782
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM team_features where team_id = 1;
SE SELECT * FROM team_features where team_id = 1;
SELECT * FROM teams WHERE name LIKE '%Vixio%'; # 340,270,11922
SELECT * FROM users WHERE team_id = 340; # 12015
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 340
and sa.provider = 'salesforce';
# and sa.provider = 'salesloft';
select * from crm_fields where crm_configuration_id = 270 and object_type = 'event';
# 125558 - Event Type - Event_Type__c
# 125552 - Event Status - Event_Status__c
SELECT * FROM sidekick_settings WHERE team_id = 340;
SELECT * FROM crm_field_values WHERE crm_field_id in (125552);
select * from activities where crm_configuration_id = 270
and type = 'conference' and crm_provider_id IS NOT NULL
and actual_start_time > '2024-09-16 09:00:00' order by scheduled_start_time;
SELECT * FROM activities WHERE id = 20871677;
SELECT * FROM crm_field_data WHERE activity_id = 20871677;
select * from crm_layouts where crm_configuration_id = 270;
select * from crm_layout_entities w......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
52405
|
2026-04-17T06:00:11.412709+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
250674
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
47782
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM team_features where team_id = 1;
SE SELECT * FROM team_features where team_id = 1;
SELECT * FROM teams WHERE name LIKE '%Vixio%'; # 340,270,11922
SELECT * FROM users WHERE team_id = 340; # 12015
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 340
and sa.provider = 'salesforce';
# and sa.provider = 'salesloft';
select * from crm_fields where crm_configuration_id = 270 and object_type = 'event';
# 125558 - Event Type - Event_Type__c
# 125552 - Event Status - Event_Status__c
SELECT * FROM sidekick_settings WHERE team_id = 340;
SELECT * FROM crm_field_values WHERE crm_field_id in (125552);
select * from activities where crm_configuration_id = 270
and type = 'conference' and crm_provider_id IS NOT NULL
and actual_start_time > '2024-09-16 09:00:00' order by scheduled_start_time;
SELECT * FROM activities WHERE id = 20871677;
SELECT * FROM crm_field_data WHERE activity_id = 20871677;
select * from crm_layouts where crm_configuration_id = 270;
select * from crm_layout_entities w......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
52588
|
2026-04-17T06:08:25.980864+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
745226
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
47782
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE name LIKE '%litify%& SELECT * FROM teams WHERE name LIKE '%litify%'; # 1069, 994, 24993
SELECT * FROM users WHERE id = 25061;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 994;
SELECT * FROM crm_profiles WHERE user_id = 25061;
select * from crm_configurations where id = 834;
SELECT * FROM teams WHERE id = 882;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 882 and sa.provider = 'hubspot';
SELECT * FROM crm_configurations where id = 882; # 933 - GoGlobal
SELECT * FROM opportunities WHERE team_id = 933 order by updated_at desc;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 933 and sa.provider = 'hubspot';
......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
52593
|
2026-04-17T06:08:36.988935+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
756233
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
47782
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE name LIKE '%litify%& SELECT * FROM teams WHERE name LIKE '%litify%'; # 1069, 994, 24993
SELECT * FROM users WHERE id = 25061;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 994;
SELECT * FROM crm_profiles WHERE user_id = 25061;
select * from crm_configurations where id = 834;
SELECT * FROM teams WHERE id = 882;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 882 and sa.provider = 'hubspot';
SELECT * FROM crm_configurations where id = 882; # 933 - GoGlobal
SELECT * FROM opportunities WHERE team_id = 933 order by updated_at desc;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 933 and sa.provider = 'hubspot';
......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
52597
|
2026-04-17T06:08:41.986490+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
761231
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
47782
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE name LIKE '%litify%& SELECT * FROM teams WHERE name LIKE '%litify%'; # 1069, 994, 24993
SELECT * FROM users WHERE id = 25061;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 994;
SELECT * FROM crm_profiles WHERE user_id = 25061;
select * from crm_configurations where id = 834;
SELECT * FROM teams WHERE id = 882;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 882 and sa.provider = 'hubspot';
SELECT * FROM crm_configurations where id = 882; # 933 - GoGlobal
SELECT * FROM opportunities WHERE team_id = 933 order by updated_at desc;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 933 and sa.provider = 'hubspot';
......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
52615
|
2026-04-17T06:09:57.547361+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
836791
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
47782
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE name LIKE '%litify%& SELECT * FROM teams WHERE name LIKE '%litify%'; # 1069, 994, 24993
SELECT * FROM users WHERE id = 25061;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 994;
SELECT * FROM crm_profiles WHERE user_id = 25061;
select * from crm_configurations where id = 834;
SELECT * FROM teams WHERE id = 882;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 882 and sa.provider = 'hubspot';
SELECT * FROM crm_configurations where id = 882; # 933 - GoGlobal
SELECT * FROM opportunities WHERE team_id = 933 order by updated_at desc;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 933 and sa.provider = 'hubspot';
......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
52620
|
2026-04-17T06:10:51.044304+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
890288
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
47782
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE name LIKE '%litify%& SELECT * FROM teams WHERE name LIKE '%litify%'; # 1069, 994, 24993
SELECT * FROM users WHERE id = 25061;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 994;
SELECT * FROM crm_profiles WHERE user_id = 25061;
select * from crm_configurations where id = 834;
SELECT * FROM teams WHERE id = 882;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 882 and sa.provider = 'hubspot';
SELECT * FROM crm_configurations where id = 882; # 933 - GoGlobal
SELECT * FROM opportunities WHERE team_id = 933 order by updated_at desc;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 933 and sa.provider = 'hubspot';
......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
52739
|
2026-04-17T06:14:31.867271+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
1111111
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
47782
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE name LIKE '%litify%& SELECT * FROM teams WHERE name LIKE '%litify%'; # 1069, 994, 24993
SELECT * FROM users WHERE id = 25061;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 994;
SELECT * FROM crm_profiles WHERE user_id = 25061;
select * from crm_configurations where id = 834;
SELECT * FROM teams WHERE id = 882;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 882 and sa.provider = 'hubspot';
SELECT * FROM crm_configurations where id = 882; # 933 - GoGlobal
SELECT * FROM opportunities WHERE team_id = 933 order by updated_at desc;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 933 and sa.provider = 'hubspot';
......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
52903
|
2026-04-17T06:20:28.159748+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
1467403
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
47782
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE name LIKE '%litify%& SELECT * FROM teams WHERE name LIKE '%litify%'; # 1069, 994, 24993
SELECT * FROM users WHERE id = 25061;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 994;
SELECT * FROM crm_profiles WHERE user_id = 25061;
select * from crm_configurations where id = 834;
SELECT * FROM teams WHERE id = 882;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 882 and sa.provider = 'hubspot';
SELECT * FROM crm_configurations where id = 882; # 933 - GoGlobal
SELECT * FROM opportunities WHERE team_id = 933 order by updated_at desc;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 933 and sa.provider = 'hubspot';
......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
52927
|
2026-04-17T06:21:04.134446+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
1503378
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
47782
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE name LIKE '%litify%& SELECT * FROM teams WHERE name LIKE '%litify%'; # 1069, 994, 24993
SELECT * FROM users WHERE id = 25061;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 994;
SELECT * FROM crm_profiles WHERE user_id = 25061;
select * from crm_configurations where id = 834;
SELECT * FROM teams WHERE id = 882;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 882 and sa.provider = 'hubspot';
SELECT * FROM crm_configurations where id = 882; # 933 - GoGlobal
SELECT * FROM opportunities WHERE team_id = 933 order by updated_at desc;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 933 and sa.provider = 'hubspot';
......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
52931
|
2026-04-17T06:21:30.195690+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
1529439
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
47782
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE name LIKE '%litify%& SELECT * FROM teams WHERE name LIKE '%litify%'; # 1069, 994, 24993
SELECT * FROM users WHERE id = 25061;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 994;
SELECT * FROM crm_profiles WHERE user_id = 25061;
select * from crm_configurations where id = 834;
SELECT * FROM teams WHERE id = 882;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 882 and sa.provider = 'hubspot';
SELECT * FROM crm_configurations where id = 882; # 933 - GoGlobal
SELECT * FROM opportunities WHERE team_id = 933 order by updated_at desc;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 933 and sa.provider = 'hubspot';
......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
52938
|
2026-04-17T06:21:36.773134+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
1536016
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
47782
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE name LIKE '%litify%& SELECT * FROM teams WHERE name LIKE '%litify%'; # 1069, 994, 24993
SELECT * FROM users WHERE id = 25061;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 994;
SELECT * FROM crm_profiles WHERE user_id = 25061;
select * from crm_configurations where id = 834;
SELECT * FROM teams WHERE id = 882;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 882 and sa.provider = 'hubspot';
SELECT * FROM crm_configurations where id = 882; # 933 - GoGlobal
SELECT * FROM opportunities WHERE team_id = 933 order by updated_at desc;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 933 and sa.provider = 'hubspot';
......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
52969
|
2026-04-17T06:22:11.981439+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
1571225
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
PhpStorm
|
8
|
PhpStorm
|
47782
|
NULL
|
NULL
|
AXTextArea
|
Editor for console.sql
|
SELECT * FROM teams WHERE name LIKE '%litify%& SELECT * FROM teams WHERE name LIKE '%litify%'; # 1069, 994, 24993
SELECT * FROM users WHERE id = 25061;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 994;
SELECT * FROM crm_profiles WHERE user_id = 25061;
select * from crm_configurations where id = 834;
SELECT * FROM teams WHERE id = 882;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 882 and sa.provider = 'hubspot';
SELECT * FROM crm_configurations where id = 882; # 933 - GoGlobal
SELECT * FROM opportunities WHERE team_id = 933 order by updated_at desc;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 933 and sa.provider = 'hubspot';
......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|