All pastes #896713 Raw Edit

Someone

public text v1 · immutable
·published 2008-02-08 22:12 UTC
rendered paste body
11	UPDATE `wineries` AS `Winery` SET `Winery`.`id` = 2, `Winery`.`name` = 'Alexander Valley Vineyards', `Winery`.`address1` = '8644 Highway 128', `Winery`.`city` = 'Healdsburg', `Winery`.`zip` = 95448, `Winery`.`phone` = '707-433-7209', `Winery`.`email` = '', `Winery`.`website` = 'www.avvwine.com', `Winery`.`description` = '', `Winery`.`operating` = 'Open to the public' WHERE `Winery`.`id` IN (2) 		0		0
12	SELECT `WineriesVarietal`.`id` FROM `wineries_varietals` AS `WineriesVarietal` WHERE `winery_id` = 2 		2	2	0
13	DELETE `WineriesVarietal` FROM `wineries_varietals` AS `WineriesVarietal` WHERE `WineriesVarietal`.`id` IN (626, 627) 		2		2
14	INSERT INTO `wineries_varietals` (`winery_id`,`varietal_id`) VALUES (2,15), (2,16)		2		0
15	SELECT `AmenitiesWinery`.`id` FROM `amenities_wineries` AS `AmenitiesWinery` WHERE `winery_id` = 2 		7	7	0
16	DELETE `AmenitiesWinery` FROM `amenities_wineries` AS `AmenitiesWinery` WHERE `AmenitiesWinery`.`id` IN (974, 975, 976, 977, 978, 979, 980) 		7		1
17	INSERT INTO `amenities_wineries` (`winery_id`,`amenity_id`) VALUES (2,15), (2,16), (2,1), (2,13), (2,14), (2,16), (2,17)