· 8 years ago · Jul 02, 2018, 10:18 AM
1SELECT SUBSTRING_INDEX(`link_name`, ' ', 5) AS linkalias FROM `m5cob_mt_links`
2
3CREATE TABLE `m5cob_mt_links` (
4 `link_id` int(11) NOT NULL,
5 `link_name` varchar(255) NOT NULL,
6 `alias` varchar(255) NOT NULL,
7 `link_desc` mediumtext NOT NULL,
8 `user_id` int(11) NOT NULL DEFAULT '0',
9 `link_hits` int(11) NOT NULL DEFAULT '0',
10 `link_votes` int(11) NOT NULL DEFAULT '0',
11 `link_rating` decimal(7,6) UNSIGNED NOT NULL DEFAULT '0.000000',
12 `link_featured` smallint(6) NOT NULL DEFAULT '0',
13 `link_published` tinyint(4) NOT NULL DEFAULT '0',
14 `link_approved` int(4) NOT NULL DEFAULT '0',
15 `link_template` varchar(255) NOT NULL,
16 `attribs` text NOT NULL,
17 `metakey` text NOT NULL,
18 `metadesc` text NOT NULL,
19 `internal_notes` text NOT NULL,
20 `ordering` int(11) NOT NULL DEFAULT '0',
21 `link_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
22 `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
23 `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
24 `link_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
25 `link_visited` int(11) NOT NULL DEFAULT '0',
26 `firstname` varchar(255) NOT NULL DEFAULT '',
27 `lastname` varchar(255) NOT NULL DEFAULT '',
28 `address` varchar(255) NOT NULL,
29 `city` varchar(255) NOT NULL,
30 `state` varchar(255) NOT NULL,
31 `country` varchar(255) NOT NULL,
32 `postcode` varchar(255) NOT NULL,
33 `contactperson` varchar(255) NOT NULL DEFAULT '',
34 `telephone` varchar(255) NOT NULL,
35 `mobile` varchar(255) NOT NULL DEFAULT '',
36 `fax` varchar(255) NOT NULL,
37 `email` varchar(255) NOT NULL,
38 `website` varchar(255) NOT NULL,
39 `year` int(11) NOT NULL,
40 `date` date NOT NULL,
41 `price` double(12,2) NOT NULL DEFAULT '0.00',
42 `show_map` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
43 `lat` float(10,6) NOT NULL COMMENT 'Latitude',
44 `lng` float(10,6) NOT NULL COMMENT 'Longitude',
45 `zoom` tinyint(3) UNSIGNED NOT NULL COMMENT 'Map''s zoom level'
46) ENGINE=MyISAM DEFAULT CHARSET=utf8;
47
48--
49-- Dumping data for table `m5cob_mt_links`
50--
51
52INSERT INTO `m5cob_mt_links` (`link_id`, `link_name`, `alias`, `link_desc`, `user_id`, `link_hits`, `link_votes`, `link_rating`, `link_featured`, `link_published`, `link_approved`, `link_template`, `attribs`, `metakey`, `metadesc`, `internal_notes`, `ordering`, `link_created`, `publish_up`, `publish_down`, `link_modified`, `link_visited`, `firstname`, `lastname`, `address`, `city`, `state`, `country`, `postcode`, `contactperson`, `telephone`, `mobile`, `fax`, `email`, `website`, `year`, `date`, `price`, `show_map`, `lat`, `lng`, `zoom`) VALUES
53(6, 'Convivio Bar & Restaurant Chester Cheshire UK', '', 'Italian Restaurants in Chester, Cheshire.rnBest Restaurants in Chester, and one of the best places to eat and dine out in Chester, CheshirernrnStart your evening with a mouth-watering meal downstairs in our restaurant then retire upstairs in our beautiful Grosvenor 29 bar, the perfect setting for an after dinner aperitif. In the summer months our stunning south facing Piazza is opened allowing you to enjoy Chester's sunshine, whether it is to dine Al Fresco or enjoy a refreshing cocktail. At Convivio, we are committed to using the freshest and highest quality ingredients we can source. Where possible, we use local, organic produce, attending the wholesale market ourselves each week so that we can hand-pick our ingredients rather than having to rely on suppliers to choose these for us. Our skilled Italian pizzaiolo produces, quite simply, the tastiest, most authentic pizza. Truly mouth-watering pizzas and calzones made with freshly kneaded dough that has been stretched by hand and baked in our signature stone oven made by specialist Italian artisans. Our restaurant or bar areas can also be used as the perfect location for private hire, weddings, networking events and other special occasions. Convivio undoubtedly is the place to be seen all year round.', 70, 2260, 11, '5.000000', 0, 1, 1, '', 'use_map=nshow_print=nshow_recommend=nshow_rating=nshow_review=nshow_visit=nshow_contact=nshow_report=nshow_ownerlisting=', 'best-italian-restaurants-chester-cheshire-uk', '', '', 999, '2014-06-20 00:00:00', '2014-06-20 00:00:00', '0000-00-00 00:00:00', '2016-09-01 17:05:39', 1011, '', '', '29 Grosvenor Street', 'Chester', 'Chester', 'England', 'CH1 2DD', '', '01244 400029', '', '', 'info@conviviochester.co.uk', 'http://www.conviviochester.co.uk', 0, '0000-00-00', 0.00, 1, 53.187222, -2.892609, 13),
54(7, 'Slug and Lettuce Chester Cheshire UK', '', 'Restaurants in Chester, Cheshire.rnThe Slug and Lettuce in Chester is one of the best restaurants in Chester, and we are one of the best Bars in Chester, Cheshire,rnWe feel that the Slug and Lettuce Bar and Restaurant in Chesterrnis one of the best places to eat and drink in Chester Cheshire, as we have been informed many times.rnMondays are 50% off all food, Tikka Tuesday 2-4-1 curry’s and bottles of cobra £2.60, wine down Wednesday any bottle of wine for £11.45 (excludes sparkling and slug finest), Thursday is student night where we link up with other local bars to offer you free entry and Q-jump to local night club Rosies, Sundays are family days kids eat for a quid with every adult meal purchased. rnFamily friendly by day, romantic/casual at night, party at weekend', 77, 1423, 4, '5.000000', 0, 1, 1, '', 'use_map=nshow_print=nshow_recommend=nshow_rating=nshow_review=nshow_visit=nshow_contact=nshow_report=nshow_ownerlisting=', '', '', '', 999, '2014-06-25 00:00:00', '2014-06-25 00:00:00', '0000-00-00 00:00:00', '2016-09-02 18:54:41', 552, '', '', '44 Bridge Street', 'Chester', 'Cheshire', 'United Kingdom', 'CH1 1NQ', '', '01244 319873', '', '', 'slugandlettuce.chester@stonegatepubs.com', 'http://www.slugandlettuce.co.uk/slug-chester/', 0, '0000-00-00', 0.00, 1, 53.189251, -2.891246, 11),
55(8, 'Da Rosa Restaurant & Wine Bar Torrevieja Costa Blanca Spain', '', 'Best Restaurants in Torrevieja Costa Blanca in Spain.rnTruly one of the Top Class Restaurants in Orihuela Costa region in the Costa Blancarnrn5 Star Mediterranean/Italian Restaurant, Tapas, and Wine Bar, Cafeteria, and Pasteleria in Punta Prima, near Torrevieja, in the Costa Blanca, SpainrnrnUltra Modern Open Kitchen, with totally all new quality appliances, with a Large Serving Hatch, with seating inside for upto 80 people. The Restaurant has a large outside covered terrace, with Electric, which is Extremely well illuminated, and there are numerous car parking spaces, as well as underground parking.rnrnThe Restaurant, and Bar, has an inside area of 180 sq.mtrs, and is fully Air Conditioned. The Restaurant is also, equipped for the Disabled.rnrnUnique U Shape Cocktail Wine Bar with Unique Feature Light Fitting over the Bar.Television in the Bar, and a State of the Art Music Sound System in the Restaurant.rnrnThe Sound System is also fully equipped for Entertainment, both within the Restaurant, and is equipped for the outside terrace in the summer for Entertainment.rnrnThe Restaurant has also become a Favourite for Wedding Ceremony Celebrations, and other numerous private functions. Almost everyone that enters the Restaurant, wish to take photos, for memoribilia, and are complimentary on the decoration, and design of the Restaurant.rnrnThe current Hours of Business are 11.00 a.m. to 12.00 p.m. From 11.00. a.m. to 5.00.p.m functional as Restaurant, Cafeteria, and Pasteleria. From 5.00.p.m. to 12.00.p.m. Restaurant, Wine Bar, and Tapas.rnrnWithin 3 years, this Restaurant has built up a fabulous reputation, for both residents, and Holiday Makers.rnrnThis Restaurant is truly incredible, and is of the highest possible quality, Luxury Dining at it's Best.', 69, 915, 3, '3.666667', 0, 0, 1, '', 'use_map=nshow_print=nshow_recommend=nshow_rating=nshow_review=nshow_visit=nshow_contact=nshow_report=nshow_ownerlisting=', '', '', '', 999, '2014-06-25 00:00:00', '2014-06-25 00:00:00', '0000-00-00 00:00:00', '2016-03-25 16:00:34', 0, '', '', 'Centro Commercial La Campana N332 Punta Prima', 'Torrevieja', 'Alicante', 'Spain', '03189', '', '0034 965 325075', '', '', '', '', 0, '0000-00-00', 0.00, 1, 37.946247, -0.722139, 13),
56(9, 'Bar Lounge Chester Cheshire UK', '', 'Restaurants in Chester, Cheshire.rnOne of the Best Restaurants in Chester to eat and dine out, and one of the Best Bars in Chester with a fabulous atmosphere.rnBest Places to Eat and Dine Out in Chester, Cheshire.rnrnBarlounge is a cocktail bar and restaurant located in Chester City rnCentre Open daily from 11.30 am until late, we offer our guests thernopportunity to drink, dine and socialise in informal surroundings.rnRelax in the bar, catch up with friends on our sun terracern(heated & covered in winter) or enjoy a meal in the restaurantrn there's something to suit everyone on any occasion.rnWe hope to see you soon!rn', 94, 1450, 3, '5.000000', 0, 1, 1, '', 'use_map=nshow_print=nshow_recommend=nshow_rating=nshow_review=nshow_visit=nshow_contact=nshow_report=nshow_ownerlisting=', '', '', '', 999, '2014-07-19 00:00:00', '2014-07-19 00:00:00', '0000-00-00 00:00:00', '2016-09-02 18:51:55', 552, '', '', '75 Watergate Street', 'Chester', 'Cheshire', 'UK', 'CH1 2LB', '', '01244 327394', '', '', 'hello@barlounge.co.uk', 'http://www.barlounge.co.uk', 0, '0000-00-00', 0.00, 1, 53.189804, -2.893222, 13),
57(10, 'Telfords Warehouse Chester Cheshire UK', '', 'Restaurants in Chester, Cheshire.rnTelfords Warehouse in Chester is one of the best places to eat out in Chester, and it is definitely the best place in Chester for Live Music.rnIf your seeking somewhere to drink and dine out in Chester, then this is definitely the place to eat and drink when visiting Chester in Cheshire UKrnrnA fine balance of customer exists, attracted by its friendly staff and large open bar with exceptional selection of European beers, CAMRA rated cask conditioned ales and extensive wine list…rnrnSuperbly located on the canal basin this spacious pub enjoys many original features with high ceiling, exposed timbers and brick walls housing industrial artefacts, while the feature glass frontage provides a tranquil scene overlooking the water.rnrnUpstairs is a popular restaurant and contemporary art gallery with relaxed attentive service, excellent menu and weekly specials. Telford’s lower area is reserved for its highly regarded music nights. An intimate live setting for (amongst countless others) John Williams, Ed Harcourt, Ron Sexsmith, Courtnay Pine, Frank Turner, Richie Havens, Coldplay, Robert Plant, Kathryn Williams, John Martyn and Nitin Sawhney.rnrn“Staff are lovely†– qype.co.uk … “Worth a visit just for the cracking Sunday roast!†– qype.co.uk … “Telfords is amazing!†– qype.co.uk … “I think Telfords is by far the best pub in Chester†– qype.co.uk … “Great gig for live music with good choice of drinks†– qype.co.uk … “Im rating telfords with 5 stars for its food alone!!†– qype.co.ukrnHistory of The WarehousernrnThe building itself provides one of the more interesting features in the historic city of Chester. Originally conceived by the famous industrial engineer Thomas Telford in the 1790’s, the Warehouse stands as a magnificent example of Georgian architecture and as a reminder of the once thriving port of Chester.rnrnThe building was constructed partly over the canal to allow boats to be located and unloaded from the full height of the loading bay within the building.rnrnThe grade 2 listed building was originally converted to a public house in the 1980′s by local architect James Brotherhood.rnrnIn 2000, Telford’s was forced to close due to a major fire which destroyed much of the building’s internal features and took nearly a year to restore.rnrnToday, Telford’s clientelle are attracted by it’s friendly staff and large open bar with an exceptional selection of European beers, CAMRA rated cask conditioned ales and extensice wine list.rnrnSome to have played here…rnrnFrank Turner, Nils Lofgren, Robert Plant, Roy Harper, Nick Harper, John Williams, John Martyn, Nitin Sawhnay, Tom Russell, Yat Kha, Andrew Bird, Eliza Carthy, Martin Carthy, Brian Houston, Gorky’s Zygotic Mynci, Boo Hewadine, Radio Luxembourg, Chris Hillman, Tunng, Adjagas, Julie Fowlis, Peter Rowan, Hemstad, Christine Collister, The Dub Pistols, Clive Gregson, John Power, Sid Griffin, Wilko Johnson, The Skints, John Etheridge, Bert Jansch, Steve Harley, The Venus Fury, Martin Stephenson, Gretchen Peters, Tom Robinson, Lucy Styles, Labi Siffre, The Ruttles, Neal Casal, Audioweb, Little Barrie, Max Sedgley & The Shoots, Funkdub (3DJ & Gentleman Kush), Pama International, Kid Carpet, Hem, Hamell On Trial, David Greenald, The Peatbog Faeries, Melys, Michael Weston King, K Klass, Oc', 95, 1335, 2, '5.000000', 0, 1, 1, '', 'use_map=nshow_print=nshow_recommend=nshow_rating=nshow_review=nshow_visit=nshow_contact=nshow_report=nshow_ownerlisting=', '', '', '', 999, '2014-07-19 00:00:00', '2014-07-19 00:00:00', '0000-00-00 00:00:00', '2016-09-02 18:55:50', 293, '', '', '', 'Chester', 'Cheshire', 'UK', '', '', '', '', '', 'restaurant@telfordswarehouse.com', 'http://www.telfordswarehousechester.com', 0, '0000-00-00', 0.00, 1, 53.193394, -2.893075, 13),
58(11, 'The Botanist Chester Cheshire UK', '', 'Best Restaurants in Chester, Cheshire to Eat and Dine Out.rnThe Botanist is one of the Best International Restaurants to dine out in Chester, and is one of the Best Bars in Chester with a fabulous ambience, and fantastic Food.rnrnThe Botanist offers a well stocked cellar of cask-conditioned ales, more than 40 bottled beers and ciders from around the world, a selection of finest Champagnes and an intriguing cocktail menu. Food at The Botanist comes in the form of a deli-style menu with rotisserie and barbecue. Owned and operated by the New World Trading Company, The Botanist is a concept unlike anything else!', 105, 1618, 2, '5.000000', 0, 1, 1, '', 'use_map=nshow_print=nshow_recommend=nshow_rating=nshow_review=nshow_visit=nshow_contact=nshow_report=nshow_ownerlisting=', 'the-botanist-chester-cheshire-uk', '', '', 999, '2014-07-27 00:00:00', '2014-07-27 00:00:00', '0000-00-00 00:00:00', '2016-09-02 18:55:34', 250, '', '', '13 St. Werburgh Street', 'Chester', 'Cheshire', 'UK', 'CH1 2DY', '', '01244 408 100', '', '', 'chester@thebotanist.uk.com', 'http://thebotanist.uk.com', 0, '0000-00-00', 0.00, 1, 53.191219, -2.890245, 13),
59(12, 'Missoula Chester Cheshire UK', '', 'Restaurants in Chester, Cheshire.rnBest British Restaurants in Chester, Cheshire to Eat and Dine Out.rnDine Out at Great Restaurants in Chester, CheshirernBest Places to Eat in Chester.rnMissoula Restaurant in ChesterrnrnAt the heart of Chester standing proud with our antlers in the air is Missoula.rnrnBy day a relaxed and friendly place to grab a bite to eat and catch up with your friends, by night we become the perfect place to party offering style and substance without an ounce of pretension.rnrnThis is Missoula. This is Chester.rnrnOpening hours:rnrnSun - Wed 10am - 1am,rnThurs 10am - 2am,rnFri - Sat 10am - 3amrnrn', 107, 1837, 2, '5.000000', 0, 1, 1, '', 'use_map=nshow_print=nshow_recommend=nshow_rating=nshow_review=nshow_visit=nshow_contact=nshow_report=nshow_ownerlisting=', '', '', '', 999, '2014-07-27 00:00:00', '2014-07-27 00:00:00', '0000-00-00 00:00:00', '2016-09-02 18:54:14', 329, '', '', '2-3 Music Hall Passage', 'Chester', 'Cheshire', 'UK', 'CH1 2EU', '', '01244 344802', '', '', 'missoula.chester@stonegatepubs.com', 'http://www.missoulabars.co.uk/missoulachester/', 0, '0000-00-00', 0.00, 1, 53.191128, -2.891022, 13),
60(13, 'Fiesta Havana Chester Cheshire UK', '', 'Restaurants in Chester, Cheshire.rnBest Latin American Mediterranean Tapas Restaurants in Chester, Cheshire to Eat and Dine Out.rnOne of the Best Places to Eat, and Dine Out in Chester.rnFiesta Havana is one of the Best Bars in Chester with an electric atmosphere.rnrnFiesta Havana Chester – smooth Latin-style and infectious Caribbean rhythms. A little piece of Cuba, right in the heart of Chester. Fiesta Havana is the home of the mojito – the best in town. Smooth Latin-style and infectious rhythms cannot fail to make those feet tap or, more likely, dance the night away! Cocktail lessons held regularly – contact us to book. International bands and world-renowned DJs, playing the best mix of Latin, infused with British dance. Speciality aged rums and tequilas. Sizzling fajitas, tempting tapas and pile-’em-high homemade specials. Dance, eat, drink and party – all in one venue!rnrnrnrnFiesta Havana is located on Watergate Street in the centre of Chester. We are located just off the cross (a well known monument in Chester's city centre). If you are walking from the cross we are half way down Watergate street on the left hand side on street level.rnrnFiesta Havana runs a strict dress code. Please dress to impress. No sportswear allowed. No shorts allowed at weekends.rnrnUnder 18's are allowed in Fiesta Havana up to 9pm at night in the restaurant and 7pm in the bar area.rnrnOpening hours:rnrnMon 12pm–1amrnTue 12pm–2amrnWed 12pm–1amrnThu 12pm-2amrnFri 12pm-2amrnSat 12pm-3amrnSun 12pm–1am rn', 123, 1493, 3, '5.000000', 0, 1, 1, '', 'use_map=nshow_print=nshow_recommend=nshow_rating=nshow_review=nshow_visit=nshow_contact=nshow_report=nshow_ownerlisting=', '', '', '', 999, '2014-08-19 00:00:00', '2014-08-19 00:00:00', '0000-00-00 00:00:00', '2016-09-02 18:53:42', 315, '', '', '39-41 Watergate Street', 'Chester', 'Cheshire', 'UK', 'CH1 2LB', '', '01244 347878', '', '', 'havana.chester@stonegatepubs.com', 'http://www.havanachester.co.uk', 0, '0000-00-00', 0.00, 1, 53.189804, -2.893222, 13),
61(14, 'El Oceano Hotel Restaurant, Torrenueva, Marbella, Malaga', '', 'Restaurants in Riviera del Sol, MarbellarnBest Sea Front Restaurants in Mijas Costa, and MarbellarnHotel Restaurants near MarbellarnEl Oceano Hotel Restaurant on Miraflores Playa, Torrenueva, Riviera del Sol, Mijas Costa near to Marbella is right by the Ocean… close to perfection!rnEl Oceano Beach Hotel in the Costa del Sol is an oasis of laid-back luxury, privately owned and operated, where guest comfort and satisfaction is paramount!!  If you’re new to El Oceano, please take a moment to look around – you’ll be impressed! If you are one of our many returning guests – Welcome back!!  El Oceano Beach Hotel is located midway between Fuengirola & Marbella, only a stone’s throw from the playground of the rich and famous –Puerto Banus!  This jewel of a hotel gives the feeling of staying in your very own seafront residence, a truly unique and wonderful place.rnThe HotelrnThere is nowhere like El Oceano Beach Hotel. Our accommodation is some of the most exquisite on the Costa del Sol, newly renovated and redecorated, most with Mediterranean Sea Views. Some of the exclusive rooms even have private, en-suite jacuzzis! Go on… spoil yourself!rnEntertainmentrnEveryone knows about the quality of our restaurants – the food, the service, the atmosphere. But at El Oceano Beach Hotel, we make your dining experience all the better with our top quality entertainment schedule. rnThe RestaurantrnEl Oceano Beach Hotel Restaurant boasts one of the finest dining experiences on the coast where lunch & dinner is served everyday either in the Ocean Room, on the Veranda or in the summer months outside on the stunning Waterfront Terrace, all featuring top class live music most evenings and in particular do not miss our ‘famous’ Sunday Lunch!rnDinner is served each evening in the Oceano Veranda, a glass enclosed dining room seemingly “suspended†over the ocean. Not forgetting the “famous†Water Front Terrace, where the views will take your breath away, and where lunch by the sea can last forever! Live music is provided every evening at El Oceano, in the Oceano Room and during the summer months on the Water Front Terrace. The hotel’s bar and lounge areas are absolutely sumptuous, where an impressive choice of cocktails, liquors and wines are served by El Oceano’s expert friendly staff.rnThe Ocean RoomrnExquisite cuisine impeccably presented and complemented by top class live entertainment, a more impressive place to dine would be hard to imagine.rnThe Oceano VerandarnDinner is served each evening in the Oceano Veranda, a glass enclosed dining room seemingly suspended over the ocean.rnThe Water-Front TerracernWhere the views will take your breath away, and where lunch by the sea can last forever! Live music is provided every evening at El Oceano, in the Oceano Room and during the summer months on the Water Front Terrace. The hotel’s bar and lounge areas are absolutely sumptuous, where an impressive choice of cocktails, liquors and wines are served by El Oceano’s expert friendly staf', 129, 3840, 9, '5.000000', 1, 1, 1, '', 'use_map=nshow_print=nshow_recommend=nshow_rating=nshow_review=nshow_visit=nshow_contact=nshow_report=nshow_ownerlisting=', 'best-hotel-restaurants-marbella', '', '', 999, '2014-11-17 00:00:00', '2014-11-17 00:00:00', '0000-00-00 00:00:00', '2017-07-28 18:17:15', 711, '', '', 'Ctra. de Cádiz A7 (N340) Km 199, Miraflores Playa', 'Riviera Marbella,', 'Mijas Costa Málaga Costa del Sol', 'Spain', '29649', '', '(+34) 952 587 550', '', '(+34) 952 587 637', 'info@eloceanohotel.com', 'http://www.oceanohotel.com', 0, '0000-00-00', 0.00, 1, 36.499863, -4.685594, 13),
62(15, 'La Plaza Restaurant Riviera del Sol Mijas Costa Malaga Spain', '', 'One of the Best Restaurants in Riviera del Sol, next to Calahonda, Mijas Costa.rnLa Plaza Italian Restaurant in Riviera del Sol ,is definitely in the category of The Best Italian Restaurants in Mijas Costa and Marbella rnrnWe Welcome you to La Plaza Restaurant to enjoy great Italian food, with the best atmosphere of comfort in their inside area or terraces, with long opening hours, no days of closing. In the heart of Riviera del Sol, Mijas Costa, Malaga. And, of course, our live shows and events, going on the whole year with sustained quality and variety, from soul to flamenco shows.rnSince 2009, Ristorante La Plaza has become one of the significant culinary references on the Costa del Sol, specializing in genuine Italian cuisine. The best combination: top quality products, exceptional professionalism and a wide and varied menu of quality dishes at affordable prices…Welcome to our Ristorante, your Ristorante!', 130, 3103, 5, '5.000000', 0, 1, 1, '', 'use_map=nshow_print=nshow_recommend=nshow_rating=nshow_review=nshow_visit=nshow_contact=nshow_report=nshow_ownerlisting=', '', '', '', 999, '2014-11-17 00:00:00', '2014-11-17 00:00:00', '0000-00-00 00:00:00', '2017-07-28 17:43:53', 662, '', '', 'Av de Golf de la Urbanización Riviera del Sol, 25 CC RIVIERA PLAZA', 'Riviera del Sol, Marbella,', 'Mijas Costa, Malaga', 'Spain', '29649', '', '+ 34 952 935 073', '', '', 'info@ristorante-laplaza.com', 'http://www.ristorantelaplaza.com', 0, '0000-00-00', 0.00, 1, 36.499863, -4.685594, 13),