SQLize | PHPize | SQLtest

CREATE TABLE `xx_morn_consult_bids` ( `id` varchar(36) NOT NULL COMMENT 'bid id from vendor', `buyer_id` varchar(36) NOT NULL COMMENT 'buyer_id from vendor', `buyer_account_id` varchar(36) NOT NULL COMMENT 'buyer_account_id from vendor', `country_id` varchar(4) DEFAULT NULL COMMENT 'country id code - like lv', `end_date` datetime DEFAULT NULL, `closed_at` datetime DEFAULT NULL, `exclusions` json DEFAULT NULL COMMENT 'json', `language_ids` json NOT NULL COMMENT 'json', `name` varchar(36) DEFAULT NULL, `published_at` datetime DEFAULT NULL, `quotas` json DEFAULT NULL COMMENT 'json', `state` varchar(10) NOT NULL COMMENT 'active paused ...', `statistics` json DEFAULT NULL COMMENT 'json', `supplier_exclusive` int DEFAULT NULL, `survey_type` varchar(36) DEFAULT NULL COMMENT 'like adhock', `timeout` int unsigned DEFAULT NULL COMMENT 'IP Address', `topic_id` varchar(36) DEFAULT NULL COMMENT 'like general', `created` datetime DEFAULT NULL, `modified` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='MorningConsult bids income log'; INSERT INTO `xx_morn_consult_bids`(`id`, `buyer_id`, `buyer_account_id`, `country_id`, `end_date`, `closed_at`, `exclusions`, `language_ids`, `name`, `published_at`, `quotas`, `state`, `statistics`, `supplier_exclusive`, `survey_type`, `timeout`, `topic_id`, `created`, `modified`) VALUES ('ef06f6ab-2765-4f76-82c3-de448fa785af', 'e622f37b-9e7f-4b7a-93ef-74ed432da746', 'd2728d37-6373-44c6-8b46-cde74ef3a371', 'il', '2023-05-14 06:03:32', NULL, '[{\"group_id\": \"309d907b-cefe-5524-91ea-8bcb604e8a48\", \"lockout_period\": 7}]', '[\"en\", \"he\"]', 'Ad-Hoc Survey', '2023-04-14 06:03:32', '[{\"id\": \"9b47adb9-9122-4b7c-9607-6eabd6027e7e\", \"statistics\": {\"num_failures\": 42, \"num_timeouts\": 17, \"num_available\": 289, \"num_completes\": 10, \"num_qualified\": 271, \"num_in_progress\": 0, \"num_over_quotas\": 25, \"length_of_interview\": 1551, \"qualified_conversion\": 4, \"num_quality_terminations\": 93}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"18\", \"19\", \"20\", \"21\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", \"29\", \"30\", \"31\", \"32\", \"33\", \"34\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"b9f7f33a-08f8-43e0-8191-3c977ea922d4\", \"statistics\": {\"num_failures\": 33, \"num_timeouts\": 25, \"num_available\": 246, \"num_completes\": 7, \"num_qualified\": 261, \"num_in_progress\": 0, \"num_over_quotas\": 32, \"length_of_interview\": 1551, \"qualified_conversion\": 3, \"num_quality_terminations\": 64}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"35\", \"36\", \"37\", \"38\", \"39\", \"40\", \"41\", \"42\", \"43\", \"44\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"a6d415ff-f2e3-4b84-a092-c0c9ef07c7d9\", \"statistics\": {\"num_failures\": 36, \"num_timeouts\": 12, \"num_available\": 101, \"num_completes\": 8, \"num_qualified\": 275, \"num_in_progress\": 0, \"num_over_quotas\": 25, \"length_of_interview\": 1551, \"qualified_conversion\": 3, \"num_quality_terminations\": 82}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"45\", \"46\", \"47\", \"48\", \"49\", \"50\", \"51\", \"52\", \"53\", \"54\", \"55\", \"56\", \"57\", \"58\", \"59\", \"60\", \"61\", \"62\", \"63\", \"64\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"ffa460e3-15f5-496a-b089-a0bf0289b733\", \"statistics\": {\"num_failures\": 41, \"num_timeouts\": 14, \"num_available\": 118, \"num_completes\": 6, \"num_qualified\": 264, \"num_in_progress\": 0, \"num_over_quotas\": 22, \"length_of_interview\": 1551, \"qualified_conversion\": 2, \"num_quality_terminations\": 84}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"65\", \"66\", \"67\", \"68\", \"69\", \"70\", \"71\", \"72\", \"73\", \"74\", \"75\", \"76\", \"77\", \"78\", \"79\", \"80\", \"81\", \"82\", \"83\", \"84\", \"85\", \"86\", \"87\", \"88\", \"89\", \"90\", \"91\", \"92\", \"93\", \"94\", \"95\", \"96\", \"97\", \"98\", \"99\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"70b8acd4-cad7-4ac4-83a9-3de602ae5d3b\", \"statistics\": {\"num_failures\": 46, \"num_timeouts\": 16, \"num_available\": 385, \"num_completes\": 6, \"num_qualified\": 286, \"num_in_progress\": 0, \"num_over_quotas\": 29, \"length_of_interview\": 1551, \"qualified_conversion\": 2, \"num_quality_terminations\": 88}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"18\", \"19\", \"20\", \"21\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", \"29\", \"30\", \"31\", \"32\", \"33\", \"34\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"1386efd1-2b33-45df-8b8d-fc7c8afedc46\", \"statistics\": {\"num_failures\": 37, \"num_timeouts\": 11, \"num_available\": 207, \"num_completes\": 7, \"num_qualified\": 257, \"num_in_progress\": 0, \"num_over_quotas\": 29, \"length_of_interview\": 1551, \"qualified_conversion\": 3, \"num_quality_terminations\": 78}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"35\", \"36\", \"37\", \"38\", \"39\", \"40\", \"41\", \"42\", \"43\", \"44\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"02dbcad0-e8a9-4a0f-82de-cff1c142811f\", \"statistics\": {\"num_failures\": 46, \"num_timeouts\": 24, \"num_available\": 285, \"num_completes\": 12, \"num_qualified\": 311, \"num_in_progress\": 0, \"num_over_quotas\": 23, \"length_of_interview\": 1551, \"qualified_conversion\": 4, \"num_quality_terminations\": 91}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"45\", \"46\", \"47\", \"48\", \"49\", \"50\", \"51\", \"52\", \"53\", \"54\", \"55\", \"56\", \"57\", \"58\", \"59\", \"60\", \"61\", \"62\", \"63\", \"64\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"2fd48a55-129f-488f-92fb-146cbb59781c\", \"statistics\": {\"num_failures\": 34, \"num_timeouts\": 23, \"num_available\": 284, \"num_completes\": 7, \"num_qualified\": 251, \"num_in_progress\": 0, \"num_over_quotas\": 22, \"length_of_interview\": 1551, \"qualified_conversion\": 3, \"num_quality_terminations\": 77}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"65\", \"66\", \"67\", \"68\", \"69\", \"70\", \"71\", \"72\", \"73\", \"74\", \"75\", \"76\", \"77\", \"78\", \"79\", \"80\", \"81\", \"82\", \"83\", \"84\", \"85\", \"86\", \"87\", \"88\", \"89\", \"90\", \"91\", \"92\", \"93\", \"94\", \"95\", \"96\", \"97\", \"98\", \"99\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}]', 'active', '{\"num_entrants\": 3100, \"num_failures\": 424, \"num_timeouts\": 216, \"num_available\": 1915, \"num_completes\": 95, \"num_qualified\": 2176, \"incidence_rate\": 11, \"num_screenouts\": 1128, \"num_in_progress\": 0, \"num_over_quotas\": 305, \"system_conversion\": 3, \"earnings_per_click\": 5, \"length_of_interview\": 1551, \"qualified_conversion\": 4, \"num_quality_terminations\": 932}', 0, 'ad_hoc', 81383, 'general', '2023-04-16 14:54:49', '2023-04-16 14:54:49'); INSERT INTO `xx_morn_consult_bids`(`id`, `buyer_id`, `buyer_account_id`, `country_id`, `end_date`, `closed_at`, `exclusions`, `language_ids`, `name`, `published_at`, `quotas`, `state`, `statistics`, `supplier_exclusive`, `survey_type`, `timeout`, `topic_id`, `created`, `modified`) VALUES ('ef4cba0a-0d5e-49a0-befc-8f61f22b6b20', 'e622f37b-9e7f-4b7a-93ef-74ed432da746', 'd2728d37-6373-44c6-8b46-cde74ef3a371', 'br', '2023-05-14 06:03:32', NULL, '[{\"group_id\": \"d2460624-2d2b-5d77-93ad-ba1abdc22c48\", \"lockout_period\": 7}]', '[\"en\", \"pt\"]', 'Ad-Hoc Survey', '2023-04-14 06:03:32', '[{\"id\": \"6d13cc96-2925-4d24-b3bc-0242fe4d7671\", \"statistics\": {\"num_failures\": 24, \"num_timeouts\": 18, \"num_available\": 265, \"num_completes\": 7, \"num_qualified\": 268, \"num_in_progress\": 0, \"num_over_quotas\": 21, \"length_of_interview\": 1866, \"qualified_conversion\": 3, \"num_quality_terminations\": 80}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"18\", \"19\", \"20\", \"21\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", \"29\", \"30\", \"31\", \"32\", \"33\", \"34\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"78c30f22-d56c-467f-95f8-9f5d02ba67d9\", \"statistics\": {\"num_failures\": 36, \"num_timeouts\": 16, \"num_available\": 169, \"num_completes\": 11, \"num_qualified\": 281, \"num_in_progress\": 0, \"num_over_quotas\": 21, \"length_of_interview\": 1866, \"qualified_conversion\": 4, \"num_quality_terminations\": 88}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"35\", \"36\", \"37\", \"38\", \"39\", \"40\", \"41\", \"42\", \"43\", \"44\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"7efd3fb6-69ed-435d-a956-fd90567aca29\", \"statistics\": {\"num_failures\": 41, \"num_timeouts\": 12, \"num_available\": 221, \"num_completes\": 8, \"num_qualified\": 269, \"num_in_progress\": 0, \"num_over_quotas\": 25, \"length_of_interview\": 1866, \"qualified_conversion\": 3, \"num_quality_terminations\": 82}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"45\", \"46\", \"47\", \"48\", \"49\", \"50\", \"51\", \"52\", \"53\", \"54\", \"55\", \"56\", \"57\", \"58\", \"59\", \"60\", \"61\", \"62\", \"63\", \"64\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"bec06d57-15ce-4756-aadb-d2e9dd8a5855\", \"statistics\": {\"num_failures\": 39, \"num_timeouts\": 19, \"num_available\": 184, \"num_completes\": 10, \"num_qualified\": 258, \"num_in_progress\": 0, \"num_over_quotas\": 28, \"length_of_interview\": 1866, \"qualified_conversion\": 4, \"num_quality_terminations\": 75}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"65\", \"66\", \"67\", \"68\", \"69\", \"70\", \"71\", \"72\", \"73\", \"74\", \"75\", \"76\", \"77\", \"78\", \"79\", \"80\", \"81\", \"82\", \"83\", \"84\", \"85\", \"86\", \"87\", \"88\", \"89\", \"90\", \"91\", \"92\", \"93\", \"94\", \"95\", \"96\", \"97\", \"98\", \"99\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"990f77bc-05fe-4863-b188-42a0e1d2fe29\", \"statistics\": {\"num_failures\": 34, \"num_timeouts\": 16, \"num_available\": 225, \"num_completes\": 10, \"num_qualified\": 247, \"num_in_progress\": 0, \"num_over_quotas\": 16, \"length_of_interview\": 1866, \"qualified_conversion\": 4, \"num_quality_terminations\": 91}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"18\", \"19\", \"20\", \"21\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", \"29\", \"30\", \"31\", \"32\", \"33\", \"34\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"a3c638da-14bb-4438-acb9-6262a614fe40\", \"statistics\": {\"num_failures\": 42, \"num_timeouts\": 10, \"num_available\": 155, \"num_completes\": 8, \"num_qualified\": 293, \"num_in_progress\": 0, \"num_over_quotas\": 36, \"length_of_interview\": 1866, \"qualified_conversion\": 3, \"num_quality_terminations\": 96}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"35\", \"36\", \"37\", \"38\", \"39\", \"40\", \"41\", \"42\", \"43\", \"44\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"daa10a6a-0961-4ad4-b55d-a8090787e8ee\", \"statistics\": {\"num_failures\": 43, \"num_timeouts\": 18, \"num_available\": 220, \"num_completes\": 10, \"num_qualified\": 277, \"num_in_progress\": 0, \"num_over_quotas\": 29, \"length_of_interview\": 1866, \"qualified_conversion\": 4, \"num_quality_terminations\": 77}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"45\", \"46\", \"47\", \"48\", \"49\", \"50\", \"51\", \"52\", \"53\", \"54\", \"55\", \"56\", \"57\", \"58\", \"59\", \"60\", \"61\", \"62\", \"63\", \"64\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"00873b39-d3a0-49a2-9c81-80922e567a46\", \"statistics\": {\"num_failures\": 37, \"num_timeouts\": 14, \"num_available\": 322, \"num_completes\": 10, \"num_qualified\": 256, \"num_in_progress\": 0, \"num_over_quotas\": 21, \"length_of_interview\": 1866, \"qualified_conversion\": 4, \"num_quality_terminations\": 77}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"65\", \"66\", \"67\", \"68\", \"69\", \"70\", \"71\", \"72\", \"73\", \"74\", \"75\", \"76\", \"77\", \"78\", \"79\", \"80\", \"81\", \"82\", \"83\", \"84\", \"85\", \"86\", \"87\", \"88\", \"89\", \"90\", \"91\", \"92\", \"93\", \"94\", \"95\", \"96\", \"97\", \"98\", \"99\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}]', 'active', '{\"num_entrants\": 3100, \"num_failures\": 407, \"num_timeouts\": 183, \"num_available\": 1761, \"num_completes\": 103, \"num_qualified\": 2149, \"incidence_rate\": 11, \"num_screenouts\": 1152, \"num_in_progress\": 0, \"num_over_quotas\": 297, \"system_conversion\": 3, \"earnings_per_click\": 6, \"length_of_interview\": 1866, \"qualified_conversion\": 5, \"num_quality_terminations\": 958}', 0, 'ad_hoc', 56311, 'general', '2023-04-16 14:54:53', '2023-04-16 14:54:53'); INSERT INTO `xx_morn_consult_bids`(`id`, `buyer_id`, `buyer_account_id`, `country_id`, `end_date`, `closed_at`, `exclusions`, `language_ids`, `name`, `published_at`, `quotas`, `state`, `statistics`, `supplier_exclusive`, `survey_type`, `timeout`, `topic_id`, `created`, `modified`) VALUES ('ef756590-9645-4fe4-b9de-e96048642cad', 'e622f37b-9e7f-4b7a-93ef-74ed432da746', 'd2728d37-6373-44c6-8b46-cde74ef3a371', 'ng', '2023-05-14 06:03:32', NULL, '[{\"group_id\": \"d25dd14c-5336-5f7f-aa4a-259125cbbcc3\", \"lockout_period\": 7}]', '[\"en\"]', 'Ad-Hoc Survey', '2023-04-14 06:03:32', '[{\"id\": \"272d79ed-b538-44fa-be0f-3da7ddeeea0e\", \"statistics\": {\"num_failures\": 36, \"num_timeouts\": 19, \"num_available\": 134, \"num_completes\": 4, \"num_qualified\": 263, \"num_in_progress\": 0, \"num_over_quotas\": 23, \"length_of_interview\": 1036, \"qualified_conversion\": 100, \"num_quality_terminations\": 84}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"18\", \"19\", \"20\", \"21\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", \"29\", \"30\", \"31\", \"32\", \"33\", \"34\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"3a448279-03af-4c69-a5f0-d207612a9a65\", \"statistics\": {\"num_failures\": 44, \"num_timeouts\": 21, \"num_available\": 221, \"num_completes\": 3, \"num_qualified\": 264, \"num_in_progress\": 0, \"num_over_quotas\": 28, \"length_of_interview\": 1036, \"qualified_conversion\": 100, \"num_quality_terminations\": 74}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"35\", \"36\", \"37\", \"38\", \"39\", \"40\", \"41\", \"42\", \"43\", \"44\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"99aa19c1-3bd5-4935-8fb8-a78df03adad3\", \"statistics\": {\"num_failures\": 31, \"num_timeouts\": 18, \"num_available\": 189, \"num_completes\": 13, \"num_qualified\": 279, \"num_in_progress\": 0, \"num_over_quotas\": 30, \"length_of_interview\": 1396, \"qualified_conversion\": 5, \"num_quality_terminations\": 78}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"45\", \"46\", \"47\", \"48\", \"49\", \"50\", \"51\", \"52\", \"53\", \"54\", \"55\", \"56\", \"57\", \"58\", \"59\", \"60\", \"61\", \"62\", \"63\", \"64\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"86aeb173-6075-406d-b821-0f41dd22ae8b\", \"statistics\": {\"num_failures\": 34, \"num_timeouts\": 19, \"num_available\": 368, \"num_completes\": 9, \"num_qualified\": 301, \"num_in_progress\": 0, \"num_over_quotas\": 43, \"length_of_interview\": 1396, \"qualified_conversion\": 3, \"num_quality_terminations\": 90}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"65\", \"66\", \"67\", \"68\", \"69\", \"70\", \"71\", \"72\", \"73\", \"74\", \"75\", \"76\", \"77\", \"78\", \"79\", \"80\", \"81\", \"82\", \"83\", \"84\", \"85\", \"86\", \"87\", \"88\", \"89\", \"90\", \"91\", \"92\", \"93\", \"94\", \"95\", \"96\", \"97\", \"98\", \"99\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"c9137e13-2a78-427b-a4a7-1608a5060a6e\", \"statistics\": {\"num_failures\": 41, \"num_timeouts\": 25, \"num_available\": 367, \"num_completes\": 5, \"num_qualified\": 275, \"num_in_progress\": 0, \"num_over_quotas\": 27, \"length_of_interview\": 1396, \"qualified_conversion\": 2, \"num_quality_terminations\": 71}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"18\", \"19\", \"20\", \"21\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", \"29\", \"30\", \"31\", \"32\", \"33\", \"34\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"bf5a841c-747b-42ee-9cdb-a8a1131a8f00\", \"statistics\": {\"num_failures\": 32, \"num_timeouts\": 25, \"num_available\": 287, \"num_completes\": 7, \"num_qualified\": 259, \"num_in_progress\": 0, \"num_over_quotas\": 25, \"length_of_interview\": 1396, \"qualified_conversion\": 3, \"num_quality_terminations\": 81}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"35\", \"36\", \"37\", \"38\", \"39\", \"40\", \"41\", \"42\", \"43\", \"44\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"c9555997-a26e-46e5-8adf-a0d60c7c32fa\", \"statistics\": {\"num_failures\": 32, \"num_timeouts\": 18, \"num_available\": 282, \"num_completes\": 9, \"num_qualified\": 276, \"num_in_progress\": 0, \"num_over_quotas\": 37, \"length_of_interview\": 1396, \"qualified_conversion\": 3, \"num_quality_terminations\": 83}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"45\", \"46\", \"47\", \"48\", \"49\", \"50\", \"51\", \"52\", \"53\", \"54\", \"55\", \"56\", \"57\", \"58\", \"59\", \"60\", \"61\", \"62\", \"63\", \"64\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"f4d8be5f-16e6-4ed3-adc9-529ce4954180\", \"statistics\": {\"num_failures\": 21, \"num_timeouts\": 17, \"num_available\": 370, \"num_completes\": 7, \"num_qualified\": 263, \"num_in_progress\": 0, \"num_over_quotas\": 21, \"length_of_interview\": 1396, \"qualified_conversion\": 3, \"num_quality_terminations\": 84}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"65\", \"66\", \"67\", \"68\", \"69\", \"70\", \"71\", \"72\", \"73\", \"74\", \"75\", \"76\", \"77\", \"78\", \"79\", \"80\", \"81\", \"82\", \"83\", \"84\", \"85\", \"86\", \"87\", \"88\", \"89\", \"90\", \"91\", \"92\", \"93\", \"94\", \"95\", \"96\", \"97\", \"98\", \"99\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}]', 'active', '{\"num_entrants\": 3100, \"num_failures\": 399, \"num_timeouts\": 217, \"num_available\": 2218, \"num_completes\": 85, \"num_qualified\": 2180, \"incidence_rate\": 9, \"num_screenouts\": 1156, \"num_in_progress\": 0, \"num_over_quotas\": 318, \"system_conversion\": 3, \"earnings_per_click\": 3, \"length_of_interview\": 1396, \"qualified_conversion\": 4, \"num_quality_terminations\": 925}', 0, 'ad_hoc', 68099, 'general', '2023-04-16 14:55:04', '2023-04-16 14:55:04'); INSERT INTO `xx_morn_consult_bids`(`id`, `buyer_id`, `buyer_account_id`, `country_id`, `end_date`, `closed_at`, `exclusions`, `language_ids`, `name`, `published_at`, `quotas`, `state`, `statistics`, `supplier_exclusive`, `survey_type`, `timeout`, `topic_id`, `created`, `modified`) VALUES ('f0390627-9d2e-43cf-b18f-46bcfc96b961', 'e622f37b-9e7f-4b7a-93ef-74ed432da746', 'd2728d37-6373-44c6-8b46-cde74ef3a371', 'ru', '2023-05-14 06:03:32', NULL, '[{\"group_id\": \"48094d36-81e2-55ee-a9f8-cd1cda96511f\", \"lockout_period\": 7}]', '[\"en\", \"ru\"]', 'Ad-Hoc Survey', '2023-04-14 06:03:32', '[{\"id\": \"c9a94f0c-3289-428e-bd55-f0e2568c9605\", \"statistics\": {\"num_failures\": 31, \"num_timeouts\": 18, \"num_available\": 250, \"num_completes\": 5, \"num_qualified\": 252, \"num_in_progress\": 0, \"num_over_quotas\": 30, \"length_of_interview\": 1933, \"qualified_conversion\": 2, \"num_quality_terminations\": 68}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"18\", \"19\", \"20\", \"21\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", \"29\", \"30\", \"31\", \"32\", \"33\", \"34\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 329}, {\"id\": \"06e8b32d-ce25-4358-acd4-ef8194b0ff08\", \"statistics\": {\"num_failures\": 39, \"num_timeouts\": 25, \"num_available\": 258, \"num_completes\": 8, \"num_qualified\": 267, \"num_in_progress\": 0, \"num_over_quotas\": 26, \"length_of_interview\": 1933, \"qualified_conversion\": 3, \"num_quality_terminations\": 73}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"35\", \"36\", \"37\", \"38\", \"39\", \"40\", \"41\", \"42\", \"43\", \"44\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 186}, {\"id\": \"17f83518-37eb-46d1-a1f1-6a256ba587cd\", \"statistics\": {\"num_failures\": 44, \"num_timeouts\": 21, \"num_available\": 149, \"num_completes\": 5, \"num_qualified\": 258, \"num_in_progress\": 0, \"num_over_quotas\": 26, \"length_of_interview\": 1933, \"qualified_conversion\": 2, \"num_quality_terminations\": 75}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"45\", \"46\", \"47\", \"48\", \"49\", \"50\", \"51\", \"52\", \"53\", \"54\", \"55\", \"56\", \"57\", \"58\", \"59\", \"60\", \"61\", \"62\", \"63\", \"64\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 380}, {\"id\": \"e5d0be5e-514c-4e38-afbc-50eb7da003dd\", \"statistics\": {\"num_failures\": 37, \"num_timeouts\": 17, \"num_available\": 163, \"num_completes\": 9, \"num_qualified\": 263, \"num_in_progress\": 0, \"num_over_quotas\": 35, \"length_of_interview\": 1933, \"qualified_conversion\": 3, \"num_quality_terminations\": 69}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"65\", \"66\", \"67\", \"68\", \"69\", \"70\", \"71\", \"72\", \"73\", \"74\", \"75\", \"76\", \"77\", \"78\", \"79\", \"80\", \"81\", \"82\", \"83\", \"84\", \"85\", \"86\", \"87\", \"88\", \"89\", \"90\", \"91\", \"92\", \"93\", \"94\", \"95\", \"96\", \"97\", \"98\", \"99\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 266}, {\"id\": \"3ca3c7e6-a320-4b35-93c0-2a4c06818bda\", \"statistics\": {\"num_failures\": 33, \"num_timeouts\": 17, \"num_available\": 205, \"num_completes\": 8, \"num_qualified\": 277, \"num_in_progress\": 0, \"num_over_quotas\": 24, \"length_of_interview\": 1933, \"qualified_conversion\": 3, \"num_quality_terminations\": 101}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"18\", \"19\", \"20\", \"21\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", \"29\", \"30\", \"31\", \"32\", \"33\", \"34\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 324}, {\"id\": \"9d9b78c3-989c-4def-bf9f-a19ce3e146eb\", \"statistics\": {\"num_failures\": 37, \"num_timeouts\": 16, \"num_available\": 200, \"num_completes\": 17, \"num_qualified\": 272, \"num_in_progress\": 0, \"num_over_quotas\": 29, \"length_of_interview\": 1933, \"qualified_conversion\": 6, \"num_quality_terminations\": 64}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"35\", \"36\", \"37\", \"38\", \"39\", \"40\", \"41\", \"42\", \"43\", \"44\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 216}, {\"id\": \"88b8a845-3b59-4cf7-96fe-bafae03a682b\", \"statistics\": {\"num_failures\": 54, \"num_timeouts\": 15, \"num_available\": 182, \"num_completes\": 12, \"num_qualified\": 287, \"num_in_progress\": 0, \"num_over_quotas\": 27, \"length_of_interview\": 1933, \"qualified_conversion\": 4, \"num_quality_terminations\": 78}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"45\", \"46\", \"47\", \"48\", \"49\", \"50\", \"51\", \"52\", \"53\", \"54\", \"55\", \"56\", \"57\", \"58\", \"59\", \"60\", \"61\", \"62\", \"63\", \"64\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 390}, {\"id\": \"0d5f05cc-70c0-418f-840c-fd96af9cdc56\", \"statistics\": {\"num_failures\": 35, \"num_timeouts\": 10, \"num_available\": 105, \"num_completes\": 10, \"num_qualified\": 272, \"num_in_progress\": 0, \"num_over_quotas\": 31, \"length_of_interview\": 1933, \"qualified_conversion\": 4, \"num_quality_terminations\": 93}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"65\", \"66\", \"67\", \"68\", \"69\", \"70\", \"71\", \"72\", \"73\", \"74\", \"75\", \"76\", \"77\", \"78\", \"79\", \"80\", \"81\", \"82\", \"83\", \"84\", \"85\", \"86\", \"87\", \"88\", \"89\", \"90\", \"91\", \"92\", \"93\", \"94\", \"95\", \"96\", \"97\", \"98\", \"99\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 119}]', 'paused', '{\"num_entrants\": 3100, \"num_failures\": 431, \"num_timeouts\": 198, \"num_available\": 1512, \"num_completes\": 111, \"num_qualified\": 2148, \"incidence_rate\": 13, \"num_screenouts\": 1134, \"num_in_progress\": 0, \"num_over_quotas\": 314, \"system_conversion\": 4, \"earnings_per_click\": 6, \"length_of_interview\": 1933, \"qualified_conversion\": 5, \"num_quality_terminations\": 912}', 0, 'ad_hoc', 63557, 'general', '2023-04-16 14:55:09', '2023-04-16 14:55:09'); INSERT INTO `xx_morn_consult_bids`(`id`, `buyer_id`, `buyer_account_id`, `country_id`, `end_date`, `closed_at`, `exclusions`, `language_ids`, `name`, `published_at`, `quotas`, `state`, `statistics`, `supplier_exclusive`, `survey_type`, `timeout`, `topic_id`, `created`, `modified`) VALUES ('f05ee2b8-49b2-41f1-87c6-cdc47098a22d', 'e622f37b-9e7f-4b7a-93ef-74ed432da746', 'd2728d37-6373-44c6-8b46-cde74ef3a371', 'co', '2023-05-14 06:03:32', NULL, '[{\"group_id\": \"1186dffc-4b78-5138-a553-46d0cc83c34b\", \"lockout_period\": 7}]', '[\"en\", \"es\"]', 'Ad-Hoc Survey', '2023-04-14 06:03:32', '[{\"id\": \"b75dda2c-f95e-4d91-893a-efe8ef0cd2b7\", \"statistics\": {\"num_failures\": 43, \"num_timeouts\": 18, \"num_available\": 217, \"num_completes\": 14, \"num_qualified\": 309, \"num_in_progress\": 0, \"num_over_quotas\": 27, \"length_of_interview\": 1406, \"qualified_conversion\": 5, \"num_quality_terminations\": 100}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"18\", \"19\", \"20\", \"21\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", \"29\", \"30\", \"31\", \"32\", \"33\", \"34\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"a9e58064-8030-486a-85a8-52211bbc2c09\", \"statistics\": {\"num_failures\": 31, \"num_timeouts\": 21, \"num_available\": 196, \"num_completes\": 8, \"num_qualified\": 258, \"num_in_progress\": 0, \"num_over_quotas\": 24, \"length_of_interview\": 1406, \"qualified_conversion\": 3, \"num_quality_terminations\": 77}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"35\", \"36\", \"37\", \"38\", \"39\", \"40\", \"41\", \"42\", \"43\", \"44\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"b859bb62-31f8-4712-953a-fb5d548c0ef6\", \"statistics\": {\"num_failures\": 35, \"num_timeouts\": 23, \"num_available\": 93, \"num_completes\": 7, \"num_qualified\": 260, \"num_in_progress\": 0, \"num_over_quotas\": 27, \"length_of_interview\": 1406, \"qualified_conversion\": 3, \"num_quality_terminations\": 72}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"45\", \"46\", \"47\", \"48\", \"49\", \"50\", \"51\", \"52\", \"53\", \"54\", \"55\", \"56\", \"57\", \"58\", \"59\", \"60\", \"61\", \"62\", \"63\", \"64\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"e86678d6-b610-47b0-a2be-d6c1e90ce353\", \"statistics\": {\"num_failures\": 26, \"num_timeouts\": 20, \"num_available\": 139, \"num_completes\": 8, \"num_qualified\": 260, \"num_in_progress\": 0, \"num_over_quotas\": 34, \"length_of_interview\": 1406, \"qualified_conversion\": 3, \"num_quality_terminations\": 61}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"65\", \"66\", \"67\", \"68\", \"69\", \"70\", \"71\", \"72\", \"73\", \"74\", \"75\", \"76\", \"77\", \"78\", \"79\", \"80\", \"81\", \"82\", \"83\", \"84\", \"85\", \"86\", \"87\", \"88\", \"89\", \"90\", \"91\", \"92\", \"93\", \"94\", \"95\", \"96\", \"97\", \"98\", \"99\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"47068c85-60a3-403b-860b-aae9dc6241f9\", \"statistics\": {\"num_failures\": 41, \"num_timeouts\": 16, \"num_available\": 176, \"num_completes\": 15, \"num_qualified\": 232, \"num_in_progress\": 0, \"num_over_quotas\": 21, \"length_of_interview\": 1406, \"qualified_conversion\": 6, \"num_quality_terminations\": 56}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"18\", \"19\", \"20\", \"21\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", \"29\", \"30\", \"31\", \"32\", \"33\", \"34\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"2fb1b826-860f-4265-ad4b-7ada9dd7c192\", \"statistics\": {\"num_failures\": 29, \"num_timeouts\": 27, \"num_available\": 219, \"num_completes\": 6, \"num_qualified\": 282, \"num_in_progress\": 0, \"num_over_quotas\": 30, \"length_of_interview\": 1406, \"qualified_conversion\": 2, \"num_quality_terminations\": 79}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"35\", \"36\", \"37\", \"38\", \"39\", \"40\", \"41\", \"42\", \"43\", \"44\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"6b45f229-a229-42d1-be81-039c8c373ea2\", \"statistics\": {\"num_failures\": 47, \"num_timeouts\": 13, \"num_available\": 371, \"num_completes\": 10, \"num_qualified\": 254, \"num_in_progress\": 0, \"num_over_quotas\": 26, \"length_of_interview\": 1406, \"qualified_conversion\": 4, \"num_quality_terminations\": 72}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"45\", \"46\", \"47\", \"48\", \"49\", \"50\", \"51\", \"52\", \"53\", \"54\", \"55\", \"56\", \"57\", \"58\", \"59\", \"60\", \"61\", \"62\", \"63\", \"64\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"236f6e6e-5a09-402a-91ef-a054499c3ad4\", \"statistics\": {\"num_failures\": 37, \"num_timeouts\": 17, \"num_available\": 262, \"num_completes\": 4, \"num_qualified\": 270, \"num_in_progress\": 0, \"num_over_quotas\": 31, \"length_of_interview\": 1046, \"qualified_conversion\": 100, \"num_quality_terminations\": 80}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"65\", \"66\", \"67\", \"68\", \"69\", \"70\", \"71\", \"72\", \"73\", \"74\", \"75\", \"76\", \"77\", \"78\", \"79\", \"80\", \"81\", \"82\", \"83\", \"84\", \"85\", \"86\", \"87\", \"88\", \"89\", \"90\", \"91\", \"92\", \"93\", \"94\", \"95\", \"96\", \"97\", \"98\", \"99\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}]', 'active', '{\"num_entrants\": 3100, \"num_failures\": 431, \"num_timeouts\": 213, \"num_available\": 1673, \"num_completes\": 108, \"num_qualified\": 2125, \"incidence_rate\": 12, \"num_screenouts\": 1129, \"num_in_progress\": 0, \"num_over_quotas\": 316, \"system_conversion\": 3, \"earnings_per_click\": 7, \"length_of_interview\": 1406, \"qualified_conversion\": 5, \"num_quality_terminations\": 903}', 0, 'ad_hoc', 64992, 'general', '2023-04-16 14:54:52', '2023-04-16 14:54:52'); INSERT INTO `xx_morn_consult_bids`(`id`, `buyer_id`, `buyer_account_id`, `country_id`, `end_date`, `closed_at`, `exclusions`, `language_ids`, `name`, `published_at`, `quotas`, `state`, `statistics`, `supplier_exclusive`, `survey_type`, `timeout`, `topic_id`, `created`, `modified`) VALUES ('f1352f0b-6d39-4d8c-8c90-aa6ed5a59f6e', 'e622f37b-9e7f-4b7a-93ef-74ed432da746', 'd2728d37-6373-44c6-8b46-cde74ef3a371', 'ru', '2023-05-14 06:03:32', NULL, '[{\"group_id\": \"233fff8d-f247-5864-a27d-760f4fab2371\", \"lockout_period\": 7}]', '[\"en\", \"ru\"]', 'Ad-Hoc Survey', '2023-04-14 06:03:32', '[{\"id\": \"f1cb17c6-43c8-4ba2-950f-833bf7d10941\", \"statistics\": {\"num_failures\": 35, \"num_timeouts\": 19, \"num_available\": 335, \"num_completes\": 10, \"num_qualified\": 277, \"num_in_progress\": 0, \"num_over_quotas\": 25, \"length_of_interview\": 2183, \"qualified_conversion\": 4, \"num_quality_terminations\": 78}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"18\", \"19\", \"20\", \"21\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", \"29\", \"30\", \"31\", \"32\", \"33\", \"34\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"54e21c49-1d89-49d9-86b3-1bc55189f7ed\", \"statistics\": {\"num_failures\": 34, \"num_timeouts\": 20, \"num_available\": 335, \"num_completes\": 7, \"num_qualified\": 231, \"num_in_progress\": 0, \"num_over_quotas\": 23, \"length_of_interview\": 2183, \"qualified_conversion\": 3, \"num_quality_terminations\": 62}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"35\", \"36\", \"37\", \"38\", \"39\", \"40\", \"41\", \"42\", \"43\", \"44\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"02992dea-4d0b-4ed2-9865-e68f6b39b8de\", \"statistics\": {\"num_failures\": 28, \"num_timeouts\": 28, \"num_available\": 250, \"num_completes\": 10, \"num_qualified\": 252, \"num_in_progress\": 0, \"num_over_quotas\": 28, \"length_of_interview\": 2183, \"qualified_conversion\": 4, \"num_quality_terminations\": 73}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"45\", \"46\", \"47\", \"48\", \"49\", \"50\", \"51\", \"52\", \"53\", \"54\", \"55\", \"56\", \"57\", \"58\", \"59\", \"60\", \"61\", \"62\", \"63\", \"64\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"c4aa27ab-d8a1-4d84-8899-056f2c6b4151\", \"statistics\": {\"num_failures\": 38, \"num_timeouts\": 18, \"num_available\": 152, \"num_completes\": 13, \"num_qualified\": 257, \"num_in_progress\": 0, \"num_over_quotas\": 17, \"length_of_interview\": 2183, \"qualified_conversion\": 5, \"num_quality_terminations\": 79}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"65\", \"66\", \"67\", \"68\", \"69\", \"70\", \"71\", \"72\", \"73\", \"74\", \"75\", \"76\", \"77\", \"78\", \"79\", \"80\", \"81\", \"82\", \"83\", \"84\", \"85\", \"86\", \"87\", \"88\", \"89\", \"90\", \"91\", \"92\", \"93\", \"94\", \"95\", \"96\", \"97\", \"98\", \"99\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"44e7ff0f-431d-4063-b8bc-c8a290d9da4b\", \"statistics\": {\"num_failures\": 52, \"num_timeouts\": 17, \"num_available\": 358, \"num_completes\": 6, \"num_qualified\": 288, \"num_in_progress\": 0, \"num_over_quotas\": 33, \"length_of_interview\": 2183, \"qualified_conversion\": 2, \"num_quality_terminations\": 79}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"18\", \"19\", \"20\", \"21\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", \"29\", \"30\", \"31\", \"32\", \"33\", \"34\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"de17f6e7-dcf9-4ba3-be11-75ee2cf5c7d0\", \"statistics\": {\"num_failures\": 39, \"num_timeouts\": 19, \"num_available\": 308, \"num_completes\": 16, \"num_qualified\": 310, \"num_in_progress\": 0, \"num_over_quotas\": 27, \"length_of_interview\": 2183, \"qualified_conversion\": 5, \"num_quality_terminations\": 93}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"35\", \"36\", \"37\", \"38\", \"39\", \"40\", \"41\", \"42\", \"43\", \"44\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"264c5df8-5e2a-4637-8be0-b2f42b860f7f\", \"statistics\": {\"num_failures\": 43, \"num_timeouts\": 16, \"num_available\": 335, \"num_completes\": 8, \"num_qualified\": 300, \"num_in_progress\": 0, \"num_over_quotas\": 35, \"length_of_interview\": 2183, \"qualified_conversion\": 3, \"num_quality_terminations\": 88}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"45\", \"46\", \"47\", \"48\", \"49\", \"50\", \"51\", \"52\", \"53\", \"54\", \"55\", \"56\", \"57\", \"58\", \"59\", \"60\", \"61\", \"62\", \"63\", \"64\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"eef671b9-05f4-4f12-baf7-85aa061cbe7a\", \"statistics\": {\"num_failures\": 40, \"num_timeouts\": 5, \"num_available\": 197, \"num_completes\": 9, \"num_qualified\": 235, \"num_in_progress\": 0, \"num_over_quotas\": 18, \"length_of_interview\": 2183, \"qualified_conversion\": 4, \"num_quality_terminations\": 84}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"65\", \"66\", \"67\", \"68\", \"69\", \"70\", \"71\", \"72\", \"73\", \"74\", \"75\", \"76\", \"77\", \"78\", \"79\", \"80\", \"81\", \"82\", \"83\", \"84\", \"85\", \"86\", \"87\", \"88\", \"89\", \"90\", \"91\", \"92\", \"93\", \"94\", \"95\", \"96\", \"97\", \"98\", \"99\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}]', 'active', '{\"num_entrants\": 3100, \"num_failures\": 424, \"num_timeouts\": 207, \"num_available\": 2270, \"num_completes\": 109, \"num_qualified\": 2150, \"incidence_rate\": 12, \"num_screenouts\": 1121, \"num_in_progress\": 0, \"num_over_quotas\": 301, \"system_conversion\": 4, \"earnings_per_click\": 7, \"length_of_interview\": 2183, \"qualified_conversion\": 5, \"num_quality_terminations\": 938}', 0, 'ad_hoc', 71669, 'general', '2023-04-16 14:55:09', '2023-04-16 14:55:09'); INSERT INTO `xx_morn_consult_bids`(`id`, `buyer_id`, `buyer_account_id`, `country_id`, `end_date`, `closed_at`, `exclusions`, `language_ids`, `name`, `published_at`, `quotas`, `state`, `statistics`, `supplier_exclusive`, `survey_type`, `timeout`, `topic_id`, `created`, `modified`) VALUES ('f153a8b1-6da6-4b57-84c9-e958649ae678', 'e622f37b-9e7f-4b7a-93ef-74ed432da746', 'd2728d37-6373-44c6-8b46-cde74ef3a371', 'mx', '2023-05-14 06:03:32', NULL, '[{\"group_id\": \"3223882c-025d-5c00-848a-47621e5d10c7\", \"lockout_period\": 7}]', '[\"en\", \"es\"]', 'Ad-Hoc Survey', '2023-04-14 06:03:32', '[{\"id\": \"956b24c9-dde6-4406-8170-2047948c4344\", \"statistics\": {\"num_failures\": 31, \"num_timeouts\": 16, \"num_available\": 248, \"num_completes\": 10, \"num_qualified\": 270, \"num_in_progress\": 0, \"num_over_quotas\": 28, \"length_of_interview\": 1474, \"qualified_conversion\": 4, \"num_quality_terminations\": 89}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"18\", \"19\", \"20\", \"21\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", \"29\", \"30\", \"31\", \"32\", \"33\", \"34\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"f4dd9edd-996c-423c-8ef2-903236a25e96\", \"statistics\": {\"num_failures\": 39, \"num_timeouts\": 14, \"num_available\": 269, \"num_completes\": 11, \"num_qualified\": 279, \"num_in_progress\": 0, \"num_over_quotas\": 28, \"length_of_interview\": 1474, \"qualified_conversion\": 4, \"num_quality_terminations\": 86}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"35\", \"36\", \"37\", \"38\", \"39\", \"40\", \"41\", \"42\", \"43\", \"44\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"ff523f51-6d06-43e3-a066-4302ba563be7\", \"statistics\": {\"num_failures\": 33, \"num_timeouts\": 16, \"num_available\": 332, \"num_completes\": 12, \"num_qualified\": 276, \"num_in_progress\": 0, \"num_over_quotas\": 23, \"length_of_interview\": 1474, \"qualified_conversion\": 4, \"num_quality_terminations\": 91}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"45\", \"46\", \"47\", \"48\", \"49\", \"50\", \"51\", \"52\", \"53\", \"54\", \"55\", \"56\", \"57\", \"58\", \"59\", \"60\", \"61\", \"62\", \"63\", \"64\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"4143fa1d-117d-4725-937a-46d5c426c3ad\", \"statistics\": {\"num_failures\": 32, \"num_timeouts\": 22, \"num_available\": 361, \"num_completes\": 14, \"num_qualified\": 276, \"num_in_progress\": 0, \"num_over_quotas\": 16, \"length_of_interview\": 1474, \"qualified_conversion\": 5, \"num_quality_terminations\": 91}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"65\", \"66\", \"67\", \"68\", \"69\", \"70\", \"71\", \"72\", \"73\", \"74\", \"75\", \"76\", \"77\", \"78\", \"79\", \"80\", \"81\", \"82\", \"83\", \"84\", \"85\", \"86\", \"87\", \"88\", \"89\", \"90\", \"91\", \"92\", \"93\", \"94\", \"95\", \"96\", \"97\", \"98\", \"99\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"baa517b2-23b5-4de8-8def-42277bc1135b\", \"statistics\": {\"num_failures\": 32, \"num_timeouts\": 16, \"num_available\": 356, \"num_completes\": 11, \"num_qualified\": 257, \"num_in_progress\": 0, \"num_over_quotas\": 38, \"length_of_interview\": 1474, \"qualified_conversion\": 4, \"num_quality_terminations\": 75}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"18\", \"19\", \"20\", \"21\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", \"29\", \"30\", \"31\", \"32\", \"33\", \"34\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"bc9779ff-3117-4c43-b3cd-58fe6991e72f\", \"statistics\": {\"num_failures\": 40, \"num_timeouts\": 18, \"num_available\": 249, \"num_completes\": 11, \"num_qualified\": 286, \"num_in_progress\": 0, \"num_over_quotas\": 23, \"length_of_interview\": 1474, \"qualified_conversion\": 4, \"num_quality_terminations\": 80}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"35\", \"36\", \"37\", \"38\", \"39\", \"40\", \"41\", \"42\", \"43\", \"44\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"cb44416c-afff-42eb-b7cd-280b1e2e205b\", \"statistics\": {\"num_failures\": 34, \"num_timeouts\": 21, \"num_available\": 168, \"num_completes\": 11, \"num_qualified\": 276, \"num_in_progress\": 0, \"num_over_quotas\": 23, \"length_of_interview\": 1474, \"qualified_conversion\": 4, \"num_quality_terminations\": 81}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"45\", \"46\", \"47\", \"48\", \"49\", \"50\", \"51\", \"52\", \"53\", \"54\", \"55\", \"56\", \"57\", \"58\", \"59\", \"60\", \"61\", \"62\", \"63\", \"64\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"bacf12c4-6775-47c0-8ac2-446a6c539f1e\", \"statistics\": {\"num_failures\": 21, \"num_timeouts\": 21, \"num_available\": 378, \"num_completes\": 11, \"num_qualified\": 259, \"num_in_progress\": 0, \"num_over_quotas\": 27, \"length_of_interview\": 1474, \"qualified_conversion\": 4, \"num_quality_terminations\": 78}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"65\", \"66\", \"67\", \"68\", \"69\", \"70\", \"71\", \"72\", \"73\", \"74\", \"75\", \"76\", \"77\", \"78\", \"79\", \"80\", \"81\", \"82\", \"83\", \"84\", \"85\", \"86\", \"87\", \"88\", \"89\", \"90\", \"91\", \"92\", \"93\", \"94\", \"95\", \"96\", \"97\", \"98\", \"99\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}]', 'active', '{\"num_entrants\": 3100, \"num_failures\": 373, \"num_timeouts\": 204, \"num_available\": 2361, \"num_completes\": 129, \"num_qualified\": 2179, \"incidence_rate\": 14, \"num_screenouts\": 1154, \"num_in_progress\": 0, \"num_over_quotas\": 294, \"system_conversion\": 4, \"earnings_per_click\": 6, \"length_of_interview\": 1474, \"qualified_conversion\": 6, \"num_quality_terminations\": 946}', 0, 'ad_hoc', 82304, 'general', '2023-04-16 14:55:10', '2023-04-16 14:55:10'); INSERT INTO `xx_morn_consult_bids`(`id`, `buyer_id`, `buyer_account_id`, `country_id`, `end_date`, `closed_at`, `exclusions`, `language_ids`, `name`, `published_at`, `quotas`, `state`, `statistics`, `supplier_exclusive`, `survey_type`, `timeout`, `topic_id`, `created`, `modified`) VALUES ('f20fee08-89e5-48e3-9255-8fbe0326882c', 'e622f37b-9e7f-4b7a-93ef-74ed432da746', 'd2728d37-6373-44c6-8b46-cde74ef3a371', 'gb', '2023-05-14 06:03:32', NULL, '[{\"group_id\": \"1efee7b6-65c0-5d52-b243-c6eba18ae6e2\", \"lockout_period\": 7}]', '[\"en\"]', 'Ad-Hoc Survey', '2023-04-14 06:03:32', '[{\"id\": \"a1047e7c-6fdc-4ff8-bef0-0a2b941c6e1c\", \"statistics\": {\"num_failures\": 43, \"num_timeouts\": 17, \"num_available\": 380, \"num_completes\": 11, \"num_qualified\": 280, \"num_in_progress\": 0, \"num_over_quotas\": 32, \"length_of_interview\": 2051, \"qualified_conversion\": 4, \"num_quality_terminations\": 88}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"18\", \"19\", \"20\", \"21\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", \"29\", \"30\", \"31\", \"32\", \"33\", \"34\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"528ee352-6561-4746-bd73-4f714ad6c4cf\", \"statistics\": {\"num_failures\": 40, \"num_timeouts\": 30, \"num_available\": 284, \"num_completes\": 11, \"num_qualified\": 294, \"num_in_progress\": 0, \"num_over_quotas\": 28, \"length_of_interview\": 2051, \"qualified_conversion\": 4, \"num_quality_terminations\": 80}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"35\", \"36\", \"37\", \"38\", \"39\", \"40\", \"41\", \"42\", \"43\", \"44\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"ef37cd75-229c-43bb-9669-ba29cdd3c3af\", \"statistics\": {\"num_failures\": 39, \"num_timeouts\": 20, \"num_available\": 201, \"num_completes\": 12, \"num_qualified\": 286, \"num_in_progress\": 0, \"num_over_quotas\": 39, \"length_of_interview\": 2051, \"qualified_conversion\": 4, \"num_quality_terminations\": 83}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"45\", \"46\", \"47\", \"48\", \"49\", \"50\", \"51\", \"52\", \"53\", \"54\", \"55\", \"56\", \"57\", \"58\", \"59\", \"60\", \"61\", \"62\", \"63\", \"64\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"f8f9f767-bcd2-42a6-91a8-869ce8f025c6\", \"statistics\": {\"num_failures\": 35, \"num_timeouts\": 12, \"num_available\": 291, \"num_completes\": 8, \"num_qualified\": 237, \"num_in_progress\": 0, \"num_over_quotas\": 29, \"length_of_interview\": 2051, \"qualified_conversion\": 3, \"num_quality_terminations\": 73}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"65\", \"66\", \"67\", \"68\", \"69\", \"70\", \"71\", \"72\", \"73\", \"74\", \"75\", \"76\", \"77\", \"78\", \"79\", \"80\", \"81\", \"82\", \"83\", \"84\", \"85\", \"86\", \"87\", \"88\", \"89\", \"90\", \"91\", \"92\", \"93\", \"94\", \"95\", \"96\", \"97\", \"98\", \"99\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"7a458270-6df9-4902-8085-f958d1a355a6\", \"statistics\": {\"num_failures\": 34, \"num_timeouts\": 21, \"num_available\": 108, \"num_completes\": 7, \"num_qualified\": 266, \"num_in_progress\": 0, \"num_over_quotas\": 34, \"length_of_interview\": 2051, \"qualified_conversion\": 3, \"num_quality_terminations\": 68}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"18\", \"19\", \"20\", \"21\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", \"29\", \"30\", \"31\", \"32\", \"33\", \"34\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"9de9cc33-9286-4ab5-a425-eb73a7715ce0\", \"statistics\": {\"num_failures\": 43, \"num_timeouts\": 10, \"num_available\": 302, \"num_completes\": 14, \"num_qualified\": 268, \"num_in_progress\": 0, \"num_over_quotas\": 24, \"length_of_interview\": 2051, \"qualified_conversion\": 5, \"num_quality_terminations\": 96}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"35\", \"36\", \"37\", \"38\", \"39\", \"40\", \"41\", \"42\", \"43\", \"44\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"36267dd7-6d8f-428c-9881-12cfa0d59b0c\", \"statistics\": {\"num_failures\": 36, \"num_timeouts\": 25, \"num_available\": 241, \"num_completes\": 6, \"num_qualified\": 299, \"num_in_progress\": 0, \"num_over_quotas\": 32, \"length_of_interview\": 2051, \"qualified_conversion\": 2, \"num_quality_terminations\": 96}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"45\", \"46\", \"47\", \"48\", \"49\", \"50\", \"51\", \"52\", \"53\", \"54\", \"55\", \"56\", \"57\", \"58\", \"59\", \"60\", \"61\", \"62\", \"63\", \"64\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"d4e4cec7-790e-4890-aba5-b2110d8a0ea8\", \"statistics\": {\"num_failures\": 33, \"num_timeouts\": 19, \"num_available\": 286, \"num_completes\": 7, \"num_qualified\": 275, \"num_in_progress\": 0, \"num_over_quotas\": 28, \"length_of_interview\": 2051, \"qualified_conversion\": 3, \"num_quality_terminations\": 79}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"65\", \"66\", \"67\", \"68\", \"69\", \"70\", \"71\", \"72\", \"73\", \"74\", \"75\", \"76\", \"77\", \"78\", \"79\", \"80\", \"81\", \"82\", \"83\", \"84\", \"85\", \"86\", \"87\", \"88\", \"89\", \"90\", \"91\", \"92\", \"93\", \"94\", \"95\", \"96\", \"97\", \"98\", \"99\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}]', 'active', '{\"num_entrants\": 3100, \"num_failures\": 426, \"num_timeouts\": 218, \"num_available\": 2093, \"num_completes\": 96, \"num_qualified\": 2205, \"incidence_rate\": 11, \"num_screenouts\": 1071, \"num_in_progress\": 0, \"num_over_quotas\": 327, \"system_conversion\": 3, \"earnings_per_click\": 5, \"length_of_interview\": 2051, \"qualified_conversion\": 4, \"num_quality_terminations\": 962}', 0, 'ad_hoc', 85786, 'general', '2023-04-16 14:55:05', '2023-04-16 14:55:05'); INSERT INTO `xx_morn_consult_bids`(`id`, `buyer_id`, `buyer_account_id`, `country_id`, `end_date`, `closed_at`, `exclusions`, `language_ids`, `name`, `published_at`, `quotas`, `state`, `statistics`, `supplier_exclusive`, `survey_type`, `timeout`, `topic_id`, `created`, `modified`) VALUES ('f26f0441-6dc1-4d78-9885-1355fee179f4', 'e622f37b-9e7f-4b7a-93ef-74ed432da746', 'd2728d37-6373-44c6-8b46-cde74ef3a371', 'ng', '2023-05-14 00:00:00', NULL, '[{\"group_id\": \"1b404f86-8676-5962-8bb8-b9a988300fb0\", \"lockout_period\": 7}]', '[\"en\"]', 'Ad-Hoc Survey', '2023-04-14 06:03:32', '[{\"id\": \"cad0addb-ff9e-4f0e-acf0-aa5c8995abae\", \"statistics\": {\"num_failures\": 26, \"num_timeouts\": 28, \"num_available\": 282, \"num_completes\": 7, \"num_qualified\": 246, \"num_in_progress\": 0, \"num_over_quotas\": 32, \"length_of_interview\": 1568, \"qualified_conversion\": 3, \"num_quality_terminations\": 60}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"18\", \"19\", \"20\", \"21\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", \"29\", \"30\", \"31\", \"32\", \"33\", \"34\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"21a2fe37-d52d-4fdc-b532-399bf069bcb3\", \"statistics\": {\"num_failures\": 39, \"num_timeouts\": 23, \"num_available\": 369, \"num_completes\": 12, \"num_qualified\": 291, \"num_in_progress\": 0, \"num_over_quotas\": 23, \"length_of_interview\": 1568, \"qualified_conversion\": 4, \"num_quality_terminations\": 82}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"35\", \"36\", \"37\", \"38\", \"39\", \"40\", \"41\", \"42\", \"43\", \"44\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"27a1a02a-20b0-46d5-9d5b-10738dffe71a\", \"statistics\": {\"num_failures\": 41, \"num_timeouts\": 20, \"num_available\": 153, \"num_completes\": 6, \"num_qualified\": 291, \"num_in_progress\": 0, \"num_over_quotas\": 31, \"length_of_interview\": 1568, \"qualified_conversion\": 2, \"num_quality_terminations\": 93}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"45\", \"46\", \"47\", \"48\", \"49\", \"50\", \"51\", \"52\", \"53\", \"54\", \"55\", \"56\", \"57\", \"58\", \"59\", \"60\", \"61\", \"62\", \"63\", \"64\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"3cf83bc2-7b1d-42fa-9db4-51c756002ce5\", \"statistics\": {\"num_failures\": 35, \"num_timeouts\": 17, \"num_available\": 349, \"num_completes\": 6, \"num_qualified\": 256, \"num_in_progress\": 0, \"num_over_quotas\": 24, \"length_of_interview\": 1568, \"qualified_conversion\": 2, \"num_quality_terminations\": 74}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"65\", \"66\", \"67\", \"68\", \"69\", \"70\", \"71\", \"72\", \"73\", \"74\", \"75\", \"76\", \"77\", \"78\", \"79\", \"80\", \"81\", \"82\", \"83\", \"84\", \"85\", \"86\", \"87\", \"88\", \"89\", \"90\", \"91\", \"92\", \"93\", \"94\", \"95\", \"96\", \"97\", \"98\", \"99\"]}, {\"id\": \"gender\", \"response_ids\": [\"2\"]}], \"cost_per_interview\": 400}, {\"id\": \"54e5c5e9-67a3-4266-b70b-bdd51e4c2b78\", \"statistics\": {\"num_failures\": 36, \"num_timeouts\": 20, \"num_available\": 312, \"num_completes\": 14, \"num_qualified\": 276, \"num_in_progress\": 0, \"num_over_quotas\": 26, \"length_of_interview\": 1568, \"qualified_conversion\": 5, \"num_quality_terminations\": 85}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"18\", \"19\", \"20\", \"21\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", \"29\", \"30\", \"31\", \"32\", \"33\", \"34\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"d2349bb0-4ed4-4e4d-a390-bbc651ab2870\", \"statistics\": {\"num_failures\": 41, \"num_timeouts\": 14, \"num_available\": 197, \"num_completes\": 2, \"num_qualified\": 266, \"num_in_progress\": 0, \"num_over_quotas\": 25, \"length_of_interview\": 1208, \"qualified_conversion\": 100, \"num_quality_terminations\": 72}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"35\", \"36\", \"37\", \"38\", \"39\", \"40\", \"41\", \"42\", \"43\", \"44\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"aef960fe-c9a2-4ef1-9ebf-9155a6e91a75\", \"statistics\": {\"num_failures\": 41, \"num_timeouts\": 24, \"num_available\": 97, \"num_completes\": 12, \"num_qualified\": 281, \"num_in_progress\": 0, \"num_over_quotas\": 26, \"length_of_interview\": 1568, \"qualified_conversion\": 4, \"num_quality_terminations\": 90}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"45\", \"46\", \"47\", \"48\", \"49\", \"50\", \"51\", \"52\", \"53\", \"54\", \"55\", \"56\", \"57\", \"58\", \"59\", \"60\", \"61\", \"62\", \"63\", \"64\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}, {\"id\": \"39738dbf-b496-4e07-8e55-8625767dccee\", \"statistics\": {\"num_failures\": 33, \"num_timeouts\": 15, \"num_available\": 165, \"num_completes\": 5, \"num_qualified\": 282, \"num_in_progress\": 0, \"num_over_quotas\": 28, \"length_of_interview\": 1568, \"qualified_conversion\": 2, \"num_quality_terminations\": 96}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"65\", \"66\", \"67\", \"68\", \"69\", \"70\", \"71\", \"72\", \"73\", \"74\", \"75\", \"76\", \"77\", \"78\", \"79\", \"80\", \"81\", \"82\", \"83\", \"84\", \"85\", \"86\", \"87\", \"88\", \"89\", \"90\", \"91\", \"92\", \"93\", \"94\", \"95\", \"96\", \"97\", \"98\", \"99\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 400}]', 'active', '{\"num_entrants\": 3100, \"num_failures\": 431, \"num_timeouts\": 229, \"num_available\": 1924, \"num_completes\": 98, \"num_qualified\": 2189, \"incidence_rate\": 11, \"num_screenouts\": 1104, \"num_in_progress\": 0, \"num_over_quotas\": 308, \"system_conversion\": 3, \"earnings_per_click\": 5, \"length_of_interview\": 1568, \"qualified_conversion\": 4, \"num_quality_terminations\": 930}', 0, 'ad_hoc', 81047, 'general', '2023-04-16 14:55:04', '2023-04-16 14:55:04'); INSERT INTO `xx_morn_consult_bids`(`id`, `buyer_id`, `buyer_account_id`, `country_id`, `end_date`, `closed_at`, `exclusions`, `language_ids`, `name`, `published_at`, `quotas`, `state`, `statistics`, `supplier_exclusive`, `survey_type`, `timeout`, `topic_id`, `created`, `modified`) VALUES ('f3a316d0-b0ba-4678-a2ad-8296150a63dd', '6e366110-1702-4667-bae0-cd773374eab8', '885ca555-a556-4a89-bf40-5119386e5103', 'us', '2023-05-14 17:39:25', NULL, NULL, '[\"en\"]', 'Ad-Hoc Survey', '2023-04-14 17:39:25', '[{\"id\": \"e930dc38-3f24-42a4-af8f-02a71739c81e\", \"statistics\": {\"num_failures\": 0, \"num_timeouts\": 0, \"num_available\": 100, \"num_completes\": 0, \"num_qualified\": 0, \"num_in_progress\": 0, \"num_over_quotas\": 0, \"length_of_interview\": 600, \"qualified_conversion\": 100, \"num_quality_terminations\": 0}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"18\", \"19\", \"20\", \"21\", \"22\", \"23\", \"24\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 120}]', 'active', '{\"num_entrants\": 0, \"num_failures\": 0, \"num_timeouts\": 0, \"num_available\": 100, \"num_completes\": 0, \"num_qualified\": 0, \"incidence_rate\": 10, \"num_screenouts\": 0, \"num_in_progress\": 0, \"num_over_quotas\": 0, \"system_conversion\": 100, \"earnings_per_click\": 0, \"length_of_interview\": 600, \"qualified_conversion\": 100, \"num_quality_terminations\": 0}', 0, 'ad_hoc', 21600, 'general', '2023-04-16 14:55:07', '2023-04-16 14:55:07'); INSERT INTO `xx_morn_consult_bids`(`id`, `buyer_id`, `buyer_account_id`, `country_id`, `end_date`, `closed_at`, `exclusions`, `language_ids`, `name`, `published_at`, `quotas`, `state`, `statistics`, `supplier_exclusive`, `survey_type`, `timeout`, `topic_id`, `created`, `modified`) VALUES ('f3e91c1c-363a-46da-8b81-fe2a6fecf04d', '6e366110-1702-4667-bae0-cd773374eab8', '885ca555-a556-4a89-bf40-5119386e5103', 'us', '2023-05-14 16:12:25', NULL, NULL, '[\"en\"]', 'Ad-Hoc Survey', '2023-04-14 16:12:25', '[{\"id\": \"40ffe923-d03c-4253-9a35-c06e871ac98f\", \"statistics\": {\"num_failures\": 0, \"num_timeouts\": 0, \"num_available\": 100, \"num_completes\": 0, \"num_qualified\": 0, \"num_in_progress\": 0, \"num_over_quotas\": 0, \"length_of_interview\": 600, \"qualified_conversion\": 100, \"num_quality_terminations\": 0}, \"qualifications\": [{\"id\": \"age\", \"response_ids\": [\"18\", \"19\", \"20\", \"21\", \"22\", \"23\", \"24\"]}, {\"id\": \"gender\", \"response_ids\": [\"1\"]}], \"cost_per_interview\": 120}]', 'active', '{\"num_entrants\": 0, \"num_failures\": 0, \"num_timeouts\": 0, \"num_available\": 100, \"num_completes\": 0, \"num_qualified\": 0, \"incidence_rate\": 10, \"num_screenouts\": 0, \"num_in_progress\": 0, \"num_over_quotas\": 0, \"system_conversion\": 100, \"earnings_per_click\": 0, \"length_of_interview\": 600, \"qualified_conversion\": 100, \"num_quality_terminations\": 0}', 0, 'ad_hoc', 21600, 'general', '2023-04-16 14:55:09', '2023-04-16 14:55:09'); -- ////// SELECT cost_per_interview > 100 SELECT m.id, JSON_EXTRACT(m.quotas, '$[*].id')as quota_id, JSON_EXTRACT(m.quotas, '$[*].statistics.num_failures')as mf -- m.quotas FROM xx_morn_consult_bids AS m WHERE JSON_EXTRACT(m.quotas, '$[*].statistics.num_failures') > 42