Pierre most lights only require two wires in this case for Mains AC, Brown is Phase and Blue is the Neutral. So that is all you need to do easy peasy.

I connected it up but it's not working. There is an 'L' for the brown wire. I tried the blue in the other two holes - nothing doing. Confused !! Will ask a sparky next time I see one.

The two terminals directly behind the two pins you see on the front of the fitting are the ones you want .As stated above Green should be earth (not connected to anything in this case ) one of the two terminals directly behind the pins should be labelled + ,A or P ,the red or in your case brown wire goes in this terminal .The other terminal directly behind the other pin should be marked -,N ,the black or in your case the blue wire goes in this terminal .The fourth terminal is a loop terminal and is connected to nothing either .If you have the wires in the right terminals and nothing happens then either the lamp is faulty (try it in a light fitting you know goes or try a lamp from your house you know goes in it).If still not going you probably have a problem in the wiring or the switch that controls the light  or in your case the plug .Call  a sparky (me) Unfortunately for you Im in Whitianga