Advertisement
Guest User

Complete output of query

a guest
Feb 27th, 2013
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.39 KB | None | 0 0
  1. SELECT DISTINCT tx_dmftravelagent_domain_model_travel.*
  2. FROM tx_dmftravelagent_domain_model_travel
  3. LEFT JOIN tx_dmftravelagent_domain_model_city ON tx_dmftravelagent_domain_model_travel.city=tx_dmftravelagent_domain_model_city.uid
  4. LEFT JOIN tx_dmftravelagent_domain_model_traveltype ON tx_dmftravelagent_domain_model_travel.travel_type=tx_dmftravelagent_domain_model_traveltype.uid
  5. WHERE (tx_dmftravelagent_domain_model_city.country = '7')
  6.     AND tx_dmftravelagent_domain_model_travel.deleted=0
  7.     AND tx_dmftravelagent_domain_model_travel.t3ver_state<=0
  8.     AND tx_dmftravelagent_domain_model_travel.pid<>-1
  9.     AND tx_dmftravelagent_domain_model_travel.hidden=0
  10.     AND tx_dmftravelagent_domain_model_travel.starttime<=1362011580
  11.     AND (tx_dmftravelagent_domain_model_travel.endtime=0
  12.          OR tx_dmftravelagent_domain_model_travel.endtime>1362011580)
  13.     AND (tx_dmftravelagent_domain_model_travel.sys_language_uid IN (4,-1)
  14.          OR (tx_dmftravelagent_domain_model_travel.sys_language_uid=0
  15.              AND tx_dmftravelagent_domain_model_travel.uid NOT IN
  16.                  (SELECT tx_dmftravelagent_domain_model_travel.l10n_parent
  17.                   FROM tx_dmftravelagent_domain_model_travel
  18.                   WHERE tx_dmftravelagent_domain_model_travel.l10n_parent>0
  19.                       AND tx_dmftravelagent_domain_model_travel.sys_language_uid>0
  20.                       AND tx_dmftravelagent_domain_model_travel.deleted=0)))
  21.     AND tx_dmftravelagent_domain_model_city.deleted=0
  22.     AND tx_dmftravelagent_domain_model_city.t3ver_state<=0
  23.     AND tx_dmftravelagent_domain_model_city.pid<>-1
  24.     AND tx_dmftravelagent_domain_model_city.hidden=0
  25.     AND tx_dmftravelagent_domain_model_city.starttime<=1362011580
  26.     AND (tx_dmftravelagent_domain_model_city.endtime=0
  27.          OR tx_dmftravelagent_domain_model_city.endtime>1362011580)
  28.     AND (tx_dmftravelagent_domain_model_city.sys_language_uid IN (4,-1)
  29.          OR (tx_dmftravelagent_domain_model_city.sys_language_uid=0
  30.              AND tx_dmftravelagent_domain_model_city.uid NOT IN
  31.                  (SELECT tx_dmftravelagent_domain_model_city.l10n_parent
  32.                   FROM tx_dmftravelagent_domain_model_city
  33.                   WHERE tx_dmftravelagent_domain_model_city.l10n_parent>0
  34.                       AND tx_dmftravelagent_domain_model_city.sys_language_uid>0
  35.                       AND tx_dmftravelagent_domain_model_city.deleted=0)))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement