SELECT tx_test_domain_model_testmaster.*
FROM tx_test_domain_model_testmaster
WHERE ((tx_test_domain_model_testmaster.sys_language_uid IN ('0', '-1') OR
        (tx_test_domain_model_testmaster.sys_language_uid = '1' AND tx_test_domain_model_testmaster.l10n_parent = '0'))
       AND tx_test_domain_model_testmaster.nontranslatedproperty = 'test') 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 <= 1461146220 AND
      (tx_test_domain_model_testmaster.endtime = 0 OR tx_test_domain_model_testmaster.endtime > 1461146220)