SELECT M.*, R.name 
							FROM next_shop_chars_prod_ref as M 
							LEFT JOIN next_shop_chars as R ON R.id = M.char_id
							WHERE `prod_id`= AND M.value2 != '' AND R.name != ''
							ORDER BY R.pos 
							LIMIT 100