Finding location...
(default) 2 queries took 11 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Zipcode`.`name`, `Zipcode`.`stateid`, `states`.`name`, `Zipcode`.`timezone`, `Zipcode`.`daylight_saving` FROM `elotca_tvtvca`.`zipcodes` AS `Zipcode` JOIN `elotca_tvtvca`.`states` ON (`Zipcode`.`stateid` = `states`.`id`) WHERE `Zipcode`.`name` LIKE 'maplehurst' AND `stateid` = 'nb' LIMIT 1111
2SELECT DISTINCT `lineups`.`luid`, `lineups`.`name` FROM `elotca_tvtvca`.`zipcodelineups` AS `Zipcodelineup` JOIN `elotca_tvtvca`.`lineups` ON (`Zipcodelineup`.`luid` = `lineups`.`luid`) JOIN `elotca_tvtvca`.`zipcodes` ON (`zipcodes`.`zipcode` = `Zipcodelineup`.`zipcode`) WHERE `zipcodes`.`name` LIKE 'maplehurst' AND `zipcodes`.`stateid` = 'nb' ORDER BY `lineups`.`name` ASC6610