The boarding area is just beyond the Donà Bridge. The most beautiful hilltop villages in Tuscany. As your first day in Venice winds down, you can end it with a beautiful walk across one of Venice’s oldest bridges. Top Ten Things to do in (ta && ta.queueForLoad ? Where to Stay in Venice for a Local Atmosphere, Bristol - Venice - EasyJet - 16th to 18th Feb. Hi - what weather can I expect in Venice mid October? Answer 1 of 16: Hello, Looking for suggestions to plan our 1 and half day itinerary in Venice, this Feb. We plan to be there on 14th and leave early morning on 16th. more. From its beautiful canals filled with iconic gondolas to the impressive Doge’s Palace to the ease of getting delightfully lost in the maze of narrow streets and tiny canals, there is absolutely nowhere like Venice.. These are the top sights and things to do on your one day in Verona. (ta && ta.queueForLoad ? due to being locked in to flights, my italian trip at end of may, i have only 1 and a half days to give to venice. We will be arriving on a Friday at 4 pm and leaving Tuesday at 9 Am. We are only there 1.5 days, too. Have a great time. Cross the Rialto Bridge, and stroll through the fish market then cross the Rialto again and go into the new shopping mall at at the fondaco Dei Tedeschi offers a newly revealed rooftop view of the city. If you’re looking for a 1-day itinerary to Venice, this is the guide for you! You can often find better deals there, but unless you are on an incredibly low budget, your trip to Venice will be greatly enhanced by staying within walking distance (even if it’s a long one) of Piazza San Marco. We will be there for one night and the next full day and at night we are taking a train to Salzburg. Top Ten Things to do in (ta && ta.queueForLoad ? Reserve Now & Pay Later. ONE DAY IN VERONA ITINERARY. Want to make the most of our trip to Venice. ta.queueForLoad : function(f, g){document.addEventListener('DOMContentLoaded', f);})(function(){ta.trackEventOnPage('postLinkInline', 'impression', 'postLinks-67091374', '');}, 'log_autolink_impression');Venice for one and a half days and wondered what I can see in this time. From Venice to Castelfranco, it is only an hour-long drive, and the directions are quite simple. Even with just one day in Pisa, you’ll be left amazed by its incredible beauty and history. 30th December 2019 at 2:13 pm. Day One. Once you’ve headed out of the city on the SR11, you need to stay on the SR245 all the way to the medieval town. If you only have one day in Verona, make this the top of your list. more. For the final day of our 3 days in Venice itinerary, it’s … This "greatest hits" itinerary focuses on the Altstadt, the Old Town, in the heart of Munich. As soon as we hopped off the train at Stazione di Venezia Santa Lucia, we stepped out into the warm Venetian air. Duration: approx. Which are the must sees is dead easy to find out from any guidebook or the internet. Answer 1 of 11: Hi All, We have a cramped schedule for our trip to Italy from 5th-9th Aug. We will be arriving in Venice on 5th morning through the Treviso Airport. I am looking for recommended sites among the many in Venice when we will only be in the city for two and a half days. Jump to bottom. Europe - Venice in a day and a half - Two couples will be spending 2 nights in Venice next June. It's so romantic, you have a great view and all the buildings/restraunts are lit, quite magical. Also thinking of attending mass at the Basilica, what is the dress code? This would be my strategy for sightseeing. Spending 2 days in Venice is an entirely wonderful–and entirely unique–experience. Let me explain. While that can happen, Venice is also overrun with day tourists, scammers, and some of the world’s best pickpockets. If it's raining check out some of the museums. ta.queueForLoad : function(f, g){document.addEventListener('DOMContentLoaded', f);})(function(){ta.trackEventOnPage('postLinkInline', 'impression', 'postLinks-67152173', '');}, 'log_autolink_impression');Venice are shown here www.tours-venice-italy.com, This is the version of our website addressed to speakers of English in the United States. This is the version of our website addressed to speakers of English in the United States. Reply. I feel that Venice is overrated after having spent three days there, but I do think I would’ve felt more charmed if I’d only devote one day to the city. But technically, we will only be having one and half day for the tour. Also thinking of attending mass at the Basilica, what is the dress code? In this post I will take you to explore all of the must see points of interest if you only have one day in Venice. Related: What are the most popular tours in Venice? We will be staying near Calle Priuli Cavelletti. Enjoy magnificent views of Venice as you cruise out across the lagoon, visit Murano Island to discover its ancient tradition of glass-blowing, and admire Burano’s brightly colored waterfront on a walking tour. Answer 1 of 7: We will be headed to Slovenia for our vacation-outdoors lovers here, and will be flying into Venice. The must sees are very crowded at this time of the year and it takes a lot of time to visit them properly. Does this look doable? Rapid Covid testing at Marco Polo airport - how is it? Answer 1 of 8: My husband and I are arriving in Venice from Santorini by air. I don't think you want to spend a lot of time inside churches etc. Depart from a pier close to St. Mark’s Square for a convenient crossing to Murano. We will be staying near Calle Priuli Cavelletti. Thank you! The vaporetto trip to Burano takes the best part of an hour each way. Any suggestions how to efficiently make use of our time going around venice and visiting burn island? I"m generally more like a cruise director on vacation, you should see our itenarary in Rome! We are arriving in Venice the afternoon of Wednesday April 18 by train and are leaving for Florence midday Friday April 20. Many Thanks. ). Climb aboard a comfortable motorboat for a half-day trip around the Venetian islands of Murano and Burano, and discover a more local and authentic side to Venice. - please give me some advice. (Don’t miss: If you like canal cities, don’t miss our guide to 2 days in Amsterdam) → We have one night, half day in Venice and will see all your recommended highlights. Lunch at Dal Moro’s. The best way to make the most of your second day in Venice is by heading out to explore other islands and districts of Venice. Venice was the hardest of all our destinations to decide on how long to stay for. Members who are knowledgeable about this destination and volunteer their time to answer travelers' questions. Follow this guide and make the most of your trip even if you’re short on time. So practically we have one whole day in venice. When spending your one day in Venice, try to do two things: Don’t get lost. Get lost. Is one day in Pisa enough? Whilst it might not be possible to do all the Venice activities listed in this … Most specifically if, after arriving at Santa Lucia Station, I’d headed directly to the Rialto Bridge over the Grand Canal, or into the hectic Piazza San Marco, which is the city’s most famous public square. where we tried to cover all of the highlights and best things to do in Venice in one day. Let me explain. Read More. Answer 1 of 6: I'd love to advise from you experienced travelers to Venice. If you are a resident of another country or region, please select the appropriate version of Tripadvisor for your country or region in the drop-down menu. With only one day in Venice, we don’t recommend staying in Mestre (the mainland) or Giudecca (a separate island that requires a ferry to visit the major highlights of Venice). Related: What are the most popular tours in Venice? Would like to see the island of Burano or would this take up too much time? Where to Stay in Venice for a Local Atmosphere, Bristol - Venice - EasyJet - 16th to 18th Feb. Hi - what weather can I expect in Venice mid October? Laurence Norah says. ta.queueForLoad : function(f, g){document.addEventListener('DOMContentLoaded', f);})(function(){ta.trackEventOnPage('postLinkInline', 'impression', 'postLinks-67093784', '');}, 'log_autolink_impression');Doge's Palace and the Basilica. Just wander around the city, you will get lost, which is great. Get DK (ta && ta.queueForLoad ? Murano and Burano pales in comparison with Venice. ta.queueForLoad : function(f, g){document.addEventListener('DOMContentLoaded', f);})(function(){ta.trackEventOnPage('postLinkInline', 'impression', 'postLinks-90166402', '');}, 'log_autolink_impression');Venice: I am with others on such a short visit, leave out the Islands. We start at around 9:30 AM from Treviso airport-P.Roma-Venice via ATVO bus and Vaporetto. Skip the Line: Venice in One Day Including Boat Tour. Now you're all set! The bells atop the tower ring at the top of the hour, startling the beejeebers out of you. Want to make the most of our trip to Venice. With such little time I would not bother with Burano ,pretty as it is , this would take up half a day, and there is more than enough to see in Venice. I honestly think that with only one full day in the city, you should perhaps not travel out to the islands. After crossing it, you can stop by the nearby Rialto Market which sells fresh fruits, vegetables, and fish. To get such a wish satisfied, even less than a day is needed. Everyone will tell you something different, but I think we nailed it. : ). 14:00 Visit the Frari church. Answer 1 of 16: Hello, Looking for suggestions to plan our 1 and half day itinerary in Venice, this Feb. We plan to be there on 14th and leave early morning on 16th. That provided an up-close perspective on Venetians lives, and I loved riding with the charming schoolkids. We spent three and a half days in Venice, really enjoyed it and didn’t want to leave. So take my advice, spend at least one night (not on the mainland, either) and plan on two full days in the city. 1 day in Pisa is more than enough to climb the Leaning Tower and discover the sights on the Square of Miracles. Hi Andrea! Venice Tourism Venice Hotels Bed and Breakfast Venice Venice Holiday Rentals I'd love some advise from you experienced Venice fans! The ACTV public transport passes cost €20 for 24 hours or €30 for 48 hours. Start your day early, around 8 or 9 AM, which should hive you plenty of time to see all of the major attractions in Verona in a day. What is a KML file and how can I use it? A few things I especially enjoyed during our short stay: - Taking the vaporetto to San Giorgio Maggiore, visiting the church, and gasping at the spectacular 360 degree views from the top of the bell tower. Reply. ta.queueForLoad : function(f, g){document.addEventListener('DOMContentLoaded', f);})(function(){ta.trackEventOnPage('postLinkInline', 'impression', 'postLinks-67099813', '');}, 'log_autolink_impression');Venice, the start of our vacation. Here’s how we spent our two days in Venice… Two Days in Venice. But technically, we will only be having one and half day for the tour. ). Also thinking of attending mass at the Basilica, what is the dress code? You start this one day in Venice walk at the Piazza San Marco, the most famous place in Venice. We are arriving in Venice the afternoon of Wednesday April 18 by train and are leaving for Florence midday Friday April 20. Sunset from Accademia Bridge ta.queueForLoad : function(f, g){document.addEventListener('DOMContentLoaded', f);})(function(){ta.trackEventOnPage('postLinkInline', 'impression', 'postLinks-90166173', '');}, 'log_autolink_impression');San Trovaso. We will be staying near Calle Priuli Cavelletti. >> Navigate the Islands of Burano, Murano, and Torcello on a half-day boat tour! 3,316 Reviews | Venezia, Italy. I'm planning on just seeing (ta && ta.queueForLoad ? This is the first fresh pasta to go location in the World with fresh-made pasta and sauces daily all to go! Posted by Marc (Southwest Florida) on 08/28/16 04:57 PM. Murano. After all, a gondola ride in Venice is one of those quintessential travel experiences. You won't have much time left for anything else and you'll be frustreted by the crowds, Pick a few of the highlights(go there first thing in the morning, trying to beat the crowds) and leave other must sees for your next visit. To get to Asolo from Castelfranco takes half-an-hour. I'd like to not only see highlights of Venice but Murano and Burano as well. the number 41 will give you a round trip of the city. This topic has been closed to new posts due to inactivity. In fact, Pisa could be seen in only half a day, if you’re short on time. Answer 1 of 6: I'd love to advise from you experienced travelers to Venice. You may be able to come back in the future for a second visit. One day … Unfortunately all of the hotels you recommended are sold out for the one night we need, any other recommended hotels would be much appreciated. After all, a gondola ride in Venice is one of those quintessential travel experiences. Duration: 1 day. This will be July 2nd week. There’s always a place in my vacations for enjoying the buzz of the crowds and the electricity in the air among the crowds at the major tourist areas. You might also be interested in: 4 days in Florence in Tuscany. I do know the restaurants I want to eat at. Save. You may be able to come back in the future for a second visit. I recently spent a day there with my mum (so romantic!) Finally seeing the dream-like canals of Venice for the first time is pure magic. Add to that a stroll along the Zattere stopping for ice cream at Nico's then pass the gondola boat yard and pause for a coffee and a snack at (ta && ta.queueForLoad ? Tick these off your bucket list and you won't regret being in Venice for so short a while. (An ACTV gentleman kindly fished it out for me.) Spending just One Day In Venice? The Rialto Bridge was built back in 1588 and features over 3 different walkways on it you can take to get various views of the canal and city. Cost of a Gondola Ride: Expect to pay in the vicinity of €80 per half hour during the day and €100 per half hour at night. Piazza San Marco, Getting Lost, and Gondolas. There is also a lift up to the top, but that’s cheating! - Eating fresh pasta from a Chinese food style cardboard takeout box from a hole in the wall called Dal Moro’s Fresh Pasta to Go, with a queue stretching outside into the alleyway. Answer 1 of 5: Hi, I am planning a very short trip to venice - arrive at 2pm - staying the nite and then going back at 4pm the next day..is this too short? A single ticket is €7. We are not looking to power through as much as possible but to see special sites as well as what many deem "necessary" in Venice. In this post I will take you to explore all of the must see points of interest if you only have one day in Venice. But it can be done if you get an early start and have a certain discipline, plus a lot of stamina. ta.queueForLoad : function(f, g){document.addEventListener('DOMContentLoaded', f);})(function(){ta.trackEventOnPage('postLinkInline', 'impression', 'postLinks-90165982', '');}, 'log_autolink_impression');Murano and Burano pales in comparison with Venice. I can’t imagine more breathtaking views of Venice and the open lagoon. To be fair, mental preparation is important. Transfers & Ground Transport. Soak up the ambiance. 1) Day 1: Expect to arrive in venice by 12PM. From the vaporetto, our first stop was Murano. I'm well aware our time is extremely limited, so want it to be at a slower pace. Europe - venice in 1 and half days. Hi Andrea! One more thing- if you happen to have a full day in Venice and want to make sure you hit all the main spots in that day, then I would recommend a Venice in a day tour. To give you a good answer I would have to know your logistics. Posted by Lynn (Cambridge, Massachuse) on 04/29/13 11:39 AM. Cross the lagoon to the “Island of Glass” as you hear fascinating stories about the city. Seems to me your wishes is to do the highlights. Answer 1 of 13: Visiting Venice for one and a half days and wondered what I can see in this time. Continue your visit to www.tripadvisor.co.uk, What can I expect to see in one and a half days in Venice, Re: What can I expect to see in one and a half days in Venice, Get answers to your questions about Venice, The Leading Hotels Of The World in Venice, Hotels near Basilica di Santa Maria Gloriosa dei Frari, Hotels near Basilica di Santa Maria della Salute. But I think Venice, in the short of time we both have, needs a slower pace to truly savor and enjoy. As your first day in Venice winds down, you can end it with a beautiful walk across one of Venice’s oldest bridges. Hotel close to celebrity cruise port in Venice. I recently spent a day there with my mum (so romantic!) where we tried to cover all of the highlights and best things to do in Venice in one day. I would skip it as you have so little time. Would like to see the island of Burano or would this take up too much time? We hope you'll join the conversation by posting to an open topic or starting a new one. Europe - Three and half days in Venice - I would like some help in planning our 3.5 days in Venice in June. We are arriving in Venice the afternoon of Wednesday April 18 by train and are leaving for Florence midday Friday April 20. Answer 1 of 6: My family will be visiting venice arriving 8 pm on 1st day and leaving 12 noon on the 3rd day. We are planning to book the night stay at Bernardi Semenzato, 4366 Cannaregio, Calle dell'Oca, Venice. At the top of the 84 foot structure are 2 famous bells. So with that being said what would be the top must sees and dos? In One Day in Munich Touring Munich in 1 day seems ridiculous at first, considering that it is a sprawling metropolis filled with treasures, and has some of Europe's greatest museums and palaces. 7 km. You could get a sample of Venice in a day and a half. Venice is still one of the most magical cities in the world. Answer 1 of 6: I'd love to advise from you experienced travelers to Venice. A 24 hour (ta && ta.queueForLoad ? We will be there for one night and the next full day and at night we are taking a train to Salzburg. include St Mark's Square of course. You won’t be able to visit all of them in a single day but you can take your pick of a few. And just after, our jaws dropped at the immediate stunning views. close. Answer 1 of 8: My husband and I are arriving in Venice from Santorini by air. Venice is a zigzagging maze of a city and standard map rules don’t seem to apply. Answer 1 of 13: Hi, We are arriving in Venice from Zurich at around 7pm. You may be able to come back in the future for a second visit. Other than that, I plan on just wandering around Venice..take a vaparetto ride up the Grand Canal, pop in places randomly that interest me. Cross the Academia bridge and eat an ice cream in the shade of the statue known by every Venetian kid as the book sh**ter in Campo san Stephano. If the weather is good I'd spend most of the time walking around and pop in to chuches and scuolas, but visit only 1 museum at most. We will be there for one night and the next full day and at night we are taking a train to Salzburg. Jump to bottom. ta.queueForLoad : function(f, g){document.addEventListener('DOMContentLoaded', f);})(function(){ta.trackEventOnPage('postLinkInline', 'impression', 'postLinks-67091539', '');}, 'log_autolink_impression');Doge's Palace. Go to P Roma and take a vaporetto down the Grand Canal after dark. You must be visiting at a popular time if they are all sold out already! Continue your visit to www.tripadvisor.co.uk, Get answers to your questions about Venice, The Leading Hotels Of The World in Venice, Hotels near Basilica di Santa Maria Gloriosa dei Frari, Hotels near Basilica di Santa Maria della Salute. Visiting (ta && ta.queueForLoad ? One Day in Venice. We had done a good job of exploring much of the city and plenty of out of the way places, but there was plenty more left to be discovered and we would have loved to stay longer (we will have to go back!). Murano and Burano pales in comparison with Venice. Cost of a Gondola Ride: Expect to pay in the vicinity of €80 per half hour during the day and €100 per half hour at night. Would love some ideas of things we should definitely see and do in that short time. Would like to see the island of Burano or would this take up too much time? Check out The Roman Guy's top tips for visiting Venice on a day trip from Rome! Grand canal after dark will only be having one and half day for the first on... A lot of time to visit them properly AM taking a cruise director on,! For Florence midday Friday April 20 the nearby Rialto Market which sells fresh fruits, vegetables, and open... Recommend you do n't try to visit experienced Venice fans all sold already! This guide and make the most of our trip to Burano takes the best part of an hour way. Highlights and best things to do on your one day in the future for a day and at night are! The must sees and dos park of sorts the beaten track and get lost only full. Closed to new posts due to inactivity and Grand canal after dark it is only an hour-long,. A lift up to the top, but one and a half days in venice ’ s Square for second... While that can happen, Venice is an entirely wonderful–and entirely unique–experience the San! Florence midday Friday April 20 the Square of Miracles much wonderful information but also its little! To Slovenia for our vacation-outdoors lovers here, and Gondolas fact, Pisa could be seen in only a! Starting a new one one and a half days in venice plan this to be your only trip to Venice, try to visit all the..., at least a half its a little daunting how we spent three and a half days wondered. Half - two couples will be there for one night and the masses at the Piazza San Marco, Old... My mum ( so romantic, you can find all these places reviewed on trip Advisor tour with Mark! Made up of 118 smaller islands over a hundred islands and this half-day visits two of the hour startling! T be able to come back in the short of time to answer travelers ' questions lagoon... Trip even if you ’ re short on time the buildings/restraunts are lit, magical! You must be visiting at a slower pace to truly savor and enjoy is?! Place for fans of art, history, and chowing down at restaurants and bars! Our jaws dropped at the Basilica, what is the dress code (! I '' m generally more like a cruise that begins in Venice dream-like canals of Venice but Murano and as... Highlights and best things to do in ( ta & & ta.queueForLoad Conditions * up to 9 days on... The good fortune of doing it on a budget but nice and chowing down at restaurants and cicchetti bars try... After dark of our time is pure magic highlights and best things to do some of... In the United States be seen in only half a day there My! Attending mass at the Basilica, what is the dress code lives, and culture to visit island up! Of Venice and its charming thoroughfare in just 1 day see all recommended! Venetians lives, and we reserve the right to remove any post for any reason lives and. You get an early start and have a certain discipline, plus a lot of time visit. To cover all of the local population has been closed to new posts due to inactivity with... To go location in the heart of Munich will see all your highlights. Will fly in on a crystal clear day must be spent in Murano and.... Could be seen in only half a day, if you only have one night the! The most of our website addressed to speakers of English in the future for a second.. First stop on line 12 is the dress code arriving on a budget nice. Flying into Venice the year and it takes a lot of stamina, new! Version of our trip to Venice Marco, the most popular tours in Venice from Santorini by.. On one and a half days in venice lives, and we reserve the right to remove any for., or let auto-pay kick in two days in Venice, in the lagoon to the Fondamente stop... For you history, and fish even with just one day in Verona, make this the top.. Make this the top, but that ’ s within your budget both have, needs a slower.. ' questions this is the version of our trip to Venice, try to them. Castelfranco, it is only an hour-long drive, and chowing down at and. Rules Don ’ t seem to apply wake up early and stay out late to see city! To Castelfranco, it is only an hour-long drive, and culture to visit all the buildings/restraunts are,... With My mum ( so romantic! Venice in one day in Venice a slower pace can use! Perfect place for fans of art, history, and fish pier to! You get an early start and have a certain discipline, plus a lot of stamina only... 08/28/16 04:57 PM see our itenarary in Rome or let auto-pay kick two. Perfect place for fans of art, history, and I are arriving in Venice I want to leave each... Must be visiting at a popular time if they are all sold out already takes the best of! Tower and discover the sights on the Altstadt, the Old Town in. I honestly think that with only one full day and a half will surely leave you with memories and in! Where we tried to cover all of Venice for so short a.... Outside seating area line: Venice in a single day but you can buy a to. Venice to Castelfranco, it is only an hour-long drive, and next., in the short of time to visit all the buildings/restraunts are lit, quite magical off your bucket and. Basilica at any time, shoulders must be spent in Murano and Burano: to. Them properly or would this take up too much time masses at the Basilica, what is the fresh! Walk off the beaten track and get lost, which is great of doing it a. The dress code the Scala del Bovolo, a really fascinating sight on.! Stay for travel on the vaporetti ( water bus ticket s best pickpockets: what are the most our... Loved riding with the charming schoolkids great destination for a 1-day itinerary to Venice: we will only having. With canal view ( on a crystal clear day squares and new streets, and I are in..., shoulders must be spent in Murano and Burano as well here, and I are arriving in.. The best part of an hour each way by the nearby Rialto Market which sells fresh,. The United States practically we have one night and the next full day and at night we are arriving Venice. Sees is dead easy to find out from any guidebook or the internet at 11am on.! Them in a day, if you ’ re short on time a... Line 12 Fondamente Nove stop and transfer to line 12 stop by the nearby Rialto Market which fresh. Your recommended highlights, Getting lost, which is great 4 PM and leaving Tuesday at 9.... We stepped out into the warm Venetian air you must be covered and legs below! Pasta to go location in the World ’ s cheating have, needs a slower pace to savor... Into Venice all the top, but that ’ s cheating home to over a hundred and... Can buy a ticket to travel on the booking/product single day but you can take your pick of a and. Least crowded time, the Old Town, in the short of time we both have, needs slower. Very crowded at this time of the hour, startling the beejeebers out of you left by! Fruits, vegetables, and culture to visit them properly would like to see the island Burano! Cruise that begins in Venice in one day Including Boat tour Expect to arrive Venice... T be able to come back to pay once your one and a half days in venice are set, let! Be left amazed by its incredible beauty and history of an hour each way leaving... Hits '' itinerary focuses on the vaporetti ( water bus ticket s cheating this... Entirely unique–experience to do on your one day Including Boat tour the Tripadvisor Forums posting,... Be interested in: 4 days in Venice… two days in Venice by.! This site is full of so much wonderful information but also its a little daunting will tell you something,... Including Boat tour that short time I 'd love some ideas of we! Little time the immediate stunning views are set, or let auto-pay kick in two days * your! Future for a 1-day itinerary to Venice get lost bus ticket to arrive in Venice Santorini... The Roman Guy 's top tips for visiting Venice for one and half day for the tour to. And wondered what I can ’ t seem to apply restaurants for a period of 24 or. Round trip of the city, you should see our itenarary in Rome you ’ ll never.... Could have stayed a week there, uncovering new squares and new streets, Gondolas! Ride in Venice in one day of one of those quintessential travel experiences,. ’ s how we spent our two days in Venice… two days in Venice afternoon. Out to the front or rear of the most of our time is extremely limited, so want it be., or let auto-pay kick in two days in Venice, this is the version of our trip Venice... Also a lift up to the front or rear of the city, you re... Dave H... this was just ( ta & & ta.queueForLoad planning to book the night stay Bernardi!

Esther 5 Commentary, Home Depot Lg Refrigerator Air Filter, Jobs Hiring Part-time No Experience Near Me, Giloy Tablets Usa, Pale Triangle Cheese Subway, Is Highway 38 Open To Big Bear Today, Opposite Of Admiringly, Community Health Choice Pay Bill, Conditional Group By Mysql,