File indexing completed on 2024-04-21 06:00:35
0001 0002 CREATE OR REPLACE 0003 ALGORITHM = UNDEFINED 0004 DEFINER = CURRENT_USER 0005 SQL SECURITY DEFINER 0006 VIEW `view_reported_projects` AS 0007 SELECT `reports_project`.`project_id` AS `project_id`, 0008 COUNT(`reports_project`.`project_id`) AS `amount_reports`, 0009 MAX(`reports_project`.`created_at`) AS `latest_report` 0010 FROM `reports_project` 0011 WHERE (`reports_project`.`is_deleted` = 0) 0012 GROUP BY `reports_project`.`project_id` 0013 ; 0014 0015 CREATE OR REPLACE 0016 ALGORITHM = TEMPTABLE 0017 DEFINER = CURRENT_USER 0018 SQL SECURITY DEFINER 0019 VIEW `stat_projects_v` AS 0020 SELECT `project`.`project_id` AS `project_id`, 0021 `project`.`member_id` AS `member_id`, 0022 `project`.`content_type` AS `content_type`, 0023 `project`.`project_category_id` AS `project_category_id`, 0024 `project`.`hive_category_id` AS `hive_category_id`, 0025 `project`.`status` AS `status`, 0026 `project`.`uuid` AS `uuid`, 0027 `project`.`pid` AS `pid`, 0028 `project`.`type_id` AS `type_id`, 0029 `project`.`title` AS `title`, 0030 `project`.`description` AS `description`, 0031 `project`.`version` AS `version`, 0032 `project`.`image_big` AS `image_big`, 0033 `project`.`image_small` AS `image_small`, 0034 `project`.`start_date` AS `start_date`, 0035 `project`.`content_url` AS `content_url`, 0036 `project`.`created_at` AS `created_at`, 0037 `project`.`changed_at` AS `changed_at`, 0038 `project`.`deleted_at` AS `deleted_at`, 0039 `project`.`creator_id` AS `creator_id`, 0040 `project`.`facebook_code` AS `facebook_code`, 0041 `project`.`github_code` AS `github_code`, 0042 `project`.`twitter_code` AS `twitter_code`, 0043 `project`.`google_code` AS `google_code`, 0044 `project`.`link_1` AS `link_1`, 0045 `project`.`embed_code` AS `embed_code`, 0046 `project`.`ppload_collection_id` AS `ppload_collection_id`, 0047 `project`.`validated` AS `validated`, 0048 `project`.`validated_at` AS `validated_at`, 0049 `project`.`featured` AS `featured`, 0050 `project`.`approved` AS `approved`, 0051 `project`.`amount` AS `amount`, 0052 `project`.`amount_period` AS `amount_period`, 0053 `project`.`claimable` AS `claimable`, 0054 `project`.`claimed_by_member` AS `claimed_by_member`, 0055 `project`.`count_likes` AS `count_likes`, 0056 `project`.`count_dislikes` AS `count_dislikes`, 0057 `project`.`count_comments` AS `count_comments`, 0058 `project`.`count_downloads_hive` AS `count_downloads_hive`, 0059 `project`.`source_id` AS `source_id`, 0060 `project`.`source_pk` AS `source_pk`, 0061 `project`.`source_type` AS `source_type`, 0062 `project`.`validated` AS `project_validated`, 0063 `project`.`uuid` AS `project_uuid`, 0064 `project`.`status` AS `project_status`, 0065 `project`.`created_at` AS `project_created_at`, 0066 `member`.`type` AS `member_type`, 0067 `member`.`member_id` AS `project_member_id`, 0068 `project`.`changed_at` AS `project_changed_at`, 0069 (ROUND(((`project`.`count_likes` + 6) / ((`project`.`count_likes` + `project`.`count_dislikes`) + 12)), 2) * 0070 100) AS `laplace_score`, 0071 `member`.`username` AS `username`, 0072 `member`.`profile_image_url` AS `profile_image_url`, 0073 `member`.`city` AS `city`, 0074 `member`.`country` AS `country`, 0075 `member`.`created_at` AS `member_created_at`, 0076 `member`.`paypal_mail` AS `paypal_mail`, 0077 `project_category`.`title` AS `cat_title`, 0078 `project_category`.`xdg_type` AS `cat_xdg_type`, 0079 `project_category`.`name_legacy` AS `cat_name_legacy`, 0080 `stat_plings`.`amount_received` AS `amount_received`, 0081 `stat_plings`.`count_plings` AS `count_plings`, 0082 `stat_plings`.`count_plingers` AS `count_plingers`, 0083 `stat_plings`.`latest_pling` AS `latest_pling`, 0084 `view_reported_projects`.`amount_reports` AS `amount_reports` 0085 FROM `project` 0086 JOIN 0087 `member` ON ((`member`.`member_id` = `project`.`member_id`)) 0088 JOIN 0089 `project_category` ON ((`project`.`project_category_id` = `project_category`.`project_category_id`)) 0090 LEFT JOIN 0091 `stat_plings` ON ((`stat_plings`.`project_id` = `project`.`project_id`)) 0092 LEFT JOIN 0093 `view_reported_projects` ON ((`view_reported_projects`.`project_id` = `project`.`project_id`)) 0094 WHERE ((`member`.`is_deleted` = 0) 0095 AND (`member`.`is_active` = 1) 0096 AND (`project`.`type_id` = 1) 0097 AND (`project`.`status` = 100)) 0098 ;