
--
-- Table structure for table `wp_yoast_seo_meta`
--

CREATE TABLE `wp_yoast_seo_meta` (
  `object_id` bigint(20) unsigned NOT NULL,
  `internal_link_count` int(10) unsigned DEFAULT NULL,
  `incoming_link_count` int(10) unsigned DEFAULT NULL,
  UNIQUE KEY `object_id` (`object_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_yoast_seo_meta`
--

INSERT INTO `wp_yoast_seo_meta` VALUES (1735,0,0),(1639,0,0),(1701,0,0),(1460,0,0),(1493,0,0),(1509,0,0),(1511,0,0),(1513,0,0),(1515,0,0),(1520,0,0),(1517,0,0),(1519,0,0),(1565,0,0),(1566,0,0),(1567,0,0),(1568,0,0),(1570,0,0),(1572,0,0),(1574,0,0),(1569,0,0),(1623,0,0),(1626,0,0),(1634,0,0),(1637,0,0),(1624,0,0),(1617,0,0),(1731,0,0),(1729,0,0),(1734,0,0),(1704,0,0),(452,0,1),(1749,0,1),(1751,0,1),(1753,0,1),(1755,0,1),(1758,0,1),(1760,0,1),(1763,0,1),(1765,0,1),(1767,0,1),(1769,0,1),(1771,0,1),(1773,0,0),(1778,0,1),(1782,0,0),(1787,0,15),(1535,0,0),(1802,0,11),(1823,0,0),(1826,0,0),(1827,0,0),(1828,0,0),(1829,0,0),(1836,0,0),(1529,0,2),(1575,48,0),(197,0,1),(420,0,1),(430,0,1),(626,0,2),(638,0,1),(642,0,1),(1041,0,1),(1275,0,1),(1277,0,1),(1287,0,1),(1290,0,15),(1294,0,1),(1297,0,1),(1299,0,1),(1303,0,1),(1305,0,1),(1307,0,1),(1311,0,1),(1594,0,1),(1599,0,1),(1628,56,1),(1646,0,1),(1648,0,1),(1663,0,1),(1665,0,1),(1667,0,1),(1669,0,1),(1671,0,1),(1673,0,1),(1675,0,1),(1678,0,1),(1680,0,1),(1682,0,1),(1861,0,0),(1864,0,0),(1866,0,0),(1870,0,0),(1872,0,0),(1927,2,0),(1929,0,0),(1930,0,0),(1956,0,0),(1960,0,0),(2022,0,0),(2026,0,0),(2028,0,0),(2054,0,0),(2078,0,0),(2081,0,0),(2083,0,0),(2085,0,0),(2087,0,0),(2089,0,0),(2091,0,0),(2094,0,0),(2096,0,0),(2098,0,0),(2100,0,0),(2107,0,0),(2106,0,0),(2105,0,0),(2104,0,0),(2118,0,0),(2120,0,0),(2123,0,0),(2125,0,0),(2127,0,0),(2129,0,0),(2132,0,0),(2134,0,0),(2136,0,0),(2138,0,0),(2140,0,0),(2143,0,0),(2146,0,0),(2148,0,0),(2152,0,0),(2154,0,0),(2156,0,0),(2158,0,0),(2163,0,0),(2167,0,0),(2169,0,0),(2171,0,0),(2173,0,0),(2175,0,0),(2177,0,0),(2179,0,0),(2198,0,0),(2200,0,0),(2203,0,0),(2206,0,0),(2216,0,0),(2218,0,0),(2221,0,0),(2224,0,0),(2227,0,0),(2228,0,0),(2229,0,0),(2231,0,0),(2232,0,0),(2233,0,0),(2234,0,0),(2236,0,0),(2195,0,0),(2196,0,0),(2235,0,0),(2210,0,0),(2246,0,0),(2251,0,0),(2252,0,0),(2254,0,0),(2255,0,0),(2264,0,0),(2266,0,0),(2301,0,0),(2211,0,0),(2245,0,0),(2250,0,0),(2253,0,0),(2213,0,0),(2350,1,0),(2353,0,0),(2214,0,0),(2349,0,0),(2348,0,0),(2240,0,0),(2241,0,0),(2260,0,0),(2261,0,0),(2262,0,0),(2263,0,0),(2270,0,0),(2271,0,0),(2277,0,0),(2272,0,0),(2273,0,0),(2274,0,0),(2275,0,0),(2280,0,0),(2281,0,0),(2289,0,0),(2290,0,0),(2291,0,0),(2292,0,0),(2256,0,0),(2257,0,0),(2258,0,0),(2259,0,0),(2287,0,0),(2282,0,0),(2283,0,0),(2284,0,0),(2285,0,0),(2276,0,0),(2286,0,0),(2295,0,0),(2296,0,0),(2297,0,0),(2298,0,0),(2299,0,0),(2302,0,0),(2307,0,0),(2308,0,0),(2309,0,0),(2310,0,0),(2312,0,0),(2311,0,0),(2304,0,0),(2305,0,0),(2306,0,0),(2314,0,0),(2315,0,0),(2316,0,0),(2317,0,0),(2313,0,0),(2318,0,0),(2319,0,0),(2320,0,0),(2323,0,0),(2324,0,0),(2300,0,0),(2303,0,0),(2330,0,0),(2325,0,0),(2326,0,0),(2327,0,0),(2328,0,0),(2329,0,0),(2333,0,0),(2334,0,0),(2335,0,0),(2336,0,0),(2337,0,0),(2338,0,0),(2374,0,0),(2339,0,0),(2340,0,0),(2341,0,0),(2244,0,0),(2343,0,0),(2344,0,0),(2345,0,0),(2346,0,0),(2355,0,0),(2347,0,0),(2356,0,0),(2402,0,0),(2357,0,0),(2342,0,0),(2359,0,0),(2360,0,0),(2361,0,0),(2362,0,0),(2363,0,0),(2364,0,0),(2365,0,0),(2366,0,0),(2358,0,0),(2368,0,0),(2369,0,0),(2370,0,0),(2371,0,0),(2372,0,0),(2373,0,0),(2375,0,0),(2367,0,0),(2377,0,0),(2378,0,0),(2380,0,0),(2381,0,0),(2382,0,0),(2294,0,0),(2385,0,0),(2386,0,0),(2387,0,0),(2388,0,0),(2389,0,0),(2390,0,0),(2332,0,0),(2393,0,0),(2394,0,0),(2395,0,0),(2396,0,0),(2397,0,0),(2398,0,0),(2376,0,0),(2400,0,0),(2392,0,0),(2384,0,0),(2404,0,0),(2405,0,0),(2406,0,0),(2407,0,0),(2403,0,0),(2408,0,0),(2409,0,0),(2410,0,0),(2401,0,0),(2411,0,0),(2412,0,0),(2413,0,0),(2414,0,0),(2415,0,0),(2416,0,0),(2417,0,0),(2418,0,0),(2399,0,0),(2420,0,0),(2421,0,0),(2422,0,0),(2423,0,0),(2424,0,0),(2425,0,0),(2426,0,0),(2419,0,0),(2428,0,0),(2429,0,0),(2430,0,0),(2431,0,0),(2432,0,0),(2433,0,0),(2434,0,0),(2427,0,0),(2436,0,0),(2437,0,0),(2438,0,0),(2439,0,0),(2440,0,0),(2441,0,0),(2469,0,0),(2442,0,0),(2435,0,0),(2444,0,0),(2445,0,0),(2446,0,0),(2447,0,0),(2448,0,0),(2449,0,0),(2450,0,0),(2443,0,0),(2452,0,0),(2453,0,0),(2454,0,0),(2455,0,0),(2456,0,0),(2457,0,0),(2458,0,0),(2451,0,0),(2460,0,0),(2461,0,0),(2462,0,0),(2463,0,0),(2464,0,0),(2465,0,0),(2466,0,0),(2459,0,0),(2468,0,0),(2498,0,0),(2470,0,0),(2471,0,0),(2472,0,0),(2473,0,0),(2474,0,0),(2475,0,0),(2467,0,0),(2477,0,0),(2478,0,0),(2479,0,0),(2513,0,0),(2480,0,0),(2481,0,0),(2482,0,0),(2483,0,0),(2476,0,0),(2485,0,0),(2486,0,0),(2531,0,0),(2487,0,0),(2488,0,0),(2489,0,0),(2490,0,0),(2491,0,0),(2484,0,0),(2494,0,0),(2495,0,0),(2496,0,0),(2497,0,0),(2530,0,0),(2499,0,0),(2500,0,0),(2501,0,0),(2502,0,0),(2503,0,0),(2504,0,0),(2505,0,0),(2553,0,0),(2554,0,0),(2555,0,0),(2492,0,0),(2601,0,0),(2603,0,0),(2605,0,0),(2507,0,0),(2508,0,0),(2509,0,0),(2546,0,0),(2511,0,0),(2512,0,0),(2514,0,0),(2515,0,0),(2506,0,0),(2517,0,0),(2518,0,0),(2519,0,0),(2520,0,0),(2521,0,0),(2522,0,0),(2523,0,0),(2516,0,0),(2525,0,0),(2526,0,0),(2527,0,0),(2528,0,0),(2529,0,0),(2536,0,0),(2537,0,0),(2524,0,0),(2539,0,0),(2540,0,0),(2541,0,0),(2542,0,0),(2543,0,0),(2544,0,0),(2545,0,0),(2538,0,0),(2547,0,0),(2548,0,0),(2550,0,0),(2607,0,0),(2608,0,0),(2609,0,0),(2549,0,0),(2606,0,0),(2602,0,0),(2611,0,0),(2627,0,0),(2628,0,0),(2629,0,0),(2630,0,0),(2510,0,0),(2632,0,0),(2633,0,0),(2634,0,0),(2635,0,0),(2636,0,0),(2637,0,0),(2638,0,0),(2640,0,0),(2642,0,0),(2644,0,0),(2610,0,0),(2646,0,0),(2648,0,0),(2651,0,0),(2652,0,0),(2653,0,0),(2654,0,0),(2688,0,0),(2649,0,0),(2690,0,0),(1615,0,0),(1614,0,0),(1661,0,0),(2708,0,0),(2689,0,0),(2645,0,0),(2695,0,0),(2710,0,0),(2711,0,0),(2721,0,0),(2722,0,0),(2694,0,0),(2696,0,0),(2697,0,0),(2698,0,0),(2700,0,0),(2702,0,0),(2704,0,0),(2706,0,0),(2719,0,0),(2726,0,0),(2729,0,0),(2730,0,0),(2731,0,0),(2732,0,0),(2724,0,0),(2725,0,0),(2723,0,0),(2733,0,0),(2735,0,0),(2738,0,0),(2737,0,0),(2741,0,0),(2742,0,0),(2747,3,0),(2752,0,0),(2753,3,0),(2764,0,0),(2768,0,0),(2769,0,0),(2770,0,0),(2775,3,0),(2736,0,0),(2789,0,0),(2784,0,0),(2793,0,0),(2794,0,0),(2792,0,0),(2604,0,0),(2745,0,0),(1911,0,0),(2746,0,0),(2804,0,0),(2806,0,0),(2836,0,0),(2816,0,0),(2817,0,0),(2818,0,0),(2819,0,0),(2820,0,0),(2822,0,0),(2823,0,0),(2826,0,0),(2827,0,0),(2837,0,0),(2839,0,0),(2840,0,0),(2842,0,0),(2841,0,0),(2843,0,0),(2845,0,0),(2844,0,0),(2852,0,0),(2855,0,0),(2854,0,0),(2856,0,0),(2858,0,0),(2859,0,0),(2860,0,0);

--
-- Table structure for table `wp_yydev_tagmanager`
--

CREATE TABLE `wp_yydev_tagmanager` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `page_id` int(11) DEFAULT NULL,
  `tag_type` text DEFAULT NULL,
  `tag_code` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_yydev_tagmanager`
--

INSERT INTO `wp_yydev_tagmanager` VALUES (1,0,'head','<script type=\\\"application/ld+json\\\">{\\\"@context\\\":\\\"https://schema.org\\\",\\\"@type\\\":\\\"LocalBusiness\\\",\\\"name\\\":\\\"Capital District Digital, LLC\\\",\\\"address\\\":{\\\"@type\\\":\\\"PostalAddress\\\",\\\"addressCountry\\\":\\\"US\\\",\\\"addressLocality\\\":\\\"Latham\\\",\\\"addressRegion\\\":\\\"NY\\\",\\\"postalCode\\\":\\\"12110\\\",\\\"streetAddress\\\":\\\"1202 Troy Schenectady Road, Building 3 Suite 103\\\"},\\\"telephone\\\":\\\"8339327361\\\",\\\"description\\\":\\\"Capital District Digital specializes in WordPress website design, search engine optimization, search engine marketing, Social Media Marketing, e-commerce, voice search readiness, local directory listings, GPS aggregators, website hosting & email services. We help all size businesses establish a local and national digital footprint. \\\",\\\"email\\\":\\\"info@capitaldistrictdigital.com\\\",\\\"url\\\":\\\"https://capitaldistrictdigital.com\\\",\\\"geo\\\":{\\\"@type\\\":\\\"GeoCoordinates\\\",\\\"latitude\\\":42.7706275,\\\"longitude\\\":-73.8235729},\\\"openingHours\\\":[\\\"Mo 09:00-17:00\\\",\\\"Tu 09:00-17:00\\\",\\\"We 09:00-17:00\\\",\\\"Th 09:00-17:00\\\",\\\"Fr 09:00-17:00\\\"],\\\"logo\\\":\\\"https://s3.amazonaws.com/p.assets.lssdev.com/client_images/d/b/5/3/e/3582583/thumb_76682595_1317676375101479_1547100688067067904_o.png\\\",\\\"photo\\\":\\\"https://s3.amazonaws.com/p.assets.lssdev.com/client_images/d/b/5/3/e/3582583/thumb_Capital%20District%20Digital%201202-Troy%20Schenectady%20Rd.%20Latham,%20NY%2012110%20Building-3.jpg\\\",\\\"image\\\":[\\\"https://s3.amazonaws.com/p.assets.lssdev.com/client_images/d/b/5/3/e/3582583/thumb_Capital%20District%20Digital%201202-Troy%20Schenectady%20Rd.%20Latham,%20NY%2012110%20Building-3.jpg\\\",\\\"https://s3.amazonaws.com/p.assets.lssdev.com/client_images/d/b/5/3/e/3582583/thumb_72650237_10220144847962321_6658616355949903872_n.jpg\\\",\\\"https://s3.amazonaws.com/p.assets.lssdev.com/client_images/d/b/5/3/e/3582583/thumb_73026958_10220144847642313_3121500862577377280_n.jpg\\\",\\\"https://s3.amazonaws.com/p.assets.lssdev.com/client_images/d/b/5/3/e/3582583/thumb_72924260_10220087969980407_683390860854820864_n.jpg\\\"]}</script><script type=\\\"application/ld+json\\\">{\\\"@context\\\":\\\"https://schema.org\\\",\\\"@type\\\":\\\"FAQPage\\\",\\\"mainEntity\\\":[{\\\"@type\\\":\\\"Question\\\",\\\"name\\\":\\\"what products do you offer?\\\",\\\"acceptedAnswer\\\":{\\\"@type\\\":\\\"Answer\\\",\\\"text\\\":\\\"Website Design \\\"}},{\\\"@type\\\":\\\"Question\\\",\\\"name\\\":\\\"What are your hours?\\\",\\\"acceptedAnswer\\\":{\\\"@type\\\":\\\"Answer\\\",\\\"text\\\":\\\"Mo 09:00-17:00; Tu 09:00-17:00; We 09:00-17:00; Th 09:00-17:00; Fr 09:00-17:00\\\"}},{\\\"@type\\\":\\\"Question\\\",\\\"name\\\":\\\"what is your business address?\\\",\\\"acceptedAnswer\\\":{\\\"@type\\\":\\\"Answer\\\",\\\"text\\\":\\\"1202 Troy Schenectady Road Building 3 Suite 103, Latham, NY 12110, US\\\"}},{\\\"@type\\\":\\\"Question\\\",\\\"name\\\":\\\"what payments do you accept?\\\",\\\"acceptedAnswer\\\":{\\\"@type\\\":\\\"Answer\\\",\\\"text\\\":\\\"Credit Card, Check, Cash\\\"}},{\\\"@type\\\":\\\"Question\\\",\\\"name\\\":\\\"What is the phone number to a business?\\\",\\\"acceptedAnswer\\\":{\\\"@type\\\":\\\"Answer\\\",\\\"text\\\":\\\"8339327361\\\"}},{\\\"@type\\\":\\\"Question\\\",\\\"name\\\":\\\"What do you know about my business?\\\",\\\"acceptedAnswer\\\":{\\\"@type\\\":\\\"Answer\\\",\\\"text\\\":\\\"Capital District Digital specializes in WordPress website design, search engine optimization, search engine marketing, Social Media Marketing, e-commerce, voice search readiness, local directory listings, GPS aggregators, website hosting & email services. We help all size businesses establish a local and national digital footprint. \\\"}},{\\\"@type\\\":\\\"Question\\\",\\\"acceptedAnswer\\\":{\\\"@type\\\":\\\"Answer\\\",\\\"text\\\":\\\"Monday\\\"},\\\"name\\\":\\\"What is your busiest day of the week?\\\"}]}</script>###^^^<!-- Global site tag (gtag.js) - Google Analytics -->\r\n<script async src=\\\"https://www.googletagmanager.com/gtag/js?id=G-2Q8KC6CJN5\\\"></script>\r\n<script>\r\n  window.dataLayer = window.dataLayer || [];\r\n  function gtag(){dataLayer.push(arguments);}\r\n  gtag(\\\'js\\\', new Date());\r\n\r\n  gtag(\\\'config\\\', \\\'G-2Q8KC6CJN5\\\');\r\n</script>'),(2,0,'body',''),(3,0,'footer','');

--
-- Final view structure for view `wp_uap_action_logs_view`
--

/*!50001 DROP VIEW IF EXISTS `wp_uap_action_logs_view`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`digital_wrdp1`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `wp_uap_action_logs_view` AS select `a`.`automator_action_id` AS `automator_action_id`,`a`.`date_time` AS `action_date`,`a`.`completed` AS `action_completed`,`a`.`error_message` AS `error_message`,`a`.`automator_recipe_id` AS `automator_recipe_id`,`a`.`ID` AS `action_log_id`,`a`.`automator_recipe_log_id` AS `recipe_log_id`,`r`.`date_time` AS `recipe_date_time`,`r`.`completed` AS `recipe_completed`,`r`.`run_number` AS `recipe_run_number`,`pa`.`post_title` AS `action_title`,`am`.`meta_value` AS `action_sentence`,`p`.`post_title` AS `recipe_title`,`u`.`ID` AS `user_id`,`u`.`user_email` AS `user_email`,`u`.`display_name` AS `display_name` from (((((`wp_uap_action_log` `a` left join `wp_uap_recipe_log` `r` on(`a`.`automator_recipe_log_id` = `r`.`ID`)) left join `wp_posts` `p` on(`p`.`ID` = `a`.`automator_recipe_id`)) join `wp_posts` `pa` on(`pa`.`ID` = `a`.`automator_action_id`)) left join `wp_uap_action_log_meta` `am` on(`a`.`automator_action_id` = `am`.`automator_action_id` and `am`.`automator_action_log_id` = `a`.`ID` and `am`.`user_id` = `a`.`user_id` and `am`.`meta_key` = 'sentence_human_readable_html')) left join `wp_users` `u` on(`a`.`user_id` = `u`.`ID`)) group by `a`.`ID` */;

--
-- Final view structure for view `wp_uap_api_logs_view`
--

/*!50001 DROP VIEW IF EXISTS `wp_uap_api_logs_view`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`digital_wrdp1`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `wp_uap_api_logs_view` AS select `api`.`ID` AS `ID`,`api`.`date_time` AS `date`,`u`.`user_email` AS `user_email`,`u`.`display_name` AS `display_name`,`u`.`ID` AS `user_id`,`pr`.`post_title` AS `recipe_title`,`rl`.`automator_recipe_id` AS `automator_recipe_id`,`al`.`automator_recipe_log_id` AS `recipe_log_id`,`rl`.`date_time` AS `recipe_date_time`,`rl`.`completed` AS `recipe_completed`,`rl`.`run_number` AS `recipe_run_number`,`pa`.`post_title` AS `title`,`asen`.`meta_value` AS `sentence`,`al`.`automator_action_id` AS `item_id`,`al`.`completed` AS `completed`,`al`.`error_message` AS `error_message`,`api`.`type` AS `type`,`api`.`item_log_id` AS `item_log_id`,`api`.`status` AS `status`,`api`.`params` AS `params`,`api`.`price` AS `price`,`api`.`balance` AS `balance`,`api`.`notes` AS `notes`,`api`.`time_spent` AS `time_spent`,`api`.`endpoint` AS `endpoint` from ((((((`wp_uap_api_log` `api` left join `wp_uap_action_log` `al` on(`al`.`ID` = `api`.`item_log_id`)) left join `wp_uap_recipe_log` `rl` on(`al`.`automator_recipe_log_id` = `rl`.`ID`)) left join `wp_posts` `pr` on(`pr`.`ID` = `al`.`automator_recipe_id`)) join `wp_posts` `pa` on(`pa`.`ID` = `al`.`automator_action_id`)) left join `wp_uap_action_log_meta` `asen` on(`asen`.`automator_action_log_id` = `al`.`ID` and `asen`.`meta_key` = 'sentence_human_readable_html')) left join `wp_users` `u` on(`al`.`user_id` = `u`.`ID`)) where `api`.`type` = 'action' union select `api`.`ID` AS `ID`,`api`.`date_time` AS `date`,`u`.`user_email` AS `user_email`,`u`.`display_name` AS `display_name`,`u`.`ID` AS `user_id`,`pr`.`post_title` AS `recipe_title`,`rl`.`automator_recipe_id` AS `automator_recipe_id`,`tl`.`automator_recipe_log_id` AS `recipe_log_id`,`rl`.`date_time` AS `recipe_date_time`,`rl`.`completed` AS `recipe_completed`,`rl`.`run_number` AS `recipe_run_number`,`pt`.`post_title` AS `title`,`tsen`.`meta_value` AS `sentence`,`tl`.`automator_trigger_id` AS `item_id`,`tl`.`completed` AS `completed`,'' AS `error_message`,`api`.`type` AS `type`,`api`.`item_log_id` AS `item_log_id`,`api`.`status` AS `status`,`api`.`params` AS `params`,`api`.`price` AS `price`,`api`.`balance` AS `balance`,`api`.`notes` AS `notes`,`api`.`time_spent` AS `time_spent`,`api`.`endpoint` AS `endpoint` from ((((((`wp_uap_api_log` `api` left join `wp_uap_trigger_log` `tl` on(`tl`.`ID` = `api`.`item_log_id`)) left join `wp_uap_recipe_log` `rl` on(`tl`.`automator_recipe_log_id` = `rl`.`ID`)) left join `wp_posts` `pr` on(`pr`.`ID` = `tl`.`automator_recipe_id`)) join `wp_posts` `pt` on(`pt`.`ID` = `tl`.`automator_trigger_id`)) left join `wp_uap_trigger_log_meta` `tsen` on(`tsen`.`automator_trigger_log_id` = `tl`.`ID` and `tsen`.`meta_key` = 'sentence_human_readable')) left join `wp_users` `u` on(`tl`.`user_id` = `u`.`ID`)) where `api`.`type` = 'trigger' */;

--
-- Final view structure for view `wp_uap_recipe_logs_view`
--

/*!50001 DROP VIEW IF EXISTS `wp_uap_recipe_logs_view`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`digital_wrdp1`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `wp_uap_recipe_logs_view` AS select `r`.`ID` AS `recipe_log_id`,`r`.`user_id` AS `user_id`,`r`.`date_time` AS `recipe_date_time`,`r`.`completed` AS `recipe_completed`,`r`.`run_number` AS `run_number`,`r`.`completed` AS `completed`,`r`.`automator_recipe_id` AS `automator_recipe_id`,`u`.`user_email` AS `user_email`,`u`.`display_name` AS `display_name`,`p`.`post_title` AS `recipe_title` from ((`wp_uap_recipe_log` `r` left join `wp_users` `u` on(`u`.`ID` = `r`.`user_id`)) join `wp_posts` `p` on(`p`.`ID` = `r`.`automator_recipe_id`)) */;

--
-- Final view structure for view `wp_uap_trigger_logs_view`
--

/*!50001 DROP VIEW IF EXISTS `wp_uap_trigger_logs_view`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`digital_wrdp1`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `wp_uap_trigger_logs_view` AS select `u`.`ID` AS `user_id`,`u`.`user_email` AS `user_email`,`u`.`display_name` AS `display_name`,`t`.`automator_trigger_id` AS `automator_trigger_id`,`t`.`date_time` AS `trigger_date`,`t`.`completed` AS `trigger_completed`,`t`.`automator_recipe_id` AS `automator_recipe_id`,`t`.`ID` AS `ID`,`pt`.`post_title` AS `trigger_title`,`tm`.`meta_value` AS `trigger_sentence`,`tm`.`run_number` AS `trigger_run_number`,`tm`.`run_time` AS `trigger_run_time`,`pm`.`meta_value` AS `trigger_total_times`,`p`.`post_title` AS `recipe_title`,`t`.`automator_recipe_log_id` AS `recipe_log_id`,`r`.`date_time` AS `recipe_date_time`,`r`.`completed` AS `recipe_completed`,`r`.`run_number` AS `recipe_run_number` from ((((((`wp_uap_trigger_log` `t` left join `wp_users` `u` on(`u`.`ID` = `t`.`user_id`)) left join `wp_posts` `p` on(`p`.`ID` = `t`.`automator_recipe_id`)) left join `wp_posts` `pt` on(`pt`.`ID` = `t`.`automator_trigger_id`)) left join `wp_uap_trigger_log_meta` `tm` on(`tm`.`automator_trigger_log_id` = `t`.`ID` and `tm`.`meta_key` = 'sentence_human_readable')) left join `wp_uap_recipe_log` `r` on(`t`.`automator_recipe_log_id` = `r`.`ID`)) left join `wp_postmeta` `pm` on(`pm`.`post_id` = `t`.`automator_trigger_id` and `pm`.`meta_key` = 'NUMTIMES')) */;


