/**
* Get the \mysqli_result requested by $this->workingQ instated by either $this->get() | $this->prep().
*
*
* @param string $limit The limit to apply to the $this->workingQ.
*
* @return \mysqli_result
*/
public function data($limit = '')
{
$sel = substr(ltrim($this->workingQ), 0, 6);
if ($sel == 'SELECT') {
return \DB::query($this->workingQ);
}
//if
return \DB::query('
SELECT
p.*,
DATE_FORMAT(p.post_date,"' . \WP::settings('date_format') . '") AS format_date,
t.name,
t.slug,
c.name AS category,
c.slug AS category_slug
FROM (
SELECT
p.ID AS post_id,
p.post_date,
p.post_content,
p.post_excerpt,
p.post_title,
p.post_name,
u.display_name,
u.user_nicename
FROM wp_posts AS p
INNER JOIN wp_users AS u ON u.ID=p.post_author
WHERE p.post_status="publish" AND p.post_type="post"
' . $this->workingQ . $limit . '
) AS p
LEFT JOIN wp_term_relationships AS wptr ON wptr.object_id=p.post_id
LEFT JOIN wp_term_taxonomy AS wptt ON wptt.term_taxonomy_id=wptr.term_taxonomy_id
LEFT JOIN wp_terms AS t ON t.term_id=wptt.term_id
LEFT JOIN wp_term_taxonomy AS wptt_category ON wptt_category.term_taxonomy_id=wptr.term_taxonomy_id AND wptt_category.taxonomy="category"
LEFT JOIN wp_terms AS c ON c.term_id=wptt_category.term_id
ORDER BY p.post_date DESC
');
}
