0.0004 |
SELECT `countryCde`, `countryName`, `urlCountry`, `stateCode`, `stateName`, `urlState` FROM (`dimLocation`) WHERE `urlState` = 'florida' LIMIT 1
|
0.0118 |
SELECT DISTINCT `cityName`, `StationName`, `presentationName`, `urlName`, `countryCde`, `countryName`, `urlCountry`, `stateCode`, `stateName`, `urlState`, `lat`, `lng` FROM (`dimLocation`) JOIN `aggDaily` ON `dimLocation`.`locationId` = `aggDaily`.`locationId` WHERE `urlState` = 'florida' ORDER BY `cityname`
|
0.1506 |
SELECT `maxTemp`, `monthName`, `dayNo`, `dimDate`.`year`, `dimLocation`.`locationId`, `dimLocation`.`countryName`, `dimLocation`.`stateName`, `dimLocation`.`presentationName`, `dimLocation`.`urlCountry`, `dimLocation`.`urlState`, `dimLocation`.`urlName` FROM (`aggMonthly`) JOIN `dimLocation` ON `dimLocation`.`locationId` = `aggMonthly`.`locationId` JOIN `dimDate` ON `dimDate`.`dateId` = `aggMonthly`.`maxTempDate` WHERE `dimLocation`.`urlCountry` = 'united-states' AND `dimLocation`.`urlState` = 'florida' AND `dimDate`.`monthNo` = '2' ORDER BY `maxTemp` desc LIMIT 5
|
0.0005 |
SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '1599' LIMIT 1
|
0.0005 |
SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '1472' LIMIT 1
|
0.0005 |
SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '1466' LIMIT 1
|
0.0005 |
SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '1489' LIMIT 1
|
0.0005 |
SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '1457' LIMIT 1
|
0.1285 |
SELECT `minTemp`, `monthName`, `dayNo`, `dimDate`.`year`, `dimLocation`.`locationId`, `dimLocation`.`countryName`, `dimLocation`.`stateName`, `dimLocation`.`presentationName`, `dimLocation`.`urlCountry`, `dimLocation`.`urlState`, `dimLocation`.`urlName` FROM (`aggMonthly`) JOIN `dimLocation` ON `dimLocation`.`locationId` = `aggMonthly`.`locationId` JOIN `dimDate` ON `dimDate`.`dateId` = `aggMonthly`.`minTempDate` WHERE `dimLocation`.`urlCountry` = 'united-states' AND `dimLocation`.`urlState` = 'florida' AND `dimDate`.`monthNo` = '2' ORDER BY `minTemp` asc LIMIT 5
|
0.0004 |
SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '1656' LIMIT 1
|
0.0004 |
SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '1780' LIMIT 1
|
0.0004 |
SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '1656' LIMIT 1
|
0.0004 |
SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '5111' LIMIT 1
|
0.0004 |
SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '1802' LIMIT 1
|
0.1268 |
SELECT `maxRainfall`, `monthName`, `dayNo`, `dimDate`.`year`, `dimLocation`.`locationId`, `dimLocation`.`countryName`, `dimLocation`.`stateName`, `dimLocation`.`presentationName`, `dimLocation`.`urlCountry`, `dimLocation`.`urlState`, `dimLocation`.`urlName` FROM (`aggMonthly`) JOIN `dimLocation` ON `dimLocation`.`locationId` = `aggMonthly`.`locationId` JOIN `dimDate` ON `dimDate`.`dateId` = `aggMonthly`.`maxRainfallDate` WHERE `dimLocation`.`urlCountry` = 'united-states' AND `dimLocation`.`urlState` = 'florida' AND `dimDate`.`monthNo` = '2' ORDER BY `maxRainfall` desc LIMIT 5
|
0.0004 |
SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '1802' LIMIT 1
|
0.0003 |
SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '1599' LIMIT 1
|
0.0003 |
SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '1606' LIMIT 1
|
0.0003 |
SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '1606' LIMIT 1
|
0.0003 |
SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay FROM (`dimLocation`) JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId` JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId` WHERE `locationId` = '1442' LIMIT 1
|