All pastes #806048 Raw Edit

Miscellany

public text v1 · immutable
·published 2007-12-04 22:43 UTC
rendered paste body
SELECT
`jos_eventlist_dates`.`id`,
`jos_eventlist_dates`.`locationcity`,
`jos_eventlist_dates`.`locationprovince` as province,
`countrys`.`Name` as country,
`jos_eventlist_dates`.`dates`,
`jos_eventlist_dates`.`titel`,
`jos_eventlist_categories`.`catname` as sport
FROM
`jos_eventlist_dates`
Left Join `countrys` ON `jos_eventlist_dates`.`locationcountry` = `countrys`.`TLD`
Left Join `jos_eventlist_categories` ON `jos_eventlist_dates`.`catsid` = `jos_eventlist_categories`.`id`
WHERE published = 1  && unix_timestamp(enddates) >= '1196319600'
ORDER By Rand()
LIMIT 5

returns the same as this

SELECT
`jos_eventlist_dates`.`id`,
`jos_eventlist_dates`.`locationcity`,
`jos_eventlist_dates`.`locationprovince` as province,
`countrys`.`Name` as country,
`jos_eventlist_dates`.`dates`,
`jos_eventlist_dates`.`titel`,
`jos_eventlist_categories`.`catname` as sport
FROM
`jos_eventlist_dates`
Inner Join `countrys` ON `jos_eventlist_dates`.`locationcountry` = `countrys`.`TLD`
Inner Join `jos_eventlist_categories` ON `jos_eventlist_dates`.`catsid` = `jos_eventlist_categories`.`id`
WHERE published = 1  && unix_timestamp(enddates) >= '1196319600'
ORDER By Rand()
LIMIT 5