SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Create Table TABLE_A(some_id INT, entity_id INT, tableB_id INT, position INT);
✓
Insert Into TABLE_A Values(388,8,5783,0),
(389,8,776,1),
(390,8,5765,2),
(391,8,5743,3),
(392,8,6167,4),
(393,8,6168,5),
(394,8,6169,6),
(708,11,501,3);
✓
Create Table TABLE_B(some_id INT, key_1 VARCHAR(50), key2 VARCHAR(50), tableC_id INT, isSomeCheck INT, isOtherCheck INT);
✓
Insert Into TABLE_B Values(776,NULL,'pqrstuvw1234',311,1,0),
(5743,'sfrwt0','sofdsfsdr456',1829,1,0),
(5765,NULL,'abcdefgh4567',321,1,0),
(5783,NULL,'something341',1841,1,0),
(6167,'somer9',NULL,1956,0,0),
(6168,'richt6',NULL,1957,0,0),
(6169,'done60',NULL,1957,0,0);
✓
Create Table TABLE_C(some_id INT, key_1 VARCHAR(50), sortName VARCHAR(50));
✓
Insert Into TABLE_C Values(311,'tes456','WWW'),
(321,'don890','UNK'),
(1829,'som123','ILA'),
(1841,'ken980','ARI'),
(1956,'lam123','KOR'),
(1957,'kes648','ERO');
✓
SELECT  tbl_a.some_id 
FROM TABLE_B tbl_B JOIN TABLE_A tbl_a
ON tbl_a.tableB_id = tbl_b.some_id
JOIN   TABLE_C tbl_c
ON tbl_b.tableC_id = tbl_c.some_id 
WHERE tbl_a.entity_id = 8 AND
      (tbl_b.isSomeCheck = 1 OR tbl_b.isOtherCheck = 1) AND
      tbl_b.key_1 IS NOT NULL
ORDER BY tbl_a.position


some_id


391


SELECT  tbl_a.some_id 
FROM TABLE_B tbl_B JOIN TABLE_A tbl_a
ON tbl_a.tableB_id = tbl_b.some_id
JOIN   TABLE_C tbl_c
ON tbl_b.tableC_id = tbl_c.some_id 
WHERE tbl_a.entity_id = 8 AND
      (tbl_b.isSomeCheck = 1 OR tbl_b.isOtherCheck = 1) AND
      COALESCE(tbl_b.key_1, tbl_b.key2) IS NOT NULL
ORDER BY tbl_a.position


some_id


388

389

390

391