Number of articles

  • Warning: Use of undefined constant TABLE_HEADING_ARTICLES - assumed 'TABLE_HEADING_ARTICLES' (this will throw an Error in a future version of PHP) in /home/farmgard/public_html/templates/default/includes/components/article_listing.php on line 47
    TABLE_HEADING_ARTICLESAuthor
    Warning: Use of undefined constant TABLE_HEADING_A_IMAGE - assumed 'TABLE_HEADING_A_IMAGE' (this will throw an Error in a future version of PHP) in /home/farmgard/public_html/templates/default/includes/components/article_listing.php on line 57

    Warning: Use of undefined constant TABLE_HEADING_A_LATEST_ADDED - assumed 'TABLE_HEADING_A_LATEST_ADDED' (this will throw an Error in a future version of PHP) in /home/farmgard/public_html/templates/default/includes/components/article_listing.php on line 63
    TABLE_HEADING_A_LATEST_ADDED
    Warning: Use of undefined constant TABLE_HEADING_A_VIEWED - assumed 'TABLE_HEADING_A_VIEWED' (this will throw an Error in a future version of PHP) in /home/farmgard/public_html/templates/default/includes/components/article_listing.php on line 54
    TABLE_HEADING_A_VIEWED
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM articles a INNER JOIN articles_description ad ON a.articles_id = a...' at line 3

SELECT a.*, ad.*, au.*, FROM articles a INNER JOIN articles_description ad ON a.articles_id = ad.articles_id INNER JOIN authors au ON a.authors_id = au.authors_id WHERE a.articles_status = 1 AND ad.language_id = 2 AND au.authors_id = 1 ORDER BY ad.articles_name LIMIT 0, 20

[TEP STOP]