SQL Hiba: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and albums.active='1' group by albums.id order by upl' at line 6
select sql_calc_found_rows albums.*, substring_index(albums.description, ' ', 12) short_text, manufacturers.title man_title, manufacturers.permalink man_permalink from albums left outer join manufacturers on manufacturers.id = albums.manufacturer_id left outer join cat_to_albums on cat_to_albums.id = albums.id left outer join categories on categories.id = cat_to_albums.cat_id where and albums.active='1' group by albums.id order by upload_date desc limit 0,7