Fatal error: Uncaught Exception: Error: Could not create a join buffer. Please check and adjust the value of the variables 'JOIN_BUFFER_SIZE (8388608)' and 'JOIN_BUFFER_SPACE_LIMIT (2097152)'<br />Error No: 1037<br />
SELECT
p.post_id,
p.image,
p.date_created as date,
p.views,
pd.name,
pd.description,
a.username,
a.firstname,
a.lastname,
a.email,
(
SELECT count(*)
FROM `ps_journal3_blog_comments` bc
WHERE
bc.status = 1
AND bc.post_id = p.post_id
AND bc.parent_id = 0
) as comments
FROM
`ps_journal3_blog_post` p
LEFT JOIN `ps_journal3_blog_post_to_category` p2c ON p.post_id = p2c.post_id
LEFT JOIN
`ps_journal3_blog_post_description in /home/petshop8/public_html/system/storage/modification/system/library/db/mysqli.php on line 43