Quote Originally Posted by a_berezin View Post
No. I take ALL manufacturers from the tables:
Code:
    $manufacturers = $db->Execute("SELECT m.manufacturers_id, GREATEST(m.date_added, IFNULL(m.last_modified, '0001-01-01 00:00:00')) AS last_date, mi.languages_id
                              FROM " . TABLE_MANUFACTURERS . " m
                                LEFT JOIN " . TABLE_MANUFACTURERS_INFO . " mi ON (mi.manufacturers_id = m.manufacturers_id)
                              WHERE mi.languages_id IN (" . $zen_SiteMapXML->getLanguagesIDs() . ") " .
                              (SITEMAPXML_MANUFACTURERS_ORDERBY != '' ? "ORDER BY " . SITEMAPXML_MANUFACTURERS_ORDERBY : ''));
By the way, what value have SITEMAPXML_MANUFACTURERS_ORDERBY ?

Have you check /cache/myDEBUG-*.log files?


I have dynamic IP's and use DynDns.com service for it.
The SITEMAPXML_MANUFACTURERS_ORDERBY is last_date DESC

No error in the log at the moment.