Divers UK (International) Ltd

 

 

HSE Registered Commercial Diving Contractor

Temporary Dams and Silt Curtains

Safety Boat Cover and Services

Pontoons and Work Platforms

PASMA Access Towers

Rescue RIB Hire and Charter

Confined Space Access, Entry and Rescue

Remotely Operated Vehicle (ROV and UAV)

Commercial Work Boat Charter

Marine Engineering

Civil Engineering

Specialist Crew Recruitment & Placement

Professional Diving Company

Commercial Divers & Diving Services

 

 

E-Mail:

This e-mail address is being protected from spambots. You need JavaScript enabled to view it.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Some of the Sites we cover:

bridges, culverts, jetties, ports, rivers, inland waterways, reservoirs, canals, lakes, harbours, marine structures, coastal estuaries, pipelines, oil rigs, offshore platforms, dolphin berths, moorings, swimming pools, aeration tanks, aeration pipes, pontoons, water tanks, chemical tanks, power stations, offshore windfarms, sub-sea turbines, pumping stations, dams, outfalls, fuel tanks, river walls, intakes, sewage plants, ships, ships holds, shipping, vessels, weirs, locks, lock gates, lock chambers, aprons, retaining walls, tidal barrages, mooring chains, well heads, stingers, syphons, construction sites, docks, water treatment works, hulls, propellers, rudder, stern gear, ocean, sea, yachts, power boats, racing yachts, bed material, pumps, scaffolding, penstocks, sluices

 

Some of the Locations we cover:

