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<br />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