Surf Dog's Sports Grill at 5932 Warner Avenue, Huntington Beach, California.

We present you the complete information about the company Surf Dog's Sports Grill — Establishment, food and bar at 5932 Warner Avenue, Huntington Beach, California: contacts, photos, working hours, social networks and other information.

Contacts

Update

Reviews

Unfortunately, now, we have no reviews ...

Write a review

Photos

The nearest companies

Surf Dog's Sports Grill on the map

Opening hours

Sunday 09:30 AM — 11:00 PM
Monday 11:30 AM — 11:30 PM
Tuesday 11:30 AM — 11:30 PM

Weather in Huntington Beach, California

May, 09 2024 03:00 AM 19
May, 09 2024 06:00 AM 18
May, 09 2024 09:00 AM 16
May, 09 2024 12:00 PM 16
May, 09 2024 03:00 PM 16
May, 09 2024 06:00 PM 19
May, 09 2024 09:00 PM 19
May, 10 2024 12:00 AM 18
May, 10 2024 03:00 AM 17
May, 10 2024 06:00 AM 17
May, 10 2024 09:00 AM 16
May, 10 2024 12:00 PM 16
May, 10 2024 03:00 PM 17
May, 10 2024 06:00 PM 19
May, 10 2024 09:00 PM 20
May, 11 2024 12:00 AM 19
May, 11 2024 03:00 AM 17
May, 11 2024 06:00 AM 17
May, 11 2024 09:00 AM 16
May, 11 2024 12:00 PM 16
May, 11 2024 03:00 PM 17
May, 11 2024 06:00 PM 20
May, 11 2024 09:00 PM 20

-------------------- DUMP DATA --------------------
0.25443506240844727
---------------------------------------------------
7SELECT * FROM `item` WHERE url = 'surf-dogs-sports-grill' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('37') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('13329') LIMIT 1
8SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('434913')
0SELECT * FROM `category` WHERE id IN ('189','219','240') LIMIT 3
10SELECT * FROM `locality` WHERE url = 'huntington-beach-ca' LIMIT 1
0SELECT * FROM `region` WHERE id = 37 LIMIT 1
0SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 434913 AND `date` < '2024-05-09 16:52:48' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('434913')
8SELECT * FROM `item` WHERE id IN ('202964','305507','203327','435587','196215','192542') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('37') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('13329') LIMIT 1
0SELECT * FROM `photos` WHERE `item_id` IN ('192542','196215','202964','203327','305507','435587')
12SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('192542','196215','202964','203327','305507','435587')
0SELECT * FROM `category` WHERE id IN ('189','191','217','211','238','243','207','218','219','264') LIMIT 10
0SELECT * FROM counts where updated="2024-05-09" and table_name like 'news'
3SELECT * FROM `item` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `item`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 12
4SELECT * FROM `item` WHERE `id` IN ('8982','8983','8984','8985','8986','8987','8988','8989','8990','8991','8992','8993')
0SELECT * FROM `region` WHERE id IN ('37') LIMIT 1
2SELECT * FROM `locality` WHERE id IN ('14180','12778','13708','13862','13815') LIMIT 5
0SELECT * FROM `photos` WHERE `item_id` IN ('8982','8983','8984','8985','8986','8987','8988','8989','8990','8991','8992','8993')
8SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('8982','8983','8984','8985','8986','8987','8988','8989','8990','8991','8992','8993')
0SELECT * FROM `category` WHERE id IN ('189','208','212','219','230','216','222','259','255','193','229','213','266','191','194') LIMIT 15
10SELECT * FROM `locality` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `locality`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 6
0SELECT * FROM `region` WHERE id IN ('37') LIMIT 1
2SELECT * FROM `category_item` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `category_item`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 3
0SELECT * FROM `locality` WHERE id IN ('12989') LIMIT 1
0SELECT * FROM `category` WHERE id IN ('189') LIMIT 1
10SELECT * FROM ip_stat WHERE ip="3.134.78.106"
1INSERT INTO ip_stat(ip,count) VALUES("3.134.78.106",1)