public function set_query() {

		global $wpdb;

		$this->set_order_data_query(
			array(
				'query_function' => 'get_results',
				'select'         => array(
					'orders.post_date AS date',
				),
				'joins'          => array(
					"JOIN {$wpdb->postmeta} AS coupons ON orders.ID = coupons.post_id",
				),
				'statuses'       => array(
					'llms-active',
					'llms-completed',
				),
				'wheres'         => array(
					" AND coupons.meta_key = '_llms_coupon_used'",
					" AND coupons.meta_value = 'yes'",
				),
			)
		);

	}