Locations
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 0 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textUK
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 1 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textEast Midlands
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 2 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textDerbyshire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 3 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textLeicestershire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 4 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textLincolnshire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 5 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textNorthamptonshire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 6 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textNottinghamshire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 7 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textEast of England
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 8 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textCambridgeshire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 9 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textNorfolk
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 10 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textSuffolk
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 11 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textLondon
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 12 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textBarnet
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 94 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textCamden
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 95 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textCentral London
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 13 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textCity
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 14 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textCity of London
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 96 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textCity of Westminster
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 97 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textColindale
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 91 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textCroydon
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 102 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textEaling
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 117 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textEast London
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 15 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textEnfield
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 98 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textFinchley
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 93 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textGolders Green
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 132 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textGreenwich
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 105 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textHackney
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 106 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textHammersmith & Fulham
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 116 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textHampstead
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 125 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textHaringey
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 103 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textHavering
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 104 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textHendon
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 92 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textIslington
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 99 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textKensington & Chelsea
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 100 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textKingston-Upon-Thames
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 115 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textLambeth
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 114 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textLewisham
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 113 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textMerton
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 107 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textNewham
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 101 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textNorth London
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 16 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textNorth West London
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 17 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textRichmond-Upon-Thames
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 112 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textSouth East London
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 18 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textSouth West London
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 19 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textSouthwark
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 108 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textSutton
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 109 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textWaltham Forest
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 110 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textWandsworth
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 111 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textWest London
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 20 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textNorth East
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 21 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textCleveland
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 22 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textDurham
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 23 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textNorthumberland
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 24 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textTyne and Wear
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 25 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textNorth West
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 26 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textCheshire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 27 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textCumbria
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 28 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textLancashire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 29 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textManchester
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 30 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textMerseyside
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 31 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textNorthern Ireland
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 32 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textScotland
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 33 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textSouth East
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 34 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textBedfordshire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 35 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textLuton
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 89 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textBerkshire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 36 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textBuckinghamshire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 37 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textAmersham
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 71 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textAylesbury
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 69 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textHigh Wycombe
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 68 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textMilton Keynes
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 67 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textSlough
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 70 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textEast Sussex
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 38 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textEssex
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 39 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textBarking
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 72 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textBrentwood
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 75 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textChelmsford
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 73 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textDagenham
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 78 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textHarlow
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 76 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textLoughton
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 74 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textRedbridge
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 77 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textHampshire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 40 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textFareham
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 137 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textSouthampton
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 139 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textHertfordshire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 41 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textBerkhamsted
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 135 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textBorehamwood
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 133 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textBushey
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 81 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textElstree
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 134 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textHatfield
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 85 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textHemel Hempstead
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 80 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textPotters Bar
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 131 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textRickmansworth
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 138 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textSt Albans
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 79 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textStevenage
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 83 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textWatford
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 82 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textWelwyn Garden City
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 84 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textKent
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 42 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textBexley
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 87 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textBromley
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 86 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textChatham
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 136 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textMiddlesex
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 118 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textEdgware
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 119 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textHarrow
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 122 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textHillingdon
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 123 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textHounslow
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 124 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textStanmore
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 120 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textWembley
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 121 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textOxfordshire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 43 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textSurrey
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 44 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textGuildford
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 88 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textSussex
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 90 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textBrighton
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 126 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textWest Sussex
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 45 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textSouth West
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 46 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textBristol
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 47 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textCornwall
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 48 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textDevon
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 49 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textDorset
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 50 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textGloucestershire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 51 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textSomerset
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 52 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textWiltshire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 53 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textWales
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 54 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textWest Midlands
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 55 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textHerefordshire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 59 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textShropshire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 57 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textStaffordshire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 60 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textWarwickshire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 61 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textWest Midlands
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 58 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textWorcestershire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 56 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textYorkshire & The Humber
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 62 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textEast Riding
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 63 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textNorth Yorkshire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 64 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textMiddlesborough
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 130 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textYork
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 129 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textSouth Yorkshire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 65 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textSheffield
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 128 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textWest Yorkshire
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 66 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_textLeeds
SELECT location.id, location.parent_id, translate_location.location_text AS location FROM location inner join translate_location on location.id=translate_location.location_id WHERE translate_location.visible = 1 and location.parent_id = 127 AND translate_location.inc_search = 1 AND translate_location.language_id='2' ORDER BY display_order, translate_location.location_text
Job Types
SELECT job_type.id, translate_job_type.job_type_text AS job_type FROM job_type inner join translate_job_type on job_type.id=translate_job_type.job_type_id WHERE translate_job_type.visible = 1 AND translate_job_type.language_id='2' ORDER BY translate_job_type.job_type_textContract
Permanent
Temporary
