Automator_DB::recipe_log_view_query()


Return Return

(string)


Source Source

File: src/core/class-automator-db.php

	public static function recipe_log_view_query() {
		global $wpdb;

		return apply_filters(
			'automator_recipe_log_view_query',
			"SELECT r.user_id,
							r.date_time AS recipe_date_time,
							r.completed AS recipe_completed,
							r.run_number,
							r.completed,
							r.automator_recipe_id,
							u.user_email,
							u.display_name,
							p.post_title AS recipe_title
					FROM {$wpdb->prefix}uap_recipe_log r
					LEFT JOIN {$wpdb->users} u
					ON u.ID = r.user_id
					JOIN {$wpdb->posts} p
					ON p.ID = r.automator_recipe_id"
		);
	}