drop view if exists view_index_thumbs; create view view_index_thumbs as select *, (select CONCAT(img_id,".",img_ext) from img where img_base=real_base and img_obj=id and img_type=341 order by img_ord asc limit 1) as img_id from view_all_objects where (select count(img_id) from img where img_base=real_base and img_obj=id and img_type=341) > 0 order by rand() limit 12;