Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT tx_dmftravelagent_domain_model_travel.*
- FROM tx_dmftravelagent_domain_model_travel
- LEFT JOIN tx_dmftravelagent_domain_model_city ON tx_dmftravelagent_domain_model_travel.city=tx_dmftravelagent_domain_model_city.uid
- LEFT JOIN tx_dmftravelagent_domain_model_traveltype ON tx_dmftravelagent_domain_model_travel.travel_type=tx_dmftravelagent_domain_model_traveltype.uid
- WHERE (tx_dmftravelagent_domain_model_city.country = '7')
- AND tx_dmftravelagent_domain_model_travel.deleted=0
- AND tx_dmftravelagent_domain_model_travel.t3ver_state<=0
- AND tx_dmftravelagent_domain_model_travel.pid<>-1
- AND tx_dmftravelagent_domain_model_travel.hidden=0
- AND tx_dmftravelagent_domain_model_travel.starttime<=1362011580
- AND (tx_dmftravelagent_domain_model_travel.endtime=0
- OR tx_dmftravelagent_domain_model_travel.endtime>1362011580)
- AND (tx_dmftravelagent_domain_model_travel.sys_language_uid IN (4,-1)
- OR (tx_dmftravelagent_domain_model_travel.sys_language_uid=0
- AND tx_dmftravelagent_domain_model_travel.uid NOT IN
- (SELECT tx_dmftravelagent_domain_model_travel.l10n_parent
- FROM tx_dmftravelagent_domain_model_travel
- WHERE tx_dmftravelagent_domain_model_travel.l10n_parent>0
- AND tx_dmftravelagent_domain_model_travel.sys_language_uid>0
- AND tx_dmftravelagent_domain_model_travel.deleted=0)))
- AND tx_dmftravelagent_domain_model_city.deleted=0
- AND tx_dmftravelagent_domain_model_city.t3ver_state<=0
- AND tx_dmftravelagent_domain_model_city.pid<>-1
- AND tx_dmftravelagent_domain_model_city.hidden=0
- AND tx_dmftravelagent_domain_model_city.starttime<=1362011580
- AND (tx_dmftravelagent_domain_model_city.endtime=0
- OR tx_dmftravelagent_domain_model_city.endtime>1362011580)
- AND (tx_dmftravelagent_domain_model_city.sys_language_uid IN (4,-1)
- OR (tx_dmftravelagent_domain_model_city.sys_language_uid=0
- AND tx_dmftravelagent_domain_model_city.uid NOT IN
- (SELECT tx_dmftravelagent_domain_model_city.l10n_parent
- FROM tx_dmftravelagent_domain_model_city
- WHERE tx_dmftravelagent_domain_model_city.l10n_parent>0
- AND tx_dmftravelagent_domain_model_city.sys_language_uid>0
- AND tx_dmftravelagent_domain_model_city.deleted=0)))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement