Home
News and Updates
News and Updates
HomeJoin Girls On The MoveNewsflashesGOT'M ACT ForumGOT'M Tasmania ForumGOT'M Calendar - ACT & Tasmania EventsMembers DiscountsRiding TipsNewsletterGOT'M GalleryFrequently Asked QuestionsLinksContact UsAbout us
Events Calendar
September 2010
M T W T F S S
30311 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 1 2 3
October 2010
M T W T F S S
272829301 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31
Latest Events
Canberra - September Monthly Dinner - 3 Sept 2010
Fri, Sep 3rd, 2010, @7:00pm- 9:00pm
Canberra - Members Meeting - 4 September 2010
Sat, Sep 4th, 2010, @1:00pm- 3:30pm
Canberra - Ride of Remembrance - 5 September 2010
Sun, Sep 5th, 2010, @10:00am- 12:00pm
Canberra - GOT'M Club Ride - Captains Flat
Sun, Sep 5th, 2010, @10:00am- 3:00pm
Canberra - GOT'M Club Ride - Bathurst Or Bust
Fri, Sep 10th, 2010, @8:30am- 5:00pm
Canberra - GOT'M Club Ride - Bathurst Or Bust
Sat, Sep 11th, 2010, @8:30am- 5:00pm
Canberra - GOT'M Club Ride - Bathurst Or Bust
Sun, Sep 12th, 2010, @8:30am- 5:00pm
Canberra - Annual General Meeting 23 Sept 2010
Thu, Sep 23rd, 2010, @7:00pm- 9:00pm
Canberra - GOT'M Ride - Pink Ribbon Ride
Sat, Oct 30th, 2010, @10:00am- 2:00pm
Picture_023_resize.jpg
Who's Online
We have 96 guests online
20 Tips to buying a bike

Here are 20 top buying tips


1. Appearance:
Original paint, stickers, mufflers. Do you know what an original should look like? Custom everything is nice but not worth a pinch of the proverbial in the used market.

Bikes that are red or black will resell easily. If it has aftermarket mufflers and the like, ask if the original bits come with the bike. An original bike is always worth more when you go to sell it.

Look for cancer: rust on the frame, corroded alloy bits, faded grey switchgear, yellowed screen, cracked and dull paint. Stand at the back of the bike and sight along the centre - does the fairing line up with the steering head? If not, it's had a big shunt and hasn't been fixed properly. Do the colours along the bodywork match?

2. Fit:
This is a good time to take a breather and sit quietly on the bike. Does it fit? Can you reach the ground easily? Is your pillion happy on the back seat? Can you get it on and off the stands? Can the levers or even seat height be adjusted to fit you better?

3. Rego:
How much is left? In some cases this could be a $600 observation.

4. Provenance:
Do the engine and frame match each other? This is an issue with classic Brit bikes where the frame and engine numbers should often match. And with some Japanese classics - does that CB1100R have the real powerplant in the frame or the easily-swapped CB900 engine which looks much the same? With the former it is a desirable motorcycle; with the latter it's next to worthless.

Check the engine/chassis/rego numbers with your local registration authority before handing over the cheque - it could be stolen.

5. Service history:
If it has one, it's worth money in the bank. Look for dealer stamps, or the next-best which is a history recorded by the owner.

 

6. Still under warranty:
Warranties do transfer to the new owner but are of doubtful worth unless the bike has been dealer-serviced (by a pukka franchise) according to the manufacturer schedule (ask to see the records).

7. Starting cold:
Put your hand beside the engine/fairing. It should be cold. Ask the owner to start it - deduct points for use of jumper leads off the car battery and special techniques involving liberal use of a kickstart and the F-word. If it's pre-warmed when you turn up, treat it with suspicion. A bit of smoke at this stage is acceptable - it could be unburned fuel or even a bit of oil.

8. Running:
It should run smoothly through warm-up, while the choke/fast idle is backed off. Give it five minutes and switch it off.

9. Warm start:
Start it again - it should start first time, no excuses.

10. Warm running:
It should respond instantly to the throttle - try a gentle rev and then a hard rev to about 60 percent of redline. It should settle immediately back to idle speed (usually around 1000-1200rpm). If it settles to a fast idle, then slows to a normal idle after a few seconds, the carburetion is suspect. Was that a puff of smoke? Why? Is there an unusual rattle or bang? Have you heard the same powerplant in another bike? Does it change when you pull the clutch lever? Is that normal for this bike? Click it into gear and do a walking-pace take-off. Was the clutch action smooth? Did it drop into gear without hesitation?

11. Tyres:
Look for cracks (old rubber), depth of tread, and severe cuts or bits of metal in the tread. Check the entire circumference of each tyre.

12. Chain/sprockets:
Look at a rear sprocket on a new bike and see if your used item looks the same shape. Fat rounded teeth are what you're looking for. Anything that looks like shark teeth, with broken or chipped tops, is stuffed. The chain should have no more than a few centimetres slack on the lower run, midway between the engine and rear wheel.

13. Steering:
If it has a centrestand, use it, and take the weight off the front end (pushing down, or sitting someone, on the pillion seat will do this). Swing the handlebars from side-to-side looking for smooth transition (ignoring a cable that might snag). If it feels tight on the outer reaches while loose and notchy in the centre, add $200 to the cost for steering head bearings. Without a centrestand, roll the bike forward and do the same thing.

14. Brake pads:
Easy with disc brakes - look along the disc and see if there is at least 2mm of brake material left before the backing plate hits the disc. Deep gouges in the discs are a bad sign. Drum brakes are harder to judge, though some models will have pad wear indicators on them.

15. Electrics working:
Check all the basics. Headlight high/low, indicators both sides, front and rear brake light, horn, with the engine running. No excuses.

16. Electrics charging:
Switch on the headlight and put your hand just in front of it. On low or high beam (sometimes you need the latter) you should see the light brighten noticeably when you raise the engine revs from idle to around 2000.

17. Muffler check:
Look for rust fairies, particularly on the underside of the muffler. Rev the engine and see if there's a rattle from the muffler indicating loose baffles.

18. Abuse check:
Run your hand under the footpegs, the lowest point on the headers, the lowest points of the fairing, the handlebar ends and the lever ends. Lots of scrapes and rough bits? A cupie doll to the reader that can guess what happened...

19. Engine leak test:
Look for oil leaks - some weeping from the top gasket on the engine is nothing to worry about and oil near the front sprocket is probably just over-enthusiastic chain-oiling. Look for major leaks elsewhere. If you see a green watery substance, you have a leak in the cooling system - a no-no.

20. Suspension:
Bounce both ends up and down with as much force as you can muster. Squeaks at the rear on monoshocks may indicate unhappy bushes, while oil leaks (lift fork gaiters if fitted) suggest a rebuild.

TAKE A ROAD TEST

Take a road test although it's not always possible. If you turn up with a friend who is willing to hang around while you go for a ride, your chances of a spin are increased. Remember, if you bin it, you own it.

What you're looking for is:

1. Those steering head bearings - try them at walking pace, lock-to-lock. Does it turn smoothly? Now a little quicker in the turns (no lock-to-lock this time) - is it equally happy in left and right turns or is the frame bent?

2. Brakes - a couple of gentle stops using the front then the rear levers in isolation will tell you if the discs or drums are warped. Pulsing levers or jerky stopping are bad news.

3. Gearshift - does it work all the gears smoothly?

4. Do the instruments work? A speedo that doesn't work is a basic roadworthy item.

5. Did it accelerate smoothly and immediately drop back to a predictable idle? Could you restart it instantly?

6. Who was in control - you or the bike? If it was the bike, will you overcome that problem?

SELF-PROTECTION


There's a whole heap of stuff you can do to protect yourself from making a bad decision - which is outlined here. Another useful ploy is to take along a mate who is a little experienced in the bike world, but who isn't an opinionated know-all smart-alec. Someone who can offer advice, and knows when to suggest you should calm down - no matter how red the bike is.

So here's the drum: do the basic checks, try to make sure you have enough dough left over to fix the problems, pack your raincoat, don't take money from strangers and good luck...
 
< Prev   Next >
   
Copyright Girls On The Move Inc. | designed by ITReality. | Powered by Gohosting
93 queries executed
1
SELECT folder, element, published, params
 FROM mos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2 SELECT template FROM mos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 1 ) ORDER BY menuid DESC LIMIT 1
3 DELETE FROM mos_session WHERE ( ( time < '1283468669' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1283468669' ) AND guest = 1 AND userid = 0 )
4 SELECT * FROM mos_session WHERE session_id = '2e3731347eb687ce4b5826b8e84c0ac2'
5 SELECT session_id FROM mos_session WHERE session_id = '3b2d0fc74d29f6ea3c303b37edfc079f'
6 INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '3b2d0fc74d29f6ea3c303b37edfc079f','1283469569','','0','1' )
7 SELECT * FROM mos_menu WHERE id = 1
8 SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access, s.id AS sec_id, cc.id as cat_id FROM mos_content AS a LEFT JOIN mos_categories AS cc ON cc.id = a.catid LEFT JOIN mos_sections AS s ON s.id = cc.section AND s.scope = 'content' LEFT JOIN mos_users AS u ON u.id = a.created_by LEFT JOIN mos_groups AS g ON a.access = g.id WHERE a.id = 163 AND ( a.state = 1 OR a.state = -1 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-03 09:19' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-03 09:19' ) AND a.access <= 0
9 SELECT a.id FROM mos_content AS a WHERE a.catid = 78 AND a.state = 1 AND a.access <= 0 AND ( a.state = 1 OR a.state = -1 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-03 09:19' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-03 09:19' ) ORDER BY a.ordering
10 UPDATE mos_content SET hits = ( hits + 1 ) WHERE id = '163'
11 SELECT folder, element, published, params FROM mos_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
12 SELECT a.* FROM mos_components AS a WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' ) AND a.option = 'com_syndicate'
13 SELECT id, name, link, parent, type, menutype, access FROM mos_menu WHERE published = 1 AND access <= 0 ORDER BY menutype, parent, ordering
14 SELECT id, title, module, position, content, showtitle, params FROM mos_modules AS m INNER JOIN mos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id != 1 AND ( mm.menuid = 0 OR mm.menuid = 1 ) ORDER BY ordering
15 SELECT m.* FROM mos_menu AS m WHERE menutype = 'News and Updates' AND published = 1 AND access <= 0 ORDER BY parent, ordering
16 SELECT m.* FROM mos_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering
17 SELECT COUNT( id ) FROM mos_menu WHERE type = 'content_typed' AND published = 1
18 SELECT id FROM mos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=66'
19 SELECT m.* FROM mos_menu AS m WHERE menutype = 'othermenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
20 SELECT id FROM mos_menu WHERE link = 'index.php?option=com_events'
21 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-01 00:00:00' AND publish_up <= '2010-09-01 23:59:59') OR (publish_down >= '2010-09-01 00:00:00' AND publish_down <= '2010-09-01 23:59:59') OR (publish_up <= '2010-09-01 00:00:00' AND publish_down >= '2010-09-01 23:59:59')) AND state='1' ORDER BY publish_up ASC
22 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-02 00:00:00' AND publish_up <= '2010-09-02 23:59:59') OR (publish_down >= '2010-09-02 00:00:00' AND publish_down <= '2010-09-02 23:59:59') OR (publish_up <= '2010-09-02 00:00:00' AND publish_down >= '2010-09-02 23:59:59')) AND state='1' ORDER BY publish_up ASC
23 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-03 00:00:00' AND publish_up <= '2010-09-03 23:59:59') OR (publish_down >= '2010-09-03 00:00:00' AND publish_down <= '2010-09-03 23:59:59') OR (publish_up <= '2010-09-03 00:00:00' AND publish_down >= '2010-09-03 23:59:59')) AND state='1' ORDER BY publish_up ASC
24 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-04 00:00:00' AND publish_up <= '2010-09-04 23:59:59') OR (publish_down >= '2010-09-04 00:00:00' AND publish_down <= '2010-09-04 23:59:59') OR (publish_up <= '2010-09-04 00:00:00' AND publish_down >= '2010-09-04 23:59:59')) AND state='1' ORDER BY publish_up ASC
25 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-05 00:00:00' AND publish_up <= '2010-09-05 23:59:59') OR (publish_down >= '2010-09-05 00:00:00' AND publish_down <= '2010-09-05 23:59:59') OR (publish_up <= '2010-09-05 00:00:00' AND publish_down >= '2010-09-05 23:59:59')) AND state='1' ORDER BY publish_up ASC
26 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-06 00:00:00' AND publish_up <= '2010-09-06 23:59:59') OR (publish_down >= '2010-09-06 00:00:00' AND publish_down <= '2010-09-06 23:59:59') OR (publish_up <= '2010-09-06 00:00:00' AND publish_down >= '2010-09-06 23:59:59')) AND state='1' ORDER BY publish_up ASC
27 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-07 00:00:00' AND publish_up <= '2010-09-07 23:59:59') OR (publish_down >= '2010-09-07 00:00:00' AND publish_down <= '2010-09-07 23:59:59') OR (publish_up <= '2010-09-07 00:00:00' AND publish_down >= '2010-09-07 23:59:59')) AND state='1' ORDER BY publish_up ASC
28 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-08 00:00:00' AND publish_up <= '2010-09-08 23:59:59') OR (publish_down >= '2010-09-08 00:00:00' AND publish_down <= '2010-09-08 23:59:59') OR (publish_up <= '2010-09-08 00:00:00' AND publish_down >= '2010-09-08 23:59:59')) AND state='1' ORDER BY publish_up ASC
29 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-09 00:00:00' AND publish_up <= '2010-09-09 23:59:59') OR (publish_down >= '2010-09-09 00:00:00' AND publish_down <= '2010-09-09 23:59:59') OR (publish_up <= '2010-09-09 00:00:00' AND publish_down >= '2010-09-09 23:59:59')) AND state='1' ORDER BY publish_up ASC
30 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-10 00:00:00' AND publish_up <= '2010-09-10 23:59:59') OR (publish_down >= '2010-09-10 00:00:00' AND publish_down <= '2010-09-10 23:59:59') OR (publish_up <= '2010-09-10 00:00:00' AND publish_down >= '2010-09-10 23:59:59')) AND state='1' ORDER BY publish_up ASC
31 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-11 00:00:00' AND publish_up <= '2010-09-11 23:59:59') OR (publish_down >= '2010-09-11 00:00:00' AND publish_down <= '2010-09-11 23:59:59') OR (publish_up <= '2010-09-11 00:00:00' AND publish_down >= '2010-09-11 23:59:59')) AND state='1' ORDER BY publish_up ASC
32 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-12 00:00:00' AND publish_up <= '2010-09-12 23:59:59') OR (publish_down >= '2010-09-12 00:00:00' AND publish_down <= '2010-09-12 23:59:59') OR (publish_up <= '2010-09-12 00:00:00' AND publish_down >= '2010-09-12 23:59:59')) AND state='1' ORDER BY publish_up ASC
33 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-13 00:00:00' AND publish_up <= '2010-09-13 23:59:59') OR (publish_down >= '2010-09-13 00:00:00' AND publish_down <= '2010-09-13 23:59:59') OR (publish_up <= '2010-09-13 00:00:00' AND publish_down >= '2010-09-13 23:59:59')) AND state='1' ORDER BY publish_up ASC
34 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-14 00:00:00' AND publish_up <= '2010-09-14 23:59:59') OR (publish_down >= '2010-09-14 00:00:00' AND publish_down <= '2010-09-14 23:59:59') OR (publish_up <= '2010-09-14 00:00:00' AND publish_down >= '2010-09-14 23:59:59')) AND state='1' ORDER BY publish_up ASC
35 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-15 00:00:00' AND publish_up <= '2010-09-15 23:59:59') OR (publish_down >= '2010-09-15 00:00:00' AND publish_down <= '2010-09-15 23:59:59') OR (publish_up <= '2010-09-15 00:00:00' AND publish_down >= '2010-09-15 23:59:59')) AND state='1' ORDER BY publish_up ASC
36 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-16 00:00:00' AND publish_up <= '2010-09-16 23:59:59') OR (publish_down >= '2010-09-16 00:00:00' AND publish_down <= '2010-09-16 23:59:59') OR (publish_up <= '2010-09-16 00:00:00' AND publish_down >= '2010-09-16 23:59:59')) AND state='1' ORDER BY publish_up ASC
37 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-17 00:00:00' AND publish_up <= '2010-09-17 23:59:59') OR (publish_down >= '2010-09-17 00:00:00' AND publish_down <= '2010-09-17 23:59:59') OR (publish_up <= '2010-09-17 00:00:00' AND publish_down >= '2010-09-17 23:59:59')) AND state='1' ORDER BY publish_up ASC
38 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-18 00:00:00' AND publish_up <= '2010-09-18 23:59:59') OR (publish_down >= '2010-09-18 00:00:00' AND publish_down <= '2010-09-18 23:59:59') OR (publish_up <= '2010-09-18 00:00:00' AND publish_down >= '2010-09-18 23:59:59')) AND state='1' ORDER BY publish_up ASC
39 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-19 00:00:00' AND publish_up <= '2010-09-19 23:59:59') OR (publish_down >= '2010-09-19 00:00:00' AND publish_down <= '2010-09-19 23:59:59') OR (publish_up <= '2010-09-19 00:00:00' AND publish_down >= '2010-09-19 23:59:59')) AND state='1' ORDER BY publish_up ASC
40 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-20 00:00:00' AND publish_up <= '2010-09-20 23:59:59') OR (publish_down >= '2010-09-20 00:00:00' AND publish_down <= '2010-09-20 23:59:59') OR (publish_up <= '2010-09-20 00:00:00' AND publish_down >= '2010-09-20 23:59:59')) AND state='1' ORDER BY publish_up ASC
41 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-21 00:00:00' AND publish_up <= '2010-09-21 23:59:59') OR (publish_down >= '2010-09-21 00:00:00' AND publish_down <= '2010-09-21 23:59:59') OR (publish_up <= '2010-09-21 00:00:00' AND publish_down >= '2010-09-21 23:59:59')) AND state='1' ORDER BY publish_up ASC
42 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-22 00:00:00' AND publish_up <= '2010-09-22 23:59:59') OR (publish_down >= '2010-09-22 00:00:00' AND publish_down <= '2010-09-22 23:59:59') OR (publish_up <= '2010-09-22 00:00:00' AND publish_down >= '2010-09-22 23:59:59')) AND state='1' ORDER BY publish_up ASC
43 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-23 00:00:00' AND publish_up <= '2010-09-23 23:59:59') OR (publish_down >= '2010-09-23 00:00:00' AND publish_down <= '2010-09-23 23:59:59') OR (publish_up <= '2010-09-23 00:00:00' AND publish_down >= '2010-09-23 23:59:59')) AND state='1' ORDER BY publish_up ASC
44 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-24 00:00:00' AND publish_up <= '2010-09-24 23:59:59') OR (publish_down >= '2010-09-24 00:00:00' AND publish_down <= '2010-09-24 23:59:59') OR (publish_up <= '2010-09-24 00:00:00' AND publish_down >= '2010-09-24 23:59:59')) AND state='1' ORDER BY publish_up ASC
45 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-25 00:00:00' AND publish_up <= '2010-09-25 23:59:59') OR (publish_down >= '2010-09-25 00:00:00' AND publish_down <= '2010-09-25 23:59:59') OR (publish_up <= '2010-09-25 00:00:00' AND publish_down >= '2010-09-25 23:59:59')) AND state='1' ORDER BY publish_up ASC
46 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-26 00:00:00' AND publish_up <= '2010-09-26 23:59:59') OR (publish_down >= '2010-09-26 00:00:00' AND publish_down <= '2010-09-26 23:59:59') OR (publish_up <= '2010-09-26 00:00:00' AND publish_down >= '2010-09-26 23:59:59')) AND state='1' ORDER BY publish_up ASC
47 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-27 00:00:00' AND publish_up <= '2010-09-27 23:59:59') OR (publish_down >= '2010-09-27 00:00:00' AND publish_down <= '2010-09-27 23:59:59') OR (publish_up <= '2010-09-27 00:00:00' AND publish_down >= '2010-09-27 23:59:59')) AND state='1' ORDER BY publish_up ASC
48 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-28 00:00:00' AND publish_up <= '2010-09-28 23:59:59') OR (publish_down >= '2010-09-28 00:00:00' AND publish_down <= '2010-09-28 23:59:59') OR (publish_up <= '2010-09-28 00:00:00' AND publish_down >= '2010-09-28 23:59:59')) AND state='1' ORDER BY publish_up ASC
49 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-29 00:00:00' AND publish_up <= '2010-09-29 23:59:59') OR (publish_down >= '2010-09-29 00:00:00' AND publish_down <= '2010-09-29 23:59:59') OR (publish_up <= '2010-09-29 00:00:00' AND publish_down >= '2010-09-29 23:59:59')) AND state='1' ORDER BY publish_up ASC
50 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-09-30 00:00:00' AND publish_up <= '2010-09-30 23:59:59') OR (publish_down >= '2010-09-30 00:00:00' AND publish_down <= '2010-09-30 23:59:59') OR (publish_up <= '2010-09-30 00:00:00' AND publish_down >= '2010-09-30 23:59:59')) AND state='1' ORDER BY publish_up ASC
51 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-01 00:00:00' AND publish_up <= '2010-10-01 23:59:59') OR (publish_down >= '2010-10-01 00:00:00' AND publish_down <= '2010-10-01 23:59:59') OR (publish_up <= '2010-10-01 00:00:00' AND publish_down >= '2010-10-01 23:59:59')) AND state='1' ORDER BY publish_up ASC
52 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-02 00:00:00' AND publish_up <= '2010-10-02 23:59:59') OR (publish_down >= '2010-10-02 00:00:00' AND publish_down <= '2010-10-02 23:59:59') OR (publish_up <= '2010-10-02 00:00:00' AND publish_down >= '2010-10-02 23:59:59')) AND state='1' ORDER BY publish_up ASC
53 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-03 00:00:00' AND publish_up <= '2010-10-03 23:59:59') OR (publish_down >= '2010-10-03 00:00:00' AND publish_down <= '2010-10-03 23:59:59') OR (publish_up <= '2010-10-03 00:00:00' AND publish_down >= '2010-10-03 23:59:59')) AND state='1' ORDER BY publish_up ASC
54 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-04 00:00:00' AND publish_up <= '2010-10-04 23:59:59') OR (publish_down >= '2010-10-04 00:00:00' AND publish_down <= '2010-10-04 23:59:59') OR (publish_up <= '2010-10-04 00:00:00' AND publish_down >= '2010-10-04 23:59:59')) AND state='1' ORDER BY publish_up ASC
55 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-05 00:00:00' AND publish_up <= '2010-10-05 23:59:59') OR (publish_down >= '2010-10-05 00:00:00' AND publish_down <= '2010-10-05 23:59:59') OR (publish_up <= '2010-10-05 00:00:00' AND publish_down >= '2010-10-05 23:59:59')) AND state='1' ORDER BY publish_up ASC
56 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-06 00:00:00' AND publish_up <= '2010-10-06 23:59:59') OR (publish_down >= '2010-10-06 00:00:00' AND publish_down <= '2010-10-06 23:59:59') OR (publish_up <= '2010-10-06 00:00:00' AND publish_down >= '2010-10-06 23:59:59')) AND state='1' ORDER BY publish_up ASC
57 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-07 00:00:00' AND publish_up <= '2010-10-07 23:59:59') OR (publish_down >= '2010-10-07 00:00:00' AND publish_down <= '2010-10-07 23:59:59') OR (publish_up <= '2010-10-07 00:00:00' AND publish_down >= '2010-10-07 23:59:59')) AND state='1' ORDER BY publish_up ASC
58 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-08 00:00:00' AND publish_up <= '2010-10-08 23:59:59') OR (publish_down >= '2010-10-08 00:00:00' AND publish_down <= '2010-10-08 23:59:59') OR (publish_up <= '2010-10-08 00:00:00' AND publish_down >= '2010-10-08 23:59:59')) AND state='1' ORDER BY publish_up ASC
59 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-09 00:00:00' AND publish_up <= '2010-10-09 23:59:59') OR (publish_down >= '2010-10-09 00:00:00' AND publish_down <= '2010-10-09 23:59:59') OR (publish_up <= '2010-10-09 00:00:00' AND publish_down >= '2010-10-09 23:59:59')) AND state='1' ORDER BY publish_up ASC
60 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-10 00:00:00' AND publish_up <= '2010-10-10 23:59:59') OR (publish_down >= '2010-10-10 00:00:00' AND publish_down <= '2010-10-10 23:59:59') OR (publish_up <= '2010-10-10 00:00:00' AND publish_down >= '2010-10-10 23:59:59')) AND state='1' ORDER BY publish_up ASC
61 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-11 00:00:00' AND publish_up <= '2010-10-11 23:59:59') OR (publish_down >= '2010-10-11 00:00:00' AND publish_down <= '2010-10-11 23:59:59') OR (publish_up <= '2010-10-11 00:00:00' AND publish_down >= '2010-10-11 23:59:59')) AND state='1' ORDER BY publish_up ASC
62 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-12 00:00:00' AND publish_up <= '2010-10-12 23:59:59') OR (publish_down >= '2010-10-12 00:00:00' AND publish_down <= '2010-10-12 23:59:59') OR (publish_up <= '2010-10-12 00:00:00' AND publish_down >= '2010-10-12 23:59:59')) AND state='1' ORDER BY publish_up ASC
63 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-13 00:00:00' AND publish_up <= '2010-10-13 23:59:59') OR (publish_down >= '2010-10-13 00:00:00' AND publish_down <= '2010-10-13 23:59:59') OR (publish_up <= '2010-10-13 00:00:00' AND publish_down >= '2010-10-13 23:59:59')) AND state='1' ORDER BY publish_up ASC
64 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-14 00:00:00' AND publish_up <= '2010-10-14 23:59:59') OR (publish_down >= '2010-10-14 00:00:00' AND publish_down <= '2010-10-14 23:59:59') OR (publish_up <= '2010-10-14 00:00:00' AND publish_down >= '2010-10-14 23:59:59')) AND state='1' ORDER BY publish_up ASC
65 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-15 00:00:00' AND publish_up <= '2010-10-15 23:59:59') OR (publish_down >= '2010-10-15 00:00:00' AND publish_down <= '2010-10-15 23:59:59') OR (publish_up <= '2010-10-15 00:00:00' AND publish_down >= '2010-10-15 23:59:59')) AND state='1' ORDER BY publish_up ASC
66 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-16 00:00:00' AND publish_up <= '2010-10-16 23:59:59') OR (publish_down >= '2010-10-16 00:00:00' AND publish_down <= '2010-10-16 23:59:59') OR (publish_up <= '2010-10-16 00:00:00' AND publish_down >= '2010-10-16 23:59:59')) AND state='1' ORDER BY publish_up ASC
67 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-17 00:00:00' AND publish_up <= '2010-10-17 23:59:59') OR (publish_down >= '2010-10-17 00:00:00' AND publish_down <= '2010-10-17 23:59:59') OR (publish_up <= '2010-10-17 00:00:00' AND publish_down >= '2010-10-17 23:59:59')) AND state='1' ORDER BY publish_up ASC
68 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-18 00:00:00' AND publish_up <= '2010-10-18 23:59:59') OR (publish_down >= '2010-10-18 00:00:00' AND publish_down <= '2010-10-18 23:59:59') OR (publish_up <= '2010-10-18 00:00:00' AND publish_down >= '2010-10-18 23:59:59')) AND state='1' ORDER BY publish_up ASC
69 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-19 00:00:00' AND publish_up <= '2010-10-19 23:59:59') OR (publish_down >= '2010-10-19 00:00:00' AND publish_down <= '2010-10-19 23:59:59') OR (publish_up <= '2010-10-19 00:00:00' AND publish_down >= '2010-10-19 23:59:59')) AND state='1' ORDER BY publish_up ASC
70 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-20 00:00:00' AND publish_up <= '2010-10-20 23:59:59') OR (publish_down >= '2010-10-20 00:00:00' AND publish_down <= '2010-10-20 23:59:59') OR (publish_up <= '2010-10-20 00:00:00' AND publish_down >= '2010-10-20 23:59:59')) AND state='1' ORDER BY publish_up ASC
71 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-21 00:00:00' AND publish_up <= '2010-10-21 23:59:59') OR (publish_down >= '2010-10-21 00:00:00' AND publish_down <= '2010-10-21 23:59:59') OR (publish_up <= '2010-10-21 00:00:00' AND publish_down >= '2010-10-21 23:59:59')) AND state='1' ORDER BY publish_up ASC
72 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-22 00:00:00' AND publish_up <= '2010-10-22 23:59:59') OR (publish_down >= '2010-10-22 00:00:00' AND publish_down <= '2010-10-22 23:59:59') OR (publish_up <= '2010-10-22 00:00:00' AND publish_down >= '2010-10-22 23:59:59')) AND state='1' ORDER BY publish_up ASC
73 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-23 00:00:00' AND publish_up <= '2010-10-23 23:59:59') OR (publish_down >= '2010-10-23 00:00:00' AND publish_down <= '2010-10-23 23:59:59') OR (publish_up <= '2010-10-23 00:00:00' AND publish_down >= '2010-10-23 23:59:59')) AND state='1' ORDER BY publish_up ASC
74 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-24 00:00:00' AND publish_up <= '2010-10-24 23:59:59') OR (publish_down >= '2010-10-24 00:00:00' AND publish_down <= '2010-10-24 23:59:59') OR (publish_up <= '2010-10-24 00:00:00' AND publish_down >= '2010-10-24 23:59:59')) AND state='1' ORDER BY publish_up ASC
75 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-25 00:00:00' AND publish_up <= '2010-10-25 23:59:59') OR (publish_down >= '2010-10-25 00:00:00' AND publish_down <= '2010-10-25 23:59:59') OR (publish_up <= '2010-10-25 00:00:00' AND publish_down >= '2010-10-25 23:59:59')) AND state='1' ORDER BY publish_up ASC
76 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-26 00:00:00' AND publish_up <= '2010-10-26 23:59:59') OR (publish_down >= '2010-10-26 00:00:00' AND publish_down <= '2010-10-26 23:59:59') OR (publish_up <= '2010-10-26 00:00:00' AND publish_down >= '2010-10-26 23:59:59')) AND state='1' ORDER BY publish_up ASC
77 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-27 00:00:00' AND publish_up <= '2010-10-27 23:59:59') OR (publish_down >= '2010-10-27 00:00:00' AND publish_down <= '2010-10-27 23:59:59') OR (publish_up <= '2010-10-27 00:00:00' AND publish_down >= '2010-10-27 23:59:59')) AND state='1' ORDER BY publish_up ASC
78 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-28 00:00:00' AND publish_up <= '2010-10-28 23:59:59') OR (publish_down >= '2010-10-28 00:00:00' AND publish_down <= '2010-10-28 23:59:59') OR (publish_up <= '2010-10-28 00:00:00' AND publish_down >= '2010-10-28 23:59:59')) AND state='1' ORDER BY publish_up ASC
79 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-29 00:00:00' AND publish_up <= '2010-10-29 23:59:59') OR (publish_down >= '2010-10-29 00:00:00' AND publish_down <= '2010-10-29 23:59:59') OR (publish_up <= '2010-10-29 00:00:00' AND publish_down >= '2010-10-29 23:59:59')) AND state='1' ORDER BY publish_up ASC
80 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-30 00:00:00' AND publish_up <= '2010-10-30 23:59:59') OR (publish_down >= '2010-10-30 00:00:00' AND publish_down <= '2010-10-30 23:59:59') OR (publish_up <= '2010-10-30 00:00:00' AND publish_down >= '2010-10-30 23:59:59')) AND state='1' ORDER BY publish_up ASC
81 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND ((publish_up >= '2010-10-31 00:00:00' AND publish_up <= '2010-10-31 23:59:59') OR (publish_down >= '2010-10-31 00:00:00' AND publish_down <= '2010-10-31 23:59:59') OR (publish_up <= '2010-10-31 00:00:00' AND publish_down >= '2010-10-31 23:59:59')) AND state='1' ORDER BY publish_up ASC
82 SELECT mos_events.* FROM mos_events, mos_categories as b WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND (mos_events.state='1' AND mos_events.checked_out='0') AND ((publish_up <= '2010-09-03 00:00:00%' AND publish_down >= '2010-09-03 00:00:00%') OR (publish_up <= '2010-11-02 23:59:59%' AND publish_down >= '2010-11-02 23:59:59%') OR (publish_up <= '2010-11-02 23:59:59%' AND publish_up >= '2010-09-03 00:00:00%') OR (publish_down <= '2010-11-02 23:59:59%' AND publish_down >= '2010-09-03 00:00:00%')) ORDER BY publish_up ASC
83 SELECT id FROM mos_menu WHERE link = 'index.php?option=com_events'
84 SELECT id, name FROM mos_categories WHERE section= 'com_events' AND published='1'
85 SELECT id, username, sendEmail, email FROM mos_users WHERE block ='0'
86 SELECT guest, usertype FROM mos_session
87 SELECT m.* FROM mos_menu AS m WHERE menutype = 'topmenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering
88 SELECT a.id, a.title, a.sectionid, a.catid FROM mos_content AS a LEFT JOIN mos_content_frontpage AS f ON f.content_id = a.id INNER JOIN mos_categories AS cc ON cc.id = a.catid INNER JOIN mos_sections AS s ON s.id = a.sectionid WHERE ( a.state = 1 AND a.sectionid > 0 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-03 09:19' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-03 09:19' ) AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND s.published = 1 AND cc.published = 1 ORDER BY a.created DESC LIMIT 4
89 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM mos_content AS i LEFT JOIN mos_sections AS s ON i.sectionid = s.id LEFT JOIN mos_menu AS ms ON ms.componentid = s.id LEFT JOIN mos_categories AS c ON i.catid = c.id LEFT JOIN mos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 196 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
90 SELECT id FROM mos_menu WHERE type = 'content_blog_section' AND published = 1 AND componentid = 0
91 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM mos_content AS i LEFT JOIN mos_sections AS s ON i.sectionid = s.id LEFT JOIN mos_menu AS ms ON ms.componentid = s.id LEFT JOIN mos_categories AS c ON i.catid = c.id LEFT JOIN mos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 194 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
92 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM mos_content AS i LEFT JOIN mos_sections AS s ON i.sectionid = s.id LEFT JOIN mos_menu AS ms ON ms.componentid = s.id LEFT JOIN mos_categories AS c ON i.catid = c.id LEFT JOIN mos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 184 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
93 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM mos_content AS i LEFT JOIN mos_sections AS s ON i.sectionid = s.id LEFT JOIN mos_menu AS ms ON ms.componentid = s.id LEFT JOIN mos_categories AS c ON i.catid = c.id LEFT JOIN mos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 193 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id