Find all posts via SQL beginning with A of type B

Try this..

SELECT * 
FROM $wpdb->posts p 
INNER JOIN $wpdb->term_relationships tr 
  ON p.ID = tr.object_id
INNER JOIN $wpdb->term_taxonomy tt 
  ON tr.term_taxonomy_id=tt.term_taxonomy_id 
inner join  $wpdb->terms t 
  on t.term_id=tt.term_id and t.slug='igralni'
WHERE 
  p.post_title LIKE 'А%'        
  AND p.post_type="filmi-i-serialii" 
  AND p.post_status="publish"