SELECT ctlg.*,img.filename,img.alt,chr.id as chr_id  
				FROM `admin_shop`.`evo2_catalog` as ctlg
								
				 LEFT JOIN `admin_shop`.`evo2_catalog_imgs` as img ON num=1 and img.tov_id=ctlg.id LEFT JOIN `admin_shop`.`evo2_catalog_chars` as chr ON chr.tov_id=ctlg.id WHERE pid = 36 and nalichie>0 and pub=1 and price>100 ORDER BY RAND() LIMIT 4