MySQL Forums
Forum List  »  Newbie

Re: Select first record of each ID mysql5.6
Posted by: Dave F
Date: December 17, 2020 12:01PM

Is this how you mean?

stivagallery_galleries

INSERT INTO `stivagallery_galleries` (`fuel`, `model`, `make`, `engine`, `hp`, `drive`, `title`, `story`, `id`, `name`, `layout`, `target`, `width`, `height`, `preview_width`, `preview_height`, `thumb_width`, `thumb_height`, `ratio`, `custom_width`, `custom_height`, `max_width`, `slideshow_speed`, `created`, `status`) VALUES
('Petrol', 'Norman 25', 'Norman', '', 15, 'Outboard', 'Haddock's Revenge', 'This is my old Norman 25 "Haddocks Revenge", we bought it as we wanted more space than my Norman 18.5 could offer and very soon realised the centre cockpit wasn't nearly as practical as we thought, especially with an old creaky dog as it was a plummet to get onboard.\r\n\r\nIt was touch and go wether we cut our losses and just sold it again but after a few beers we came up with the idea of cutting the aft cabin off, well it needed refitting anyway as it had been done in sterling board and was rotten so may as well go to town on it, we still had the Norman 18.5 for general use while we did the job.\r\nThe canopy had to be made and would need all new poles so we worked out where best to have them to make a clear opening with no poles to climb through and how to have them out of the way when folded down, sliding runners was the way to go so when folded the rear pole rested on the rear deck and the front pole hooked over the screen and slid back again till it rested just in front of the screen close enough so the screen would still fold down, result was with the sides removed the rest of the canopy and screen could raised or lowered in about 30 seconds while solo helming.\r\nHaddocks revenge was sold back in 2006 after getting the bug for coastal cruising and bought an RLM 31 "Leo Magill" (now also gone to make way for "snowbird" a Princess 30DS). \r\nI'd had 2 Normans before this one but can't find any pics or I'd add them to the register, first was my very first boat, a Norman 20 called Merlin, very soon discovered the cost of canopies and outboards and discovered the BSSC so it got sold very quickly without ever using it, a couple of months later I bought a Norman 18.5 called Rokema, this one had a good canopy and useable outboard but the name had to change, after covering the leaking windows with penguin shower curtains it got renamed Pingu, add a few beers and that evolved into 'Pingu the hadock slayer' (well penguins eat fish...), hence the next boat became Haddocks Revenge, I never was a rational human being........', 1, 'Haddocks revenge', 1, '_self', 320, 240, 800, 800, 200, 200, '1', 1, '1', '800', 1500, '2020-11-22 21:06:13', 'T'),
('Diesel', 'mut', 'dog', '', 1, 'Inboard/Shaftdrive', 'Doggy piccies.', 'Just a test entry with some doggy piccies.\r\nI hope it all works.', 2, 'dogs', 1, '_self', 320, 240, 800, 800, 200, 200, '1', 1, '1', '800', 1500, '2020-11-22 21:37:42', 'T'),
('', '', '', '', 0, 'Outboard', 'Snowbird pics.', 'Piccies and stuff.\r\nTaken from snowbird.\r\nYeah another test entry.', 3, 'Random stuff', 1, '_self', 320, 240, 800, 800, 200, 200, '1', 1, '1', '800', 1500, '2020-11-24 07:42:41', 'T'),
('Diesel', 'RLM 31 Bahama', 'RLM', '', 90, 'Twin Inboard/Outdrive', 'Leo Magill', 'We sold our Norman 25 'Haddocks Revenge' in 2006 after buying Leo Magill, a mid 70's RLM 31, so we could do a bit of sea work.\r\nIt was fitted with a pair of smelly old BMC 2.52 diesels that shook around on rotten bearers when we got her, the fuel tanks were rotten and the bilge awash with water, oil, and diesel so a fairly quick strip out and refit was required, we carried on with the BMC's for a year then decided to change for something newer so got a couple of old peugeot XUD9's and rebuilt/marinised them and fitted on new bearers made from 3"x5" iroko glassed in.\r\nBased on the Great Ouse at St.Neots we did a good few sea miles despite the long run downstream to Denver sluice to get tidal access, first ever sea trip was to Wells next the sea and back in 2007, did a few trips across the wash to Boston and beyond to the Trent, 2009 saw us heading round to Wells for a night then straight up to Hull the next morning continuing on to borobridge and back via the Trent to Torksey where we headed down the fossdyke/Witham to Boston before heading back across the wash.\r\n2010 was an east coast year as we arranged a 3 month mooring on the norfolk broads so of we went via Wells again and in at Gt.Yarmouth, whilst on the broads we did a trip further down the coast visting shotley,Ipswich,Bradwell,Brighlingsea,Maldon,Walton on the naze, Woodbridge and Orford, well you sit on the rivers all the time.....\r\nWhile at Orford we managed to get up to Snape malting just long enough for a pint before the tide started to ebb so had to shot back to Orford before the channel dried up.\r\n2011 Took us to Nottingham via the wash and Witham, then in 2012 we went back to the broads for a permanent base as so much easier sea access, discovered southwold and became a regular sight there, then in 2015 it was time for a change again, long trips were becoming hard work and Leo was no match for a bumpy sea so we ended up with Snowbird, a Princess 30DS with a pair of 150Hp Volvo's, but that is another story.', 4, 'Leo Magill', 1, '_self', 320, 240, 800, 800, 200, 200, '1', 1, '1', '800', 1500, '2020-12-12 17:29:45', 'T'),
('Diesel', 'Princess 30DS', 'Princess', '', 300, 'Twin Inboard/Shaftdrive', 'Snowbird', 'This is my current boat 'Snowbird' a 1982 Princess 30DS.\r\nBought in 2015 as needed a boat change, wanted something faster with better sea keeping and due to an MS diagnosis wanted an electric anchor windlass as my hands don't have the coordination for a chain snatching round a gypsy with 6 ton behind it.\r\nThe pair of 150Hp volvo's power it through lumpy water so much better than I could ever wish for from Leo Magill and much less roll, just drinks fuel faster, will do 22 knots flat out and cruises at 16-18 knots at around 3200rpm.\r\nSo far done most harbours between Wells next the sea and Dover but not up the Thames yet, that would have been this years goal but got plagued out.\r\nFor rivers only I'd go back to the RLM31 any day as was a comfier boat but for sea I'll stick with the Princess till the lottery comes up.', 5, 'Snowbird princes 30ds', 1, '_self', 320, 240, 800, 800, 200, 200, '1', 1, '1', '800', 1500, '2020-12-12 20:36:35', 'T'),
('', '', '', '', 0, '', '', '', 6, 'Phoenix', 1, '_self', 320, 240, 800, 800, 200, 200, '1', 1, '1', '800', 1500, '2020-12-14 17:38:32', 'T'),
('Petrol', 'Norman 23', 'Norman', '', 10, 'Outboard', 'ERAN', ' I bought ERAN in 2018. Looking around eBay I saw the boat for sale by auction with a couple of hours to go. I didn't bid as I wouldn't buy a boat without actually having seen it first. The auction ended and I thought that was the end of my interest in ERAN. About a week later, I saw that the boat had been re-listed due to the winning bidder not having made any contact with the seller. Once again, the end of the auction was close. The boat was in a marina not too far from my home, so I sent the seller a message, telling him that if he was let down by a second auction-winner, I'd like to have a look at the boat, and would tell him there and then whether or not I wanted to buy it. If I didn't, he would have lost just a day or two before re-listing it yet again. I don't know what the chances are of two auctions ending with no contact from the winning bidders, but that's exactly what happened. The auction ended on a Friday, and on Sunday I was invited to go and look at the boat. I liked what I saw and bought it.\r\n ', 7, 'Tom Morgan', 1, '_self', 320, 240, 800, 800, 200, 200, '1', 1, '1', '800', 1500, '2020-12-14 20:10:34', 'T'),
('', '', '', '', 0, '', '', '', 8, 'kernaghanrp', 1, '_self', 320, 240, 800, 800, 200, 200, '1', 1, '1', '800', 1500, '2020-12-16 07:48:31', 'T'),
('Petrol', '32CC', 'Viking', '', 25, 'Outboard', 'Summer Breeze', 'Our New purchase this year after owning a Norman 22 since 2003', 9, 'Adi Hudson', 1, '_self', 320, 240, 800, 800, 200, 200, '1', 1, '1', '800', 1500, '2020-12-17 11:49:53', 'T');

stivagallery_plugin_gallery

INSERT INTO `stivagallery_plugin_gallery` (`id`, `foreign_id`, `model`, `hash`, `mime_type`, `small_path`, `small_size`, `small_width`, `small_height`, `medium_path`, `medium_size`, `medium_width`, `medium_height`, `large_path`, `large_size`, `large_width`, `large_height`, `source_path`, `source_size`, `source_width`, `source_height`, `name`, `title`, `main_title`, `story`, `description`, `alt`, `watermark`, `sort`, `created`) VALUES
(5, 2, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/2_76325965eb3bb81ee404aac7acd3deb3.jpg', 9456, 200, 200, 'app/web/upload/medium/2_76325965eb3bb81ee404aac7acd3deb3.jpg', 81533, 800, 800, 'app/web/upload/large/2_76325965eb3bb81ee404aac7acd3deb3.jpg', 245769, 1652, 1239, 'app/web/upload/source/2_76325965eb3bb81ee404aac7acd3deb3.jpg', 859540, 1652, 1239, 'dog2.jpg', 'Tina & Norman', '', '', 'Tina with her friend Norman in the Ale Taster, they both love a pub floor.', NULL, NULL, 3, '2020-11-22 21:37:59'),
(6, 2, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/2_b4972e9778a5f9b34437c358a002d978.jpg', 9184, 200, 200, 'app/web/upload/medium/2_b4972e9778a5f9b34437c358a002d978.jpg', 128470, 800, 800, 'app/web/upload/large/2_b4972e9778a5f9b34437c358a002d978.jpg', 464147, 1652, 1239, 'app/web/upload/source/2_b4972e9778a5f9b34437c358a002d978.jpg', 1269164, 1652, 1239, 'dog3.jpg', 'The stressed look', '', '', 'Tina looking very comfy in the saloon on Snowbird.\r\nDon\'t she have a hard life!', NULL, NULL, 2, '2020-11-22 21:38:06'),
(7, 3, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/3_977a27522a2887f0f5cdfc14f23333a3.jpg', 8396, 200, 200, 'app/web/upload/medium/3_977a27522a2887f0f5cdfc14f23333a3.jpg', 97340, 800, 800, 'app/web/upload/large/3_977a27522a2887f0f5cdfc14f23333a3.jpg', 1324005, 3120, 4160, 'app/web/upload/source/3_977a27522a2887f0f5cdfc14f23333a3.jpg', 4629432, 3120, 4160, 'IMG_20160430_110407.jpg', 'Breydon bridge', '', '', 'Breydon lifting bridge at Gt.Yarmouth.', NULL, NULL, 1, '2020-11-24 07:43:21'),
(8, 3, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/3_750b556bf1c3f62d693e0426212ed4f4.jpg', 9951, 200, 200, 'app/web/upload/medium/3_750b556bf1c3f62d693e0426212ed4f4.jpg', 95434, 800, 800, 'app/web/upload/large/3_750b556bf1c3f62d693e0426212ed4f4.jpg', 1293780, 4160, 3120, 'app/web/upload/source/3_750b556bf1c3f62d693e0426212ed4f4.jpg', 4436674, 4160, 3120, 'IMG_20160528_152425.jpg', 'Ali & Winston', '', '', 'Looking comfy at Wells Next the Sea.\r\nUnfortunately Winston is no longer with us.', NULL, NULL, 2, '2020-11-24 07:43:49'),
(9, 3, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/3_e9d0626b30a4a059f889a833e0657906.jpg', 6440, 200, 200, 'app/web/upload/medium/3_e9d0626b30a4a059f889a833e0657906.jpg', 78831, 800, 800, 'app/web/upload/large/3_e9d0626b30a4a059f889a833e0657906.jpg', 1332853, 4160, 3120, 'app/web/upload/source/3_e9d0626b30a4a059f889a833e0657906.jpg', 4926971, 4160, 3120, 'IMG_20160719_132237.jpg', 'Obligatory wake shot', '', '', 'You won\'t get a shot like that on the canals (I hope).', NULL, NULL, 3, '2020-11-24 07:44:25'),
(10, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_4d3e9a7afbf229c316706680f7cd65f6.jpg', 8799, 200, 200, 'app/web/upload/medium/1_4d3e9a7afbf229c316706680f7cd65f6.jpg', 73508, 800, 800, 'app/web/upload/large/1_4d3e9a7afbf229c316706680f7cd65f6.jpg', 22430, 468, 223, 'app/web/upload/source/1_4d3e9a7afbf229c316706680f7cd65f6.jpg', 46676, 468, 223, 'haddock1.jpg', 'Haddocks revenge', '', '', NULL, NULL, NULL, 1, '2020-11-28 16:08:23'),
(11, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_947819d333b3a1c2267b3dd8f233417d.jpg', 11878, 200, 200, 'app/web/upload/medium/1_947819d333b3a1c2267b3dd8f233417d.jpg', 94732, 800, 800, 'app/web/upload/large/1_947819d333b3a1c2267b3dd8f233417d.jpg', 70841, 744, 474, 'app/web/upload/source/1_947819d333b3a1c2267b3dd8f233417d.jpg', 160350, 744, 474, 'genie2.jpg', 'Before hacking.', '', '', NULL, NULL, NULL, 2, '2020-11-28 16:08:52'),
(12, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_a83b963a4691d68edc61bb9aeeead430.jpg', 9078, 200, 200, 'app/web/upload/medium/1_a83b963a4691d68edc61bb9aeeead430.jpg', 89082, 800, 800, 'app/web/upload/large/1_a83b963a4691d68edc61bb9aeeead430.jpg', 111038, 1024, 768, 'app/web/upload/source/1_a83b963a4691d68edc61bb9aeeead430.jpg', 260386, 1024, 768, 'aftcabin7.jpg', 'Gutted transom', '', '', 'This is how the inside of the outboard well looked after I had ripped out all the rotten wood.', NULL, NULL, 3, '2020-11-28 16:09:26'),
(13, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_9ee36dfefc93f7806a43e774a21bb366.jpg', 8027, 200, 200, 'app/web/upload/medium/1_9ee36dfefc93f7806a43e774a21bb366.jpg', 67109, 800, 800, 'app/web/upload/large/1_9ee36dfefc93f7806a43e774a21bb366.jpg', 97500, 1024, 768, 'app/web/upload/source/1_9ee36dfefc93f7806a43e774a21bb366.jpg', 220258, 1024, 768, 'gutted5.jpg', 'Cockpit gutted', '', '', NULL, NULL, NULL, 4, '2020-11-28 16:09:34'),
(14, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_98e232a9cd7f1741574f9522d039e9b3.jpg', 31235, 200, 200, 'app/web/upload/medium/1_98e232a9cd7f1741574f9522d039e9b3.jpg', 309410, 800, 800, 'app/web/upload/large/1_98e232a9cd7f1741574f9522d039e9b3.jpg', 221789, 1024, 768, 'app/web/upload/source/1_98e232a9cd7f1741574f9522d039e9b3.jpg', 110378, 1024, 768, 'gutted3.jpg', NULL, '', '', NULL, NULL, NULL, 5, '2020-11-28 16:09:39'),
(15, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_c7fbe29b6aa380c5da99c5a5757fed6e.jpg', 9989, 200, 200, 'app/web/upload/medium/1_c7fbe29b6aa380c5da99c5a5757fed6e.jpg', 94514, 800, 800, 'app/web/upload/large/1_c7fbe29b6aa380c5da99c5a5757fed6e.jpg', 60247, 614, 461, 'app/web/upload/source/1_c7fbe29b6aa380c5da99c5a5757fed6e.jpg', 129241, 614, 461, 'hack5.jpg', 'During hacking', '', '', NULL, NULL, NULL, 6, '2020-11-28 16:10:00'),
(16, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_6ccd7c7a48e11c47088bc987d04ca165.jpg', 8972, 200, 200, 'app/web/upload/medium/1_6ccd7c7a48e11c47088bc987d04ca165.jpg', 73517, 800, 800, 'app/web/upload/large/1_6ccd7c7a48e11c47088bc987d04ca165.jpg', 49053, 614, 461, 'app/web/upload/source/1_6ccd7c7a48e11c47088bc987d04ca165.jpg', 106719, 614, 461, 'hack4.jpg', 'Hack started', '', '', NULL, NULL, NULL, 7, '2020-11-28 16:10:11'),
(17, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_411dd5a0cf087080e3eddf8eb986d08b.jpg', 8812, 200, 200, 'app/web/upload/medium/1_411dd5a0cf087080e3eddf8eb986d08b.jpg', 74648, 800, 800, 'app/web/upload/large/1_411dd5a0cf087080e3eddf8eb986d08b.jpg', 30993, 522, 275, 'app/web/upload/source/1_411dd5a0cf087080e3eddf8eb986d08b.jpg', 64049, 522, 275, 'hack1.jpg', 'Ugly git aint I', '', '', NULL, NULL, NULL, 8, '2020-11-28 16:10:17'),
(18, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_0bb7f75b0c91523735274eca4ac945c9.jpg', 34276, 200, 200, 'app/web/upload/medium/1_0bb7f75b0c91523735274eca4ac945c9.jpg', 324837, 800, 800, 'app/web/upload/large/1_0bb7f75b0c91523735274eca4ac945c9.jpg', 111093, 614, 461, 'app/web/upload/source/1_0bb7f75b0c91523735274eca4ac945c9.jpg', 57282, 614, 461, 'hack8.jpg', NULL, '', '', NULL, NULL, NULL, 9, '2020-11-28 16:10:24'),
(19, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_f3420f37cd372a603887c67746d8e4c3.jpg', 39445, 200, 200, 'app/web/upload/medium/1_f3420f37cd372a603887c67746d8e4c3.jpg', 380476, 800, 800, 'app/web/upload/large/1_f3420f37cd372a603887c67746d8e4c3.jpg', 134946, 614, 461, 'app/web/upload/source/1_f3420f37cd372a603887c67746d8e4c3.jpg', 74224, 614, 461, 'hack6.jpg', NULL, '', '', NULL, NULL, NULL, 10, '2020-11-28 16:10:40'),
(20, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_ce6fc659076ccb1f9029c453d6523243.jpg', 37867, 200, 200, 'app/web/upload/medium/1_ce6fc659076ccb1f9029c453d6523243.jpg', 361525, 800, 800, 'app/web/upload/large/1_ce6fc659076ccb1f9029c453d6523243.jpg', 259091, 1024, 768, 'app/web/upload/source/1_ce6fc659076ccb1f9029c453d6523243.jpg', 127807, 1024, 768, 'canopy2.jpg', NULL, '', '', NULL, NULL, NULL, 11, '2020-11-28 16:10:58'),
(21, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_6b1b0fe42c313dfcc1aa1f0d23df6a02.jpg', 10937, 200, 200, 'app/web/upload/medium/1_6b1b0fe42c313dfcc1aa1f0d23df6a02.jpg', 104985, 800, 800, 'app/web/upload/large/1_6b1b0fe42c313dfcc1aa1f0d23df6a02.jpg', 123170, 1024, 768, 'app/web/upload/source/1_6b1b0fe42c313dfcc1aa1f0d23df6a02.jpg', 284675, 1024, 768, 'canopy6.jpg', 'The new canopy', '', '', NULL, NULL, NULL, 12, '2020-11-28 16:11:10'),
(22, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_8fecae338101a76ec65d28dc5cea9389.jpg', 7581, 200, 200, 'app/web/upload/medium/1_8fecae338101a76ec65d28dc5cea9389.jpg', 35965, 800, 800, 'app/web/upload/large/1_8fecae338101a76ec65d28dc5cea9389.jpg', 4303, 133, 100, 'app/web/upload/source/1_8fecae338101a76ec65d28dc5cea9389.jpg', 8343, 133, 100, 'smallcockpit.jpg', 'New cockpit fitout', '', '', NULL, NULL, NULL, 13, '2020-11-28 16:11:31'),
(23, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_def39592ec6dcba4440d4fe2587d74ae.jpg', 8707, 200, 200, 'app/web/upload/medium/1_def39592ec6dcba4440d4fe2587d74ae.jpg', 73157, 800, 800, 'app/web/upload/large/1_def39592ec6dcba4440d4fe2587d74ae.jpg', 45579, 461, 614, 'app/web/upload/source/1_def39592ec6dcba4440d4fe2587d74ae.jpg', 130809, 461, 614, 'helm.jpg', 'New helm position', '', '', NULL, NULL, NULL, 14, '2020-11-28 16:11:40'),
(24, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_35d1273932d73d2d247480e30e6d0103.jpg', 31218, 200, 200, 'app/web/upload/medium/1_35d1273932d73d2d247480e30e6d0103.jpg', 309937, 800, 800, 'app/web/upload/large/1_35d1273932d73d2d247480e30e6d0103.jpg', 120736, 614, 461, 'app/web/upload/source/1_35d1273932d73d2d247480e30e6d0103.jpg', 58961, 614, 461, 'fuelshut.jpg', NULL, '', '', NULL, NULL, NULL, 15, '2020-11-28 16:11:49'),
(25, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_fdcb65938b69b2cfa679380fa60cc7db.jpg', 36493, 200, 200, 'app/web/upload/medium/1_fdcb65938b69b2cfa679380fa60cc7db.jpg', 348953, 800, 800, 'app/web/upload/large/1_fdcb65938b69b2cfa679380fa60cc7db.jpg', 132660, 614, 461, 'app/web/upload/source/1_fdcb65938b69b2cfa679380fa60cc7db.jpg', 68168, 614, 461, 'gasopen.jpg', NULL, '', '', NULL, NULL, NULL, 16, '2020-11-28 16:12:13'),
(26, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_1996309a4ce6fa920e41051773a1543a.jpg', 8339, 200, 200, 'app/web/upload/medium/1_1996309a4ce6fa920e41051773a1543a.jpg', 37362, 800, 800, 'app/web/upload/large/1_1996309a4ce6fa920e41051773a1543a.jpg', 4390, 133, 100, 'app/web/upload/source/1_1996309a4ce6fa920e41051773a1543a.jpg', 8454, 133, 100, 'small3.jpg', 'Cabin pic.', '', '', NULL, NULL, NULL, 17, '2020-11-28 16:12:21'),
(27, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_6345e08c1dfc76861264dad037e54783.jpg', 8073, 200, 200, 'app/web/upload/medium/1_6345e08c1dfc76861264dad037e54783.jpg', 72542, 800, 800, 'app/web/upload/large/1_6345e08c1dfc76861264dad037e54783.jpg', 42533, 614, 461, 'app/web/upload/source/1_6345e08c1dfc76861264dad037e54783.jpg', 124573, 614, 461, 'fridgeopen.jpg', 'A sneaky fridge', '', '', NULL, NULL, NULL, 18, '2020-11-28 16:12:39'),
(28, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_8cc66751d9567c596569d6699dc5d573.jpg', 35822, 200, 200, 'app/web/upload/medium/1_8cc66751d9567c596569d6699dc5d573.jpg', 355843, 800, 800, 'app/web/upload/large/1_8cc66751d9567c596569d6699dc5d573.jpg', 60926, 384, 288, 'app/web/upload/source/1_8cc66751d9567c596569d6699dc5d573.jpg', 32255, 384, 288, 'cockpit9.jpg', NULL, '', '', NULL, NULL, NULL, 19, '2020-11-28 16:12:53'),
(29, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_db8278965daef7f2ad84ee110730e972.jpg', 29236, 200, 200, 'app/web/upload/medium/1_db8278965daef7f2ad84ee110730e972.jpg', 275903, 800, 800, 'app/web/upload/large/1_db8278965daef7f2ad84ee110730e972.jpg', 45614, 384, 288, 'app/web/upload/source/1_db8278965daef7f2ad84ee110730e972.jpg', 23277, 384, 288, 'cockpit10.jpg', NULL, '', '', NULL, NULL, NULL, 20, '2020-11-28 16:12:59'),
(30, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_bdbc7d1bbd3954b31369ebbb3a1fc9c7.jpg', 32034, 200, 200, 'app/web/upload/medium/1_bdbc7d1bbd3954b31369ebbb3a1fc9c7.jpg', 308115, 800, 800, 'app/web/upload/large/1_bdbc7d1bbd3954b31369ebbb3a1fc9c7.jpg', 51918, 288, 384, 'app/web/upload/source/1_bdbc7d1bbd3954b31369ebbb3a1fc9c7.jpg', 27611, 288, 384, 'cockpit11.jpg', NULL, '', '', NULL, NULL, NULL, 21, '2020-11-28 16:13:17'),
(31, 1, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/1_112b0e56c82951e62487547d4bb92f45.jpg', 34729, 200, 200, 'app/web/upload/medium/1_112b0e56c82951e62487547d4bb92f45.jpg', 345360, 800, 800, 'app/web/upload/large/1_112b0e56c82951e62487547d4bb92f45.jpg', 125089, 614, 461, 'app/web/upload/source/1_112b0e56c82951e62487547d4bb92f45.jpg', 64256, 614, 461, 'cruisin.jpg', NULL, '', '', NULL, NULL, NULL, 22, '2020-11-28 16:15:26'),
(32, 4, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/4_970ac841e739f5c7bbf4b7dd47187715.jpg', 11124, 200, 200, 'app/web/upload/medium/4_970ac841e739f5c7bbf4b7dd47187715.jpg', 111633, 800, 800, 'app/web/upload/large/4_970ac841e739f5c7bbf4b7dd47187715.jpg', 218961, 1306, 870, 'app/web/upload/source/4_970ac841e739f5c7bbf4b7dd47187715.jpg', 570734, 1306, 870, 'SS850668.JPG', 'Leo Magill', '', '', 'Moored at St.Neots Marina.', NULL, NULL, 1, '2020-12-12 17:30:33'),
(33, 4, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/4_146bfa83c9d68cbed4fe03f51d6a8e4d.jpg', 8880, 200, 200, 'app/web/upload/medium/4_146bfa83c9d68cbed4fe03f51d6a8e4d.jpg', 87730, 800, 800, 'app/web/upload/large/4_146bfa83c9d68cbed4fe03f51d6a8e4d.jpg', 112860, 1024, 768, 'app/web/upload/source/4_146bfa83c9d68cbed4fe03f51d6a8e4d.jpg', 349428, 1024, 768, 'leo_on_trailer.jpg', 'First arrival', '', '', 'This was Leo first arriving at Buckden marina when we bought it, this was the easiest place to get it launched.\r\n2006', NULL, NULL, 2, '2020-12-12 17:30:57'),
(34, 4, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/4_762f56c8492f9a4780ed5a0ae0fdd4c9.jpg', 12480, 200, 200, 'app/web/upload/medium/4_762f56c8492f9a4780ed5a0ae0fdd4c9.jpg', 137978, 800, 800, 'app/web/upload/large/4_762f56c8492f9a4780ed5a0ae0fdd4c9.jpg', 183986, 1024, 768, 'app/web/upload/source/4_762f56c8492f9a4780ed5a0ae0fdd4c9.jpg', 492091, 1024, 768, 'crane_in_1.jpg', 'The first lift in', '', '', 'The launch at Buckden.\r\nThis was autumn 2006.', NULL, NULL, 3, '2020-12-12 17:31:04'),
(35, 4, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/4_8c372f093bf9f67cae9bd5f27ba9232d.jpg', 12176, 200, 200, 'app/web/upload/medium/4_8c372f093bf9f67cae9bd5f27ba9232d.jpg', 153292, 800, 800, 'app/web/upload/large/4_8c372f093bf9f67cae9bd5f27ba9232d.jpg', 290595, 1200, 900, 'app/web/upload/source/4_8c372f093bf9f67cae9bd5f27ba9232d.jpg', 786421, 1200, 900, 'SS851156.JPG', 'On the Great Ouse', '', '', NULL, NULL, NULL, 4, '2020-12-12 17:31:28'),
(36, 4, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/4_c4d0fd81fa02ad13890932579bc6140d.jpg', 13576, 200, 200, 'app/web/upload/medium/4_c4d0fd81fa02ad13890932579bc6140d.jpg', 146504, 800, 800, 'app/web/upload/large/4_c4d0fd81fa02ad13890932579bc6140d.jpg', 217750, 1024, 768, 'app/web/upload/source/4_c4d0fd81fa02ad13890932579bc6140d.jpg', 511969, 1024, 768, 'SS852252.JPG', 'Wells next the sea', '', '', 'This was the first coastal place we visited, although not on this run.', NULL, NULL, 5, '2020-12-12 17:32:05'),
(37, 4, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/4_4241d814500adce02edc57aad3412280.jpg', 7215, 200, 200, 'app/web/upload/medium/4_4241d814500adce02edc57aad3412280.jpg', 72523, 800, 800, 'app/web/upload/large/4_4241d814500adce02edc57aad3412280.jpg', 145697, 1300, 867, 'app/web/upload/source/4_4241d814500adce02edc57aad3412280.jpg', 318861, 1300, 867, 'SS852733.JPG', 'Trent bridge', '', '', 'We took Leo to Nottingham via the wash and witham/fossdyke in summer 2011.', NULL, NULL, 6, '2020-12-12 17:32:05'),
(38, 4, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/4_72f83d9b05666c192e8059e8198f1c19.jpg', 9022, 200, 200, 'app/web/upload/medium/4_72f83d9b05666c192e8059e8198f1c19.jpg', 89840, 800, 800, 'app/web/upload/large/4_72f83d9b05666c192e8059e8198f1c19.jpg', 176323, 1300, 867, 'app/web/upload/source/4_72f83d9b05666c192e8059e8198f1c19.jpg', 374603, 1300, 867, 'SS852773.JPG', 'The glory hole', '', '', 'You just can\'t go through Lincoln without a piccie of the glory hole (High bridge).', NULL, NULL, 7, '2020-12-12 17:32:06'),
(39, 4, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/4_52819a3f4cc45b19a31982a0117fbe92.jpg', 7478, 200, 200, 'app/web/upload/medium/4_52819a3f4cc45b19a31982a0117fbe92.jpg', 74401, 800, 800, 'app/web/upload/large/4_52819a3f4cc45b19a31982a0117fbe92.jpg', 154757, 1300, 975, 'app/web/upload/source/4_52819a3f4cc45b19a31982a0117fbe92.jpg', 353443, 1300, 975, 'SS853147.JPG', 'Fye bridge Norwich', '', '', 'This was a trip into Norwich in 2012 when we did a Broads/East coast summer, we moored at Loddon for 3 months before returning to Gt.Ouse.', NULL, NULL, 8, '2020-12-12 17:32:07'),
(40, 4, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/4_c22f01eba475558d32de58dd88a1e795.jpg', 8930, 200, 200, 'app/web/upload/medium/4_c22f01eba475558d32de58dd88a1e795.jpg', 98529, 800, 800, 'app/web/upload/large/4_c22f01eba475558d32de58dd88a1e795.jpg', 191516, 1300, 975, 'app/web/upload/source/4_c22f01eba475558d32de58dd88a1e795.jpg', 425689, 1300, 975, 'SS853198.JPG', 'Maldon, Essex', '', '', 'How nicked the bloody river??\r\nNo problem there\'s 2 pubs very close.\r\nWe pulled forward at high water as a thames barge had left the bottom flatter there.', NULL, NULL, 9, '2020-12-12 17:32:08'),
(41, 4, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/4_19167825fd87d2686f67b6abd7377664.jpg', 9300, 200, 200, 'app/web/upload/medium/4_19167825fd87d2686f67b6abd7377664.jpg', 109557, 800, 800, 'app/web/upload/large/4_19167825fd87d2686f67b6abd7377664.jpg', 222489, 1300, 975, 'app/web/upload/source/4_19167825fd87d2686f67b6abd7377664.jpg', 512627, 1300, 975, 'SS853237.JPG', 'Rowhedge, Essex', '', '', 'On the river colne in 2012, yet again 2 pubs nearby.....', NULL, NULL, 10, '2020-12-12 17:32:08'),
(42, 4, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/4_c2d630d7da2afeab9d421dff005cc3fa.jpg', 13853, 200, 200, 'app/web/upload/medium/4_c2d630d7da2afeab9d421dff005cc3fa.jpg', 144697, 800, 800, 'app/web/upload/large/4_c2d630d7da2afeab9d421dff005cc3fa.jpg', 182355, 1024, 768, 'app/web/upload/source/4_c2d630d7da2afeab9d421dff005cc3fa.jpg', 481980, 1024, 768, 'below_cockpit_4.jpg', 'Urrrggh!', '', '', 'What the bilge looked like when we got it.', NULL, NULL, 11, '2020-12-12 17:32:09'),
(43, 4, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/4_294038cc767f8c4681a1d51e9fcb9d07.jpg', 12144, 200, 200, 'app/web/upload/medium/4_294038cc767f8c4681a1d51e9fcb9d07.jpg', 105525, 800, 800, 'app/web/upload/large/4_294038cc767f8c4681a1d51e9fcb9d07.jpg', 133398, 1024, 768, 'app/web/upload/source/4_294038cc767f8c4681a1d51e9fcb9d07.jpg', 390281, 1024, 768, 'calorifier_2.jpg', 'That\'s better.', '', '', 'What the bilge ended up like, complete with new twin coil calorifier.', NULL, NULL, 12, '2020-12-12 17:32:10'),
(45, 4, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/4_e75fb4d25957ecaea526365f48f011ba.jpg', 8559, 200, 200, 'app/web/upload/medium/4_e75fb4d25957ecaea526365f48f011ba.jpg', 88296, 800, 800, 'app/web/upload/large/4_e75fb4d25957ecaea526365f48f011ba.jpg', 170990, 1300, 975, 'app/web/upload/source/4_e75fb4d25957ecaea526365f48f011ba.jpg', 370810, 1300, 975, 'File1323.JPG', 'Orwell bridge', '', '', 'A trip to Ipswitch in 2010, just did the turn round and went back down river to shotley.', NULL, NULL, 14, '2020-12-12 17:32:11'),
(47, 4, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/4_5ecc65814c91b2b85025ffae9bbc4776.jpg', 8383, 200, 200, 'app/web/upload/medium/4_5ecc65814c91b2b85025ffae9bbc4776.jpg', 75561, 800, 800, 'app/web/upload/large/4_5ecc65814c91b2b85025ffae9bbc4776.jpg', 140609, 1306, 870, 'app/web/upload/source/4_5ecc65814c91b2b85025ffae9bbc4776.jpg', 401058, 1306, 870, 'SS850611.JPG', 'New engine bearers', '', '', 'Engine bay after fitting new bearers, the originals were shaking around under the load of the old BMC 2.52\'s as they were rotten.', NULL, NULL, 16, '2020-12-12 17:32:13'),
(48, 4, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/4_a3890c1e250a9dfed1b9e64977e20c99.jpg', 15785, 200, 200, 'app/web/upload/medium/4_a3890c1e250a9dfed1b9e64977e20c99.jpg', 152049, 800, 800, 'app/web/upload/large/4_a3890c1e250a9dfed1b9e64977e20c99.jpg', 272689, 1306, 870, 'app/web/upload/source/4_a3890c1e250a9dfed1b9e64977e20c99.jpg', 687562, 1306, 870, 'SS850624.JPG', 'New engines', '', '', 'Replaced old BMC with a pair of self marinised and rebuilt peugeot XUD9\'s.', NULL, NULL, 17, '2020-12-12 17:32:13'),
(50, 4, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/4_f54e1ca9adf27b81d61e973f92d3fe6a.jpg', 11804, 200, 200, 'app/web/upload/medium/4_f54e1ca9adf27b81d61e973f92d3fe6a.jpg', 110583, 800, 800, 'app/web/upload/large/4_f54e1ca9adf27b81d61e973f92d3fe6a.jpg', 189891, 1200, 900, 'app/web/upload/source/4_f54e1ca9adf27b81d61e973f92d3fe6a.jpg', 558250, 1200, 900, 'SS851148.JPG', 'The helm', '', '', 'Rebuilt helm panel with navigation aids.', NULL, NULL, 19, '2020-12-12 17:32:15'),
(52, 4, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/4_7308734364ce921ea0b0f1f24d819849.jpg', 10393, 200, 200, 'app/web/upload/medium/4_7308734364ce921ea0b0f1f24d819849.jpg', 105591, 800, 800, 'app/web/upload/large/4_7308734364ce921ea0b0f1f24d819849.jpg', 207512, 1306, 979, 'app/web/upload/source/4_7308734364ce921ea0b0f1f24d819849.jpg', 549539, 1306, 979, 'SS851529.JPG', 'Hull marina', '', '', 'Leo moored in Hull marina in 2009, came via Wells next the sea.\r\nWells to Hull was 11 hour non stop run, 17 miles from shore at one point.', NULL, NULL, 21, '2020-12-12 17:32:17'),
(53, 4, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/4_09c403e2c21fabe2ae0bb77c4c6a87d5.jpg', 6470, 200, 200, 'app/web/upload/medium/4_09c403e2c21fabe2ae0bb77c4c6a87d5.jpg', 53849, 800, 800, 'app/web/upload/large/4_09c403e2c21fabe2ae0bb77c4c6a87d5.jpg', 102773, 1306, 979, 'app/web/upload/source/4_09c403e2c21fabe2ae0bb77c4c6a87d5.jpg', 363812, 1306, 979, 'SS851548.JPG', 'Humber bridge', '', '', 'On the way from Hull to Naburn.', NULL, NULL, 22, '2020-12-12 17:32:18'),
(54, 4, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/4_a04f297210a80898752dbbba0da669e9.jpg', 8483, 200, 200, 'app/web/upload/medium/4_a04f297210a80898752dbbba0da669e9.jpg', 88655, 800, 800, 'app/web/upload/large/4_a04f297210a80898752dbbba0da669e9.jpg', 181273, 1306, 979, 'app/web/upload/source/4_a04f297210a80898752dbbba0da669e9.jpg', 501097, 1306, 979, 'SS851591.JPG', 'Ouse bridge York', '', '', 'York is well worth a visit.', NULL, NULL, 23, '2020-12-12 17:32:18'),
(55, 4, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/4_30240a816a3f3c9196514d5cb16543cb.jpg', 12750, 200, 200, 'app/web/upload/medium/4_30240a816a3f3c9196514d5cb16543cb.jpg', 145500, 800, 800, 'app/web/upload/large/4_30240a816a3f3c9196514d5cb16543cb.jpg', 283766, 1306, 979, 'app/web/upload/source/4_30240a816a3f3c9196514d5cb16543cb.jpg', 726005, 1306, 979, 'SS851593.JPG', 'Kings Staithe, York', '', '', 'Moored by the Kings Arms pub.', NULL, NULL, 24, '2020-12-12 17:32:19'),
(56, 5, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/5_a839af911681ed4074df12b44afbd5a6.jpg', 11951, 200, 200, 'app/web/upload/medium/5_a839af911681ed4074df12b44afbd5a6.jpg', 125683, 800, 800, 'app/web/upload/large/5_a839af911681ed4074df12b44afbd5a6.jpg', 1002978, 3264, 2448, 'app/web/upload/source/5_a839af911681ed4074df12b44afbd5a6.jpg', 3683334, 3264, 2448, 'SS853797.JPG', 'Just delivered', '', '', 'This was the first time we saw Snowbird under our ownership, it had just been launched at Bell boats in Brundall on the Norfolk Broads.', NULL, NULL, 2, '2020-12-12 20:37:57'),
(57, 5, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/5_b6b70bcd2c7076206097e8908f8ba92c.jpg', 12585, 200, 200, 'app/web/upload/medium/5_b6b70bcd2c7076206097e8908f8ba92c.jpg', 126361, 800, 800, 'app/web/upload/large/5_b6b70bcd2c7076206097e8908f8ba92c.jpg', 1067041, 3264, 2448, 'app/web/upload/source/5_b6b70bcd2c7076206097e8908f8ba92c.jpg', 3925157, 3264, 2448, 'SS853810.JPG', 'The Beasts!', '', '', 'The fun bit, twin Volvo Penta TMD41A\'s rated at 150Hp each doing the smelly spinny bit that makes it all move.', NULL, NULL, 3, '2020-12-12 20:38:00'),
(58, 5, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/5_1f431098f9d1310a7728c814c48055d4.jpg', 8793, 200, 200, 'app/web/upload/medium/5_1f431098f9d1310a7728c814c48055d4.jpg', 77102, 800, 800, 'app/web/upload/large/5_1f431098f9d1310a7728c814c48055d4.jpg', 64620, 800, 598, 'app/web/upload/source/5_1f431098f9d1310a7728c814c48055d4.jpg', 141553, 800, 598, '439197_4.jpg', 'Saloon', '', '', 'Helm and Navigator seats are folded down under the seats to make a slobby saloon area.', NULL, NULL, 4, '2020-12-12 20:38:03'),
(59, 5, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/5_28334c9b65b2cc7b0478a16a5ffc0401.jpg', 6888, 200, 200, 'app/web/upload/medium/5_28334c9b65b2cc7b0478a16a5ffc0401.jpg', 54638, 800, 800, 'app/web/upload/large/5_28334c9b65b2cc7b0478a16a5ffc0401.jpg', 46552, 800, 598, 'app/web/upload/source/5_28334c9b65b2cc7b0478a16a5ffc0401.jpg', 109518, 800, 598, '439197_5.jpg', 'The galley', '', '', 'Where the coffee and bacon butties appear from.', NULL, NULL, 5, '2020-12-12 20:38:04'),
(60, 5, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/5_3231e534e37e1e44b2ee477502225bbc.jpg', 5777, 200, 200, 'app/web/upload/medium/5_3231e534e37e1e44b2ee477502225bbc.jpg', 65575, 800, 800, 'app/web/upload/large/5_3231e534e37e1e44b2ee477502225bbc.jpg', 79545, 800, 1071, 'app/web/upload/source/5_3231e534e37e1e44b2ee477502225bbc.jpg', 194971, 800, 1071, '439197_6.jpg', 'The bog', '', '', 'Where the coffee and bacon butties disappear from.......', NULL, NULL, 6, '2020-12-12 20:38:04'),
(61, 5, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/5_193dcca52c006fad96c0bf0758d06149.jpg', 5932, 200, 200, 'app/web/upload/medium/5_193dcca52c006fad96c0bf0758d06149.jpg', 69496, 800, 800, 'app/web/upload/large/5_193dcca52c006fad96c0bf0758d06149.jpg', 83206, 800, 1071, 'app/web/upload/source/5_193dcca52c006fad96c0bf0758d06149.jpg', 202261, 800, 1071, '439197_7.jpg', 'Dinette', '', '', 'The dinette in the cabin is fairly cramped, slobing is done in the saloon.', NULL, NULL, 7, '2020-12-12 20:38:05'),
(62, 5, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/5_92c9aeb562992f5a44bbbb06d016313a.jpg', 10952, 200, 200, 'app/web/upload/medium/5_92c9aeb562992f5a44bbbb06d016313a.jpg', 107742, 800, 800, 'app/web/upload/large/5_92c9aeb562992f5a44bbbb06d016313a.jpg', 1408663, 4128, 3096, 'app/web/upload/source/5_92c9aeb562992f5a44bbbb06d016313a.jpg', 5546398, 4128, 3096, '20171020_192958.jpg', 'Wrong place', '', '', 'These should be under the floor not languishing at work, removed to replace the fuel tanks.', NULL, NULL, 8, '2020-12-12 20:38:06'),
(63, 5, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/5_f29c38d9b9432f9d1929215c0d9444a3.jpg', 10409, 200, 200, 'app/web/upload/medium/5_f29c38d9b9432f9d1929215c0d9444a3.jpg', 141639, 800, 800, 'app/web/upload/large/5_f29c38d9b9432f9d1929215c0d9444a3.jpg', 1912119, 4128, 3096, 'app/web/upload/source/5_f29c38d9b9432f9d1929215c0d9444a3.jpg', 6948094, 4128, 3096, '20171021_141028.jpg', 'Old fuel tanks', '', '', 'These where full of sludge and rust flakes and caused quite a few low power single engine sea entrances, they are 285 litres each.', NULL, NULL, 9, '2020-12-12 20:38:10'),
(64, 5, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/5_01d2bba7e57fc040c40a8049baa548f3.jpg', 10044, 200, 200, 'app/web/upload/medium/5_01d2bba7e57fc040c40a8049baa548f3.jpg', 96999, 800, 800, 'app/web/upload/large/5_01d2bba7e57fc040c40a8049baa548f3.jpg', 1182885, 4128, 3096, 'app/web/upload/source/5_01d2bba7e57fc040c40a8049baa548f3.jpg', 5206792, 4128, 3096, '20171021_145354.jpg', 'Wot no engines', '', '', 'This is a sight I never want to see again, that was bloody hard work at 1/2 ton each and having to go up sideways through the sunroof with 1\" clearance.\r\nAll to change the fuel tanks.', NULL, NULL, 10, '2020-12-12 20:38:14'),
(65, 5, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/5_e956dddc7559c8dd7cd88d55425b3e89.jpg', 10156, 200, 200, 'app/web/upload/medium/5_e956dddc7559c8dd7cd88d55425b3e89.jpg', 115017, 800, 800, 'app/web/upload/large/5_e956dddc7559c8dd7cd88d55425b3e89.jpg', 1107442, 3264, 2448, 'app/web/upload/source/5_e956dddc7559c8dd7cd88d55425b3e89.jpg', 3992751, 3264, 2448, 'barkeel.jpg', '\'Jersey keel\'', '', '', 'The boat was once on a drying mooring in Jersey so had this keel added on to protect the props, it also had yacht legs to keep it upright.\r\nI removed it and filled the bolt holes to reduce drag.', NULL, NULL, 11, '2020-12-12 20:38:19'),
(66, 5, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/5_7360975575e334cc89334305178e95d7.jpg', 7596, 200, 200, 'app/web/upload/medium/5_7360975575e334cc89334305178e95d7.jpg', 77620, 800, 800, 'app/web/upload/large/5_7360975575e334cc89334305178e95d7.jpg', 623940, 2592, 1936, 'app/web/upload/source/5_7360975575e334cc89334305178e95d7.jpg', 2220320, 2592, 1936, 'boat and mike-donna 010.JPG', 'Aft deck', '', '', 'The aft deck is fairly spacious, under the floor is a lazarette, effectively my shed.', NULL, NULL, 12, '2020-12-12 20:38:22'),
(67, 5, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/5_fe1e247d31a5315143bb84ad0fbcee0b.jpg', 5703, 200, 200, 'app/web/upload/medium/5_fe1e247d31a5315143bb84ad0fbcee0b.jpg', 67519, 800, 800, 'app/web/upload/large/5_fe1e247d31a5315143bb84ad0fbcee0b.jpg', 1246614, 4160, 3120, 'app/web/upload/source/5_fe1e247d31a5315143bb84ad0fbcee0b.jpg', 4645672, 4160, 3120, 'IMG_20160907_143054.jpg', 'The wake shot', '', '', 'Looks good but uses about 50 litres of diesel an hour doing that, fun though.', NULL, NULL, 13, '2020-12-12 20:42:36'),
(68, 5, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/5_529063a492ea79be9c591d4f6f8e7754.jpg', 10819, 200, 200, 'app/web/upload/medium/5_529063a492ea79be9c591d4f6f8e7754.jpg', 125166, 800, 800, 'app/web/upload/large/5_529063a492ea79be9c591d4f6f8e7754.jpg', 1793869, 4160, 3120, 'app/web/upload/source/5_529063a492ea79be9c591d4f6f8e7754.jpg', 5223132, 4160, 3120, 'IMG_20160930_145844.jpg', 'The spinny bits', '', '', 'Lifting out to remove the keel, 32 half inch holes take some filling.', NULL, NULL, 14, '2020-12-12 20:42:40'),
(69, 5, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/5_d63dc0297dc70ee3acc88e6b62177853.jpg', 14112, 200, 200, 'app/web/upload/medium/5_d63dc0297dc70ee3acc88e6b62177853.jpg', 208177, 800, 800, 'app/web/upload/large/5_d63dc0297dc70ee3acc88e6b62177853.jpg', 3052574, 4160, 3120, 'app/web/upload/source/5_d63dc0297dc70ee3acc88e6b62177853.jpg', 8426335, 4160, 3120, 'IMG_20161002_132639.jpg', 'Wreckage', '', '', 'The remains of the keel, anyone need some stainless tube??', NULL, NULL, 15, '2020-12-12 20:42:44'),
(70, 5, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/5_61732fdcab51c27b8354d5d750820985.jpg', 9388, 200, 200, 'app/web/upload/medium/5_61732fdcab51c27b8354d5d750820985.jpg', 100068, 800, 800, 'app/web/upload/large/5_61732fdcab51c27b8354d5d750820985.jpg', 1401204, 4160, 3120, 'app/web/upload/source/5_61732fdcab51c27b8354d5d750820985.jpg', 4986571, 4160, 3120, 'IMG_20161009_111447.jpg', 'On the hard', '', '', 'I say hard but mean grass and rabbit holes.', NULL, NULL, 16, '2020-12-12 20:42:49'),
(71, 5, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/5_6b84c11375ef2a85b0396d4f2512a02a.jpg', 8496, 200, 200, 'app/web/upload/medium/5_6b84c11375ef2a85b0396d4f2512a02a.jpg', 92331, 800, 800, 'app/web/upload/large/5_6b84c11375ef2a85b0396d4f2512a02a.jpg', 1311595, 4160, 3120, 'app/web/upload/source/5_6b84c11375ef2a85b0396d4f2512a02a.jpg', 4648475, 4160, 3120, 'IMG_20170408_132528.jpg', 'Snowbird at Surlingham', '', '', 'Moored at the best pub on the Broads, the Ferryhouse at Surlingham, it does that a lot.', NULL, NULL, 1, '2020-12-12 20:42:53'),
(72, 5, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/5_601ddaf213c1d83bd986ce1a4caeca43.jpg', 8076, 200, 200, 'app/web/upload/medium/5_601ddaf213c1d83bd986ce1a4caeca43.jpg', 108476, 800, 800, 'app/web/upload/large/5_601ddaf213c1d83bd986ce1a4caeca43.jpg', 1636838, 4160, 3120, 'app/web/upload/source/5_601ddaf213c1d83bd986ce1a4caeca43.jpg', 5137567, 4160, 3120, 'IMG_20170826_184453.jpg', 'Leo & Snowbird', '', '', 'The old and new meet at a mooring.', NULL, NULL, 17, '2020-12-12 20:42:57'),
(73, 5, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/5_0ebd02e68a31730532f593b2bf425cf6.jpg', 6560, 200, 200, 'app/web/upload/medium/5_0ebd02e68a31730532f593b2bf425cf6.jpg', 75162, 800, 800, 'app/web/upload/large/5_0ebd02e68a31730532f593b2bf425cf6.jpg', 95867, 1024, 768, 'app/web/upload/source/5_0ebd02e68a31730532f593b2bf425cf6.jpg', 195950, 1024, 768, 'IMG-20180511-WA0001.jpg', 'On the plane', '', '', 'Just off the coast of Southwold, taken by rib out playing.', NULL, NULL, 18, '2020-12-12 20:43:01'),
(74, 5, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/5_421b7758549c995e8ae9fcb217e48bfa.jpg', 8888, 200, 200, 'app/web/upload/medium/5_421b7758549c995e8ae9fcb217e48bfa.jpg', 90190, 800, 800, 'app/web/upload/large/5_421b7758549c995e8ae9fcb217e48bfa.jpg', 847681, 3264, 2448, 'app/web/upload/source/5_421b7758549c995e8ae9fcb217e48bfa.jpg', 3659495, 3264, 2448, 'SS853775.JPG', 'Survey', '', '', 'Out for pre-purchase survey at Gt.Heck marina, next sight was at Bell boats on the broads.', NULL, NULL, 19, '2020-12-12 20:43:01'),
(76, 7, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/7_771451f305edb9687ba86785fc95f99b.jpg', 10883, 200, 200, 'app/web/upload/medium/7_771451f305edb9687ba86785fc95f99b.jpg', 116126, 800, 800, 'app/web/upload/large/7_771451f305edb9687ba86785fc95f99b.jpg', 99467, 960, 528, 'app/web/upload/source/7_771451f305edb9687ba86785fc95f99b.jpg', 218153, 960, 528, '117327797_3252218548172147_5981345687685797385_n.jpg', 'Eran', '', '', NULL, NULL, NULL, 1, '2020-12-15 16:05:05'),
(78, 9, 'pjGalleryMain', NULL, 'image/jpeg', 'app/web/upload/small/9_3412b4f19054a66c0ae6f6fc45271a3c.jpg', 28187, 200, 200, 'app/web/upload/medium/9_3412b4f19054a66c0ae6f6fc45271a3c.jpg', 276008, 800, 800, 'app/web/upload/large/9_3412b4f19054a66c0ae6f6fc45271a3c.jpg', 81653, 629, 288, 'app/web/upload/source/9_3412b4f19054a66c0ae6f6fc45271a3c.jpg', 77417, 629, 288, 'summer breeze (2).jpg', NULL, '', '', NULL, NULL, NULL, 1, '2020-12-17 12:40:26');

Options: ReplyQuote


Subject
Written By
Posted
Re: Select first record of each ID mysql5.6
December 17, 2020 12:01PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.