bedfordshire, berkshire, buckinghamshire, cambridgeshire, cheshire, cleveland, cornwall, county durham, cumbria, derbyshire, devon, dorset, east riding of yorkshire, east sussex, essex, gloucestershire, greater london, greater manchester, hampshire, herefordshire, hertfordshire, isle of wight, isles of scilly, kent, lancashire, leicestershire, lincolnshire, merseyside, norfolk, north yorkshire, northamptonshire, northumberland, nottinghamshire, oxfordshire, rutland, shropshire, somerset, south yorkshire, staffordshire, suffolk, surrey, tyne and wear, warwickshire, west midlands, west sussex, west yorkshire, wiltshire, worcestershire, birmingham, leeds, sheffield, cornwall, county durham, bradford, manchester, wiltshire, liverpool, bristol, kirklees, cheshire east, croydon, east riding of yorkshire, barnet, cheshire west, chester, wakefield, northumberland, coventry, wirral, ealing, wigan, dudley, bromley, leicester, shropshire, nottingham, doncaster, sandwell, enfield, wandsworth, stockport, sunderland, southwark, sefton, lambeth, newcastle upon tyne, brent, bolton, lewisham, hull, south gloucestershire, redbridge, brighton and hove, walsall, central bedfordshire, rotherham, medway, hillingdon, plymouth, newham, stoke on trent, derby, wolverhampton, westminster, camden, southampton, milton keynes, havering, haringey, barnsley, bexley, waltham forest, greenwich, hounslow, salford, tower hamlets, oldham, harrow, tameside, trafford, hackney, north somerset, rochdale, solihull, northampton, calderdale, merton, portsmouth, north tyneside, warrington, york, swindon, stockton on tees, luton, islington, gateshead, sutton, bury, colchester, bath and north east somerset, kensington and chelsea, richmond upon thames, herefordshire, st helens, aylesbury vale, new forest, basildon, hammersmith and fulham, huntingdonshire, barking and dagenham, chelmsford, charnwood, southend on sea, peterborough, bournemouth, telford and wrekin, basingstoke and deane, wycombe, harrogate, north lincolnshire, kingston upon thames, wokingham, south somerset, north east lincolnshire, bedford, oxford, west berkshire, thurrock, south tyneside, knowsley, canterbury, tendring, arun, reading, maidstone, king's lynn and west norfolk, lancaster, wealden, windsor and maidenhead, braintree, blackpool, east lindsey, blackburn with darwen, isle of wight, dacorum, redcar and cleveland, south cambridgeshire, middlesbrough, poole, cherwell, norwich, warwick, guildford, east hertfordshire, reigate and banstead, torbay, st albans, east devon, elmbridge, south kensington, preston, swale, breckland, mid sussex, horsham, thanet, south oxfordshire, teignbridge, suffolk coastal, stafford, newcastle under lyme, epping forest, north hertfordshire, exeter, broadland, cambridge, ipswich, nuneaton and bedworth, slough, amber valley, eastleigh, halton, south norfolk, stratford on avon, waverley, waveney, havant, wychavon, tonbridge and malling, vale of white horse, ashfield, test valley, gloucester, sevenoaks, bracknell forest, ashford, newark and sherwood, sedgemoor, winchester, bassetlaw, gedling, broxtowe, cheltenham, east hampshire, erewash, wyre, stroud, chichester, fareham, mendip, rushcliffe, west lancashire, east staffordshire, taunton deane, scarborough, welwyn hatfield, tunbridge wells, south ribble, dover, south staffordshire, north kesteven, hinckley and bosworth, chorley, south lakeland, carlisle, st edmundsbury, west oxfordshire, north norfolk, crawley, chesterfield, mandfield, darlington, worthing, shepway, wyre forest, hertsmere, north east derbyshire, gravesham, lichfield, west dorset, eastbourne, staffordshire moorlands, lewes, cannock chase, mid suffolk, allerdale, great yarmouth, worcester, blaby, high peak, bromsgrove, south derbyshire, north devon, woking, dartford, fenland, rugby, hartlepool, spelthorne, south northamptonshire, chiltern, north west leicestershire, kettering, hart, broxbourne, pendle, castle point, rushmoor, west lindsey, rother, lincoln, three rivers, burnley, hambleton, babergh, hastings, east northamptonshire, east dorset, cotswold, south hams, tandridge, south holland, surrey heath, runnymede, rochford, harborough, east cambridgeshire, selby, mole valley, forest of dean, hyndburn, watford, stevenage, gosport, redditch, daventry, tewkesbury, harlow, mid devon, fylde, wellingborough, tamworth, malvern hills, bolsover, uttlesford, brentwood, epson and ewell, barrow in furness, derbyshire dales, copeland, north dorset, rossendale, torridge, weymouth and portland, south bucks, forest heath, maldon, north warwickshire, adur, ribble valley, boston, oadby and wigston, craven, corby, ryedale, west devon, eden, richmondshire, melton, purbeck, christchurch, rutland, west somerset, city of london, isles of scilly, london, brimingham, manchester, liverpool, newcastle, nottingham, sheffield, leeds, bristol, leicester, portsmouth, bradford, bournemouth, reading, huddersfield, middlesbrough, stoke, coventry, birkenhead, southampton, hull, sunderland, wigan, brighton, southend, preston, blackpool, bolton, aldershot, plymouth, luton, chatham, derby, barnsley, northampton, norwich, milton keynes, worthing, crawley, rochdale, warrington, mansfield, swindon, burnley, ipswich, osford, wakefield, grimsby, york, telford, doncaster, peterborough, gloucester, blackburn, cambridge, hastings, Abingdon, Accrington, Ashford, Avonmouth, Aylesbury, Badminton, Bagshot, Banbury, Birmingham, Bangor, Aviemore, Axminster, Acton, Adlington, Alcester, Barnsley, Barnstaple, Basingstoke, Aldeburgh, Bedford, Belfast, Aldershot, Alford, Alfreton, Brecon Beacons, Alnwick, Alsager, Alston, Alton, London, Altrincham, Amble, Ambleside, Amersham, Amesbury, Ampthill, Andover, Appleby, Arlesey, Arundel, Ashbourne, Brighton, Ashburton, Ashby, Ashford, Ashington, Askem, Eastbourne, Aspatria, Atherstone, Attleborough, Axbridge, Axminster, Folkstone, Aylesbury, Bacup, Aylsham, Bakewell, Banbury, Barking, Barnard, Dover, Barnes, Barnet, Barnoldswick, Beaconsfield, Beckenham, Bedford, Berkhamsted, Bexhill, Bexley, Portsmouth, Billericay, Bideford, Birkenhead, Bishop's Stortford, Bournemouth, Blackburn, Blackpool, Bolton, Bradford, Exeter , Braintree, Brentwood, Broadstairs, Plymouth, Bromley, Buckingham, Burnham On Sea,Bristol, Bury St Edmunds, Buxton, Reading, Southend, Chelmsford, Ipswich, Norwich, Oxford, Cardiff, Gloucester, Swansea, Northampton, Peterborough, Leicester, Derby, Nottingham, Manchester, Liverpool, Southport, Preston, Anglia, Leeds, Hull, Grimsby, Darlington, Middlesbrough, Newcastle, Edinburgh, Dundee, Glasgow, Belfast, Dublin, Hartlepool, Carlisle, Blythe, Lowestoft, Margate, Hastings, Ramsgate, Deal, Worthing, Maidstone, Bognor, Yarmouth, Stoke, Poole, Weymouth, Torbay, Dartmouth, Falmouth, Penzance, Blackpool, Preston, Whitehaven, Prestwick, Dundee, Bedfordshire, Berkshire, Buckinghamshire, Cambridgeshire, Cheshire, Surrey, Cornwall, Cumberland, Suffolk, Derbyshire, Sussex, Devon, Dorset, Durham, Essex, Warwickshire, Gloucestershire, Hampshire, Westmorland, Herefordshire, Wiltshire, Hertfordshire, Yorkshire, Kent, Lancashire, Leicestershire, Lincolnshire, Worcestershire, Middlesex, Norfolk, Northamptonshire, Northumberland, Nottinghamshire, Oxfordshire, Rutland, Shropshire, Somerset, Staffordshire, North West NW, North East NE, North N, South S, South East SE, South West SW, East E, West W, Scotland, Wales, Anglesey, Fishgaurd, Pembroke, Harwich, Felixstowe, Seacombe, Mostyn, Cotswolds, Hollyhead, North Wales, South Wales, South East England, South West England, North West England, West Scotland, East Scotland, Northern Ireland, Southern Ireland, Channel Islands, Guernsey, Jersey, Isle Of Man, Highlands, North Sea, Irish Sea, English Channel, Solent, Thames, Avon, Dee, Lake District, West Ireland, Cleethorpes, Cleveland, Cambridge, Canterbury, Carlisle, Carlton, Carshalton, Castle, Caterham, Catworth, Cavendish, Chadwell Heath, Colgate, Cork, Coventry, Cudworth, Colchester, Claygate, Chandlers Ford, Charminster, Cheltenham, Chepstow, Chester, Chichester, Chippenham, Christchurch, Chorleywood, Church, City, south coast, east coast, west coast, nw coast, sw coast, ne coast, Darlington, Dacre Banks, Dartford, Danbury, Dartmouth, Dalgerty, Denbury, Dunoon, Durham, Donegal, Denver, Dorking, Derry, Douglas, Daventry, Dorchester, Dawley, Dudley, Docklands, Dulwich, Darwen, Tilbury, Datchet, Doddington,Dungeness, Deal, Dunlop, Dumbarton, Duxford, Dumfries, Delamere, Deeside, Doncaster, Fort William, Dolton, Eaglescliffe, Eaglesfield, Eaglesham, Ealing, Eardisland, Wessex, Cambridge, Canterbury, Carlisle, Carlton, Carshalton, Castle, Caterham, Catworth, Cavendish, Chadwell Heath, Chandlers Ford, Charminster, Cheltenham, Chepstow, Chester, Cichester, Chippenham, Christchurch, Chorleywood, Church, City, Claygate, Cleethorpes, Cleveland, Colchester, Colgate, Cork, Coventry, Cudworth, South Coast, West Coast, East Coast, Dacre Banks, Dalgety, Danbury, Darlington, Dartford, Dartmouth, Darwen, Datchet, Durham, Daventry, Dawley, Dunstable, Deal, Dumbarton, Dumfries, Duxford, Dungeness, Dunlop, Deeside, Delamere, Denbury, Denver, Derry, Docklands, Tilbury, Dartford, Doddington, Dolton, Fort William, Doncaster, Dunoon, Donegal, Dorchester, Dorking, Douglas, Dudley, Dulwich, Cambridge, Canterbury, Carlisle, Carlton, Carshalton, Castle, Caterham, Catworth, Cavendish, Chadwell Heath, Chandlers Ford, Charminster, Cheltenham, Chepstow, Chester, Cichester, Chippenham, Christchurch, Chorleywood, Church, City, Claygate, Cleethorpes, Cleveland, Colchester, Colgate, Cork, Coventry, Cudworth, west coast, south coast, east coast, se coast, sw coast, ne coast, nw coast, Dacre Banks, Darlington, Danbury, Dartford, Dalgety, Dartmouth, Deeside, Dumfries, Duxford, Dunlop, Dungeness, Datchet, Darwen, Docklands, Dawley, Daventry, Derry, Denver Durham, Denbury, Delamere, Dumbarton, Deal, Dunstable, Doddington, Tilbury, Dulwhich, Dudley, Dorchester, Douglas, Dorking, Donegal, Dunoon, Doncaster, Fort William, Dolton, East Midlands, Eastbourne, Exmouth, Exminster, Falkland, Felixstowe, Eaglesfield, Eaglesham, Burbo Bank, Walney, Kentish Flats, Thanet, Greater Gabbard, Race Bank, Dudgeon, Moray Firth, Firth Of Forth, Dogger Bank, Hornsea, Norfolk Bank, Southern Array, West of Isle of White, Bristol Channel, Atlantic Array, Irish Sea, Solway Firth, Wigtown Bay, Kintyre, Islay, Argyll Array, Beatrice, Inch Cape, Neart Na Gaoithe, Forth Array, Bell Rock, North Hoyle, Scroby Sands, Kentish Flats, Barrow Offshore Wind, Burbo Bank, Lynn and inner Dowsing, Rhyl Flats, Gunfleet Sands, Robin Rig, Thanet, Ormonde, Sheringham Shoel, Walney, Gwent y mor, Lincs, London Array, Teesside, West Duddon, Docking Shoel, Humber Gateway, Race Bank, Westermost Rough, Triton Knoll, Blythe Offshore, Vindeby – Denmark, Lely – Holland, Tuno Knob – Denmark, Dronten – Holland, Gotland – Sweden, Middelgrunden, Copenhagen – Denmark, Uttgrunden, Kalmar Sound – Sweden, Yttre Stengrund – Sweden, Middlegrunden – Denmark, Horns Rev – Denmark, Frederikshaven – Denmark, Samso – Denmark, North Hoyle, Nysted – Denmark, Arklow Bank – Ireland, Scroby Sounds, Kentish Flats, Egmond ann Zee – Holland, Barrow, Lilligrund – Sweden, Beatrice, Princess Amalia Q7 – Holland, Thornton Bank – Belgium, Mediterranean, Arabian Gulf, Gulf of Mexico, Europe, Norway, Denmark, Holland ( Netherlands), Finland, Sweden, Germany, Italy, France, Spain, Portugal, Norwegian Sector, Asia, Africa, Nigeria, South America, USA, Canada, Saudi Arabia, United Arab Emirates, UAE, Kuwait, Russia, Japan, Thailand, China, Alaska, India, Afghanistan, Commercial Diving Services Dacre Banks, Crane Hire, Commercial Diving Contractors Dagenham, Safety Boat Hire Dagnall, Safety Boat Services Dalbeattie, Underwater Contractors Dalgety, Sub Sea Services Dalgety Bay, Bridge Inspections And Inspectors Dalkeith, Culvert Cutting and Demolition Dalmally, Diving Services Dalmellington , Marine Companies Dalry, Safety Boat Services Dalrymple ,Dalston, Dalton In Furness , Dalwhinnie, Safety Boat Charter Services Dalwood, Confined Space Access Services, Damerham, Underwater Surveys Danbury, Marine Contractors Danehill, Commercial Divers Daresbury, Sub Sea Surveys Darfield, Dargate, Bridge Engineers Darley Abbey, Civil Engineering Darlingscott, Plant Hire Services Darlington, Darnhall, Steel Fabricators Darsham, Dartford, Dartington, Dartmouth, Darwen, Datchet, Datchworth, Dauntsey Lock, Daventry, Daviot, Davyhulme, Dawley, Dawlish, Underwater Demolition Dawlish Warren, Deal, Dearham, Debden, Debenham, Deddington, Dedham, Deeping St James, Deerhurst, Deeside, Defford, Deganwy, Deighton, Deiniolen, Delabole, Delamere, Delgany, Delny, Denbig, Diving Personnel Denbury, Denchworth, Denford, Denham, Denholme, Denmead , Dennistown, Denny, Dennyloanhead, Denshaw, Densole, Dent, Denton ,Denver, Deptford, Dereham, Derry, Derrygonnelly, Dersingham, Dervaig, Dervock, Underwater Search, Desborough, Underwater Recovery, Devizes Bridge Repairs, Dewsbury, Bridge Maintenance Dibden, Dickleburgh, Didcot, Didsbury, Dilham, Dinas Dinlle, Dinas Powys, Dingestow, Dingle, Dingwall, Dinnington, Marine Support Services Dinton, Boat Hire Diptford, Dirleton, Diseworth, Sub Sea Terrain Disley, Sea Bed Surveys Diss, Ship Repairs, Distington, Underewater Services UK, Ditcheat, Ditchingham, Ditchling, Dittisham, Dockenfield, Docking, Docklands, Dockray, Work Boat Hire Doddinghurst, Doddington, Doddiscombsleigh, Dodworth, Doe Lea, Dogmersfield, Dolfor, Dolforwyn, Dolgellau, Dollar, Dolton, Dolwyddelan, Underwater Visual inspections, Donaghadee, Underwater CCTV, Donaghcloney, Doncaster, Donegal, Donhead St Andrew, Diving Surveyors, Donhead St Mary, Canal Maintenance Services, Donington Le Heath, River Maintenance Contractor Donington On Bain, Ship Engineers, Donisthorpe, Hull Inspections UK, Propeller Repairs, Donnington, Propeller Surveys, Propeller Polishing, Donnington Wood, Dorchester, Dorchester On Thames, Dore, Dorking, Dormington, Dorney, Dornie, Dornoch, Dorridge, Dorrington, Dorstone, Dosthill, Douglas, Doune, Dover, Dovercourt, Dowlish Wake, Down St Mary, Downderry, Downe, Shipping Services, Downend, Downham Market, Downholland, Downley,Downpatrick, Downside, Downton, Draperstown, Drayton, Drayton St Leonard, Dreghorn, Drewsteignton, Driffield, Drogheda, Droitwich, Dromore, Dronfield, Dive Contractors Droylsden, Drumawill, Drumnadrochit, Drumoig, Druridge Bay, Dry Drayton, Drybrook , Dive Surveys, Dryfebridge, Marine Divers, Drymen, Commercial Diving And Marine Services Dublin, Dublin Airport, Dubwath, Ducklington, Duddington, Duddon Valley, Dudley, Duffield, Dufftown, Duffus, Dukinfield, Dulas, Dullingham Underwater Repairs Duloe, Dulverton, Dulwich, Dumbarton, Dumfries, Dummer, Dunadry, Dunamanagh, Dunbar, Dunbeath, Dunblane, Dunbridge, Dunchidcock, Dunchideock Windfarm Services Dunchurch Energy Companies Duncton Materials Dundalk, Manufactorers, Dundee, Dundonald, Dundrum, Dundry, Deep Sea Divers Dunfanaghy, Dunfermline, Dungannon, Divers Dungeness, Power Station Services, Dungiven, Dungloe, Dunkeld, Dunlop, Dunmere, Dunmow, Dunmurry, Dunning, Dunnington,Dunoon Divers Commercial Duns, Professional Divers Duns Tew, Dunseverick, Dunsfold, Dunsley, Dunstable Crane Hire Dunster, Dunsville, Duntisbourne Abbotts, Council Services Dunton, Dunton Bassett RNLI Dunvegan, Dunwich, Durham, Durness, Project Management Duror Of Appin, Durrington, Dursley, Duston, Duxford, Dyffryn Ardudwy, Project Engineering Services Dyffryn Cellwen, Dylife, Dymchurch, Dyrham , Dysart, Diving Operations

Information

Error
  • Unknown column 'a.title_alias' in 'field list' SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM jos_content AS a LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.created_by LEFT JOIN jos_users AS uam ON uam.id = a.modified_by LEFT JOIN jos_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN jos_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-19 12:29:53') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-19 12:29:53') ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created DESC LIMIT 0, 9 Unknown column 'a.title_alias' in 'field list' SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM jos_content AS a LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.created_by LEFT JOIN jos_users AS uam ON uam.id = a.modified_by LEFT JOIN jos_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN jos_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-19 12:29:53') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-19 12:29:53') ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created DESC