CREATE TABLE Table1 (
  ID  integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  Field1  text NOT NULL,
  Field2  text NOT NULL
);

CREATE INDEX Table1_Index1
  ON Table1
  (Field1, Field2);

CREATE TABLE Table2 (
  ID1  integer NOT NULL,
  ID2  integer NOT NULL,
  Field3  boolean NOT NULL,
  Field4  boolean NOT NULL,
  PRIMARY KEY (ID1, ID2)
);

SELECT Field1, Field2 FROM Table1 WHERE ID IN 
(SELECT ID1 FROM Table2 WHERE Field3 = 'True' AND ID1 IN 
(SELECT ID FROM Table1 WHERE 
Field2 = substr('Строка_из_символов_не_более_десяти', 1 ,length(Field2))))
ORDER BY RANDOM() LIMIT  1 

SELECT Field1, Field2 from Table1, Table2 
WHERE ID = ID1 AND Field3 = 'True' 
AND Field2 = substr('Строка_из_символов_не_более_десяти', 1 ,length(Field2))
Group By ID ORDER BY RANDOM() LIMIT  1 

SELECT DISTINCT Field1, Field2 from Table2, Table1 
WHERE ID = ID1 AND Field3 = 'True' 
AND Field2 = substr('Строка_из_символов_не_более_десяти', 1 ,length(Field2))
ORDER BY RANDOM() LIMIT  1