SELECT tx_test_domain_model_testmaster.*
FROM tx_test_domain_model_testmaster
WHERE tx_test_domain_model_testmaster.nontranslatedproperty = 'test' AND
      (tx_test_domain_model_testmaster.sys_language_uid IN (1, -1) OR
       (tx_test_domain_model_testmaster.sys_language_uid = 0 AND
        tx_test_domain_model_testmaster.uid NOT IN (SELECT tx_test_domain_model_testmaster.l10n_parent
                                                    FROM tx_test_domain_model_testmaster
                                                    WHERE tx_test_domain_model_testmaster.l10n_parent > 0 AND
                                                          tx_test_domain_model_testmaster.sys_language_uid = 1 AND
                                                          tx_test_domain_model_testmaster.deleted = 0))) AND
      tx_test_domain_model_testmaster.pid IN (2) AND tx_test_domain_model_testmaster.deleted = 0 AND
      tx_test_domain_model_testmaster.t3ver_state <= 0 AND tx_test_domain_model_testmaster.pid <> -1 AND
      tx_test_domain_model_testmaster.hidden = 0 AND tx_test_domain_model_testmaster.starttime <= 1461146040 AND
      (tx_test_domain_model_testmaster.endtime = 0 OR tx_test_domain_model_testmaster.endtime > 1461146040)