Home
HomeJoin Girls On The MoveNewsflashesGOT'M ACT ForumGOT'M ACT CalendarGOT'M Tasmania ForumGOT'M Tasmania CalendarMembers DiscountsRiding TipsNewsletterGOT'M CoursesGOT'M Gallery2009 Pink Ribbon RideFrequently Asked QuestionsLinksContact UsAbout us
Events Calendar
March 2010
M T W T F S S
1 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 1 2 3 4
April 2010
M T W T F S S
2930311 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
Latest Events
Canberra - Get'M Going Ride - Peaks and Troughs
Sat, Mar 27th, 2010, @9:30am- 1:00pm
Canberra - Monthly Dinner - Apr 10
Fri, Apr 2nd, 2010, @7:00pm- 9:30pm
Canberra - MOST Practice
Sat, Apr 3rd, 2010, @9:00am- 11:00am
Canberra - Committee Meeting - Apr
Thu, Apr 15th, 2010, @7:00pm- 9:00pm
Canberra - combined ride - 17 Apr 10
Sat, Apr 17th, 2010, @8:00am- 4:00pm
Canberra - Monthly Dinner - May
Fri, May 7th, 2010, @7:00pm- 9:30pm
Picture_026_resize.jpg
Who's Online
We have 3 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
102 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 < '1268420736' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1268420736' ) AND guest = 1 AND userid = 0 )
4 SELECT * FROM mos_session WHERE session_id = 'e47f27b7bf3b1deda2c3e58fa3628c8a'
5 SELECT session_id FROM mos_session WHERE session_id = '63204176f162611e8723a9fac76c95c9'
6 INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '63204176f162611e8723a9fac76c95c9','1268421636','','0','1' )
7 SELECT COUNT(*) FROM mos_stats_agents WHERE agent = 'Unknown' AND type = 0
8 UPDATE mos_stats_agents SET hits = ( hits + 1 ) WHERE agent = 'Unknown' AND type = 0
9 SELECT COUNT(*) FROM mos_stats_agents WHERE agent = 'Unknown' AND type = 1
10 UPDATE mos_stats_agents SET hits = ( hits + 1 ) WHERE agent = 'Unknown' AND type = 1
11 SELECT COUNT(*) FROM mos_stats_agents WHERE agent = 'Unknown' AND type = 2
12 UPDATE mos_stats_agents SET hits = ( hits + 1 ) WHERE agent = 'Unknown' AND type = 2
13 SELECT * FROM mos_menu WHERE id = 1
14 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-03-13 06:20' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-13 06:20' ) AND a.access <= 0
15 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-03-13 06:20' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-13 06:20' ) ORDER BY a.ordering
16 UPDATE mos_content SET hits = ( hits + 1 ) WHERE id = '163'
17 SELECT hits FROM mos_core_log_items WHERE time_stamp = '2010-03-13' AND item_table = '#__content' AND item_id = '163'
18 INSERT INTO mos_core_log_items VALUES ( '2010-03-13', '#__content', '163', 1 )
19 SELECT folder, element, published, params FROM mos_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
20 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'
21 SELECT id, name, link, parent, type, menutype, access FROM mos_menu WHERE published = 1 AND access <= 0 ORDER BY menutype, parent, ordering
22 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
23 SELECT m.* FROM mos_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering
24 SELECT COUNT( id ) FROM mos_menu WHERE type = 'content_typed' AND published = 1
25 SELECT id FROM mos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=66'
26 SELECT COUNT( id ) FROM mos_menu WHERE type = 'content_item_link' AND published = 1
27 SELECT id FROM mos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=189'
28 SELECT m.* FROM mos_menu AS m WHERE menutype = 'othermenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
29 SELECT id FROM mos_menu WHERE link = 'index.php?option=com_events'
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-03-01 00:00:00' AND publish_up <= '2010-03-01 23:59:59') OR (publish_down >= '2010-03-01 00:00:00' AND publish_down <= '2010-03-01 23:59:59') OR (publish_up <= '2010-03-01 00:00:00' AND publish_down >= '2010-03-01 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-03-02 00:00:00' AND publish_up <= '2010-03-02 23:59:59') OR (publish_down >= '2010-03-02 00:00:00' AND publish_down <= '2010-03-02 23:59:59') OR (publish_up <= '2010-03-02 00:00:00' AND publish_down >= '2010-03-02 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-03-03 00:00:00' AND publish_up <= '2010-03-03 23:59:59') OR (publish_down >= '2010-03-03 00:00:00' AND publish_down <= '2010-03-03 23:59:59') OR (publish_up <= '2010-03-03 00:00:00' AND publish_down >= '2010-03-03 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-03-04 00:00:00' AND publish_up <= '2010-03-04 23:59:59') OR (publish_down >= '2010-03-04 00:00:00' AND publish_down <= '2010-03-04 23:59:59') OR (publish_up <= '2010-03-04 00:00:00' AND publish_down >= '2010-03-04 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-03-05 00:00:00' AND publish_up <= '2010-03-05 23:59:59') OR (publish_down >= '2010-03-05 00:00:00' AND publish_down <= '2010-03-05 23:59:59') OR (publish_up <= '2010-03-05 00:00:00' AND publish_down >= '2010-03-05 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-03-06 00:00:00' AND publish_up <= '2010-03-06 23:59:59') OR (publish_down >= '2010-03-06 00:00:00' AND publish_down <= '2010-03-06 23:59:59') OR (publish_up <= '2010-03-06 00:00:00' AND publish_down >= '2010-03-06 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-03-07 00:00:00' AND publish_up <= '2010-03-07 23:59:59') OR (publish_down >= '2010-03-07 00:00:00' AND publish_down <= '2010-03-07 23:59:59') OR (publish_up <= '2010-03-07 00:00:00' AND publish_down >= '2010-03-07 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-03-08 00:00:00' AND publish_up <= '2010-03-08 23:59:59') OR (publish_down >= '2010-03-08 00:00:00' AND publish_down <= '2010-03-08 23:59:59') OR (publish_up <= '2010-03-08 00:00:00' AND publish_down >= '2010-03-08 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-03-09 00:00:00' AND publish_up <= '2010-03-09 23:59:59') OR (publish_down >= '2010-03-09 00:00:00' AND publish_down <= '2010-03-09 23:59:59') OR (publish_up <= '2010-03-09 00:00:00' AND publish_down >= '2010-03-09 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-03-10 00:00:00' AND publish_up <= '2010-03-10 23:59:59') OR (publish_down >= '2010-03-10 00:00:00' AND publish_down <= '2010-03-10 23:59:59') OR (publish_up <= '2010-03-10 00:00:00' AND publish_down >= '2010-03-10 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-03-11 00:00:00' AND publish_up <= '2010-03-11 23:59:59') OR (publish_down >= '2010-03-11 00:00:00' AND publish_down <= '2010-03-11 23:59:59') OR (publish_up <= '2010-03-11 00:00:00' AND publish_down >= '2010-03-11 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-03-12 00:00:00' AND publish_up <= '2010-03-12 23:59:59') OR (publish_down >= '2010-03-12 00:00:00' AND publish_down <= '2010-03-12 23:59:59') OR (publish_up <= '2010-03-12 00:00:00' AND publish_down >= '2010-03-12 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-03-13 00:00:00' AND publish_up <= '2010-03-13 23:59:59') OR (publish_down >= '2010-03-13 00:00:00' AND publish_down <= '2010-03-13 23:59:59') OR (publish_up <= '2010-03-13 00:00:00' AND publish_down >= '2010-03-13 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-03-14 00:00:00' AND publish_up <= '2010-03-14 23:59:59') OR (publish_down >= '2010-03-14 00:00:00' AND publish_down <= '2010-03-14 23:59:59') OR (publish_up <= '2010-03-14 00:00:00' AND publish_down >= '2010-03-14 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-03-15 00:00:00' AND publish_up <= '2010-03-15 23:59:59') OR (publish_down >= '2010-03-15 00:00:00' AND publish_down <= '2010-03-15 23:59:59') OR (publish_up <= '2010-03-15 00:00:00' AND publish_down >= '2010-03-15 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-03-16 00:00:00' AND publish_up <= '2010-03-16 23:59:59') OR (publish_down >= '2010-03-16 00:00:00' AND publish_down <= '2010-03-16 23:59:59') OR (publish_up <= '2010-03-16 00:00:00' AND publish_down >= '2010-03-16 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-03-17 00:00:00' AND publish_up <= '2010-03-17 23:59:59') OR (publish_down >= '2010-03-17 00:00:00' AND publish_down <= '2010-03-17 23:59:59') OR (publish_up <= '2010-03-17 00:00:00' AND publish_down >= '2010-03-17 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-03-18 00:00:00' AND publish_up <= '2010-03-18 23:59:59') OR (publish_down >= '2010-03-18 00:00:00' AND publish_down <= '2010-03-18 23:59:59') OR (publish_up <= '2010-03-18 00:00:00' AND publish_down >= '2010-03-18 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-03-19 00:00:00' AND publish_up <= '2010-03-19 23:59:59') OR (publish_down >= '2010-03-19 00:00:00' AND publish_down <= '2010-03-19 23:59:59') OR (publish_up <= '2010-03-19 00:00:00' AND publish_down >= '2010-03-19 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-03-20 00:00:00' AND publish_up <= '2010-03-20 23:59:59') OR (publish_down >= '2010-03-20 00:00:00' AND publish_down <= '2010-03-20 23:59:59') OR (publish_up <= '2010-03-20 00:00:00' AND publish_down >= '2010-03-20 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-03-21 00:00:00' AND publish_up <= '2010-03-21 23:59:59') OR (publish_down >= '2010-03-21 00:00:00' AND publish_down <= '2010-03-21 23:59:59') OR (publish_up <= '2010-03-21 00:00:00' AND publish_down >= '2010-03-21 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-03-22 00:00:00' AND publish_up <= '2010-03-22 23:59:59') OR (publish_down >= '2010-03-22 00:00:00' AND publish_down <= '2010-03-22 23:59:59') OR (publish_up <= '2010-03-22 00:00:00' AND publish_down >= '2010-03-22 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-03-23 00:00:00' AND publish_up <= '2010-03-23 23:59:59') OR (publish_down >= '2010-03-23 00:00:00' AND publish_down <= '2010-03-23 23:59:59') OR (publish_up <= '2010-03-23 00:00:00' AND publish_down >= '2010-03-23 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-03-24 00:00:00' AND publish_up <= '2010-03-24 23:59:59') OR (publish_down >= '2010-03-24 00:00:00' AND publish_down <= '2010-03-24 23:59:59') OR (publish_up <= '2010-03-24 00:00:00' AND publish_down >= '2010-03-24 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-03-25 00:00:00' AND publish_up <= '2010-03-25 23:59:59') OR (publish_down >= '2010-03-25 00:00:00' AND publish_down <= '2010-03-25 23:59:59') OR (publish_up <= '2010-03-25 00:00:00' AND publish_down >= '2010-03-25 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-03-26 00:00:00' AND publish_up <= '2010-03-26 23:59:59') OR (publish_down >= '2010-03-26 00:00:00' AND publish_down <= '2010-03-26 23:59:59') OR (publish_up <= '2010-03-26 00:00:00' AND publish_down >= '2010-03-26 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-03-27 00:00:00' AND publish_up <= '2010-03-27 23:59:59') OR (publish_down >= '2010-03-27 00:00:00' AND publish_down <= '2010-03-27 23:59:59') OR (publish_up <= '2010-03-27 00:00:00' AND publish_down >= '2010-03-27 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-03-28 00:00:00' AND publish_up <= '2010-03-28 23:59:59') OR (publish_down >= '2010-03-28 00:00:00' AND publish_down <= '2010-03-28 23:59:59') OR (publish_up <= '2010-03-28 00:00:00' AND publish_down >= '2010-03-28 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-03-29 00:00:00' AND publish_up <= '2010-03-29 23:59:59') OR (publish_down >= '2010-03-29 00:00:00' AND publish_down <= '2010-03-29 23:59:59') OR (publish_up <= '2010-03-29 00:00:00' AND publish_down >= '2010-03-29 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-03-30 00:00:00' AND publish_up <= '2010-03-30 23:59:59') OR (publish_down >= '2010-03-30 00:00:00' AND publish_down <= '2010-03-30 23:59:59') OR (publish_up <= '2010-03-30 00:00:00' AND publish_down >= '2010-03-30 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-03-31 00:00:00' AND publish_up <= '2010-03-31 23:59:59') OR (publish_down >= '2010-03-31 00:00:00' AND publish_down <= '2010-03-31 23:59:59') OR (publish_up <= '2010-03-31 00:00:00' AND publish_down >= '2010-03-31 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-04-01 00:00:00' AND publish_up <= '2010-04-01 23:59:59') OR (publish_down >= '2010-04-01 00:00:00' AND publish_down <= '2010-04-01 23:59:59') OR (publish_up <= '2010-04-01 00:00:00' AND publish_down >= '2010-04-01 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-04-02 00:00:00' AND publish_up <= '2010-04-02 23:59:59') OR (publish_down >= '2010-04-02 00:00:00' AND publish_down <= '2010-04-02 23:59:59') OR (publish_up <= '2010-04-02 00:00:00' AND publish_down >= '2010-04-02 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-04-03 00:00:00' AND publish_up <= '2010-04-03 23:59:59') OR (publish_down >= '2010-04-03 00:00:00' AND publish_down <= '2010-04-03 23:59:59') OR (publish_up <= '2010-04-03 00:00:00' AND publish_down >= '2010-04-03 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-04-04 00:00:00' AND publish_up <= '2010-04-04 23:59:59') OR (publish_down >= '2010-04-04 00:00:00' AND publish_down <= '2010-04-04 23:59:59') OR (publish_up <= '2010-04-04 00:00:00' AND publish_down >= '2010-04-04 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-04-05 00:00:00' AND publish_up <= '2010-04-05 23:59:59') OR (publish_down >= '2010-04-05 00:00:00' AND publish_down <= '2010-04-05 23:59:59') OR (publish_up <= '2010-04-05 00:00:00' AND publish_down >= '2010-04-05 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-04-06 00:00:00' AND publish_up <= '2010-04-06 23:59:59') OR (publish_down >= '2010-04-06 00:00:00' AND publish_down <= '2010-04-06 23:59:59') OR (publish_up <= '2010-04-06 00:00:00' AND publish_down >= '2010-04-06 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-04-07 00:00:00' AND publish_up <= '2010-04-07 23:59:59') OR (publish_down >= '2010-04-07 00:00:00' AND publish_down <= '2010-04-07 23:59:59') OR (publish_up <= '2010-04-07 00:00:00' AND publish_down >= '2010-04-07 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-04-08 00:00:00' AND publish_up <= '2010-04-08 23:59:59') OR (publish_down >= '2010-04-08 00:00:00' AND publish_down <= '2010-04-08 23:59:59') OR (publish_up <= '2010-04-08 00:00:00' AND publish_down >= '2010-04-08 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-04-09 00:00:00' AND publish_up <= '2010-04-09 23:59:59') OR (publish_down >= '2010-04-09 00:00:00' AND publish_down <= '2010-04-09 23:59:59') OR (publish_up <= '2010-04-09 00:00:00' AND publish_down >= '2010-04-09 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-04-10 00:00:00' AND publish_up <= '2010-04-10 23:59:59') OR (publish_down >= '2010-04-10 00:00:00' AND publish_down <= '2010-04-10 23:59:59') OR (publish_up <= '2010-04-10 00:00:00' AND publish_down >= '2010-04-10 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-04-11 00:00:00' AND publish_up <= '2010-04-11 23:59:59') OR (publish_down >= '2010-04-11 00:00:00' AND publish_down <= '2010-04-11 23:59:59') OR (publish_up <= '2010-04-11 00:00:00' AND publish_down >= '2010-04-11 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-04-12 00:00:00' AND publish_up <= '2010-04-12 23:59:59') OR (publish_down >= '2010-04-12 00:00:00' AND publish_down <= '2010-04-12 23:59:59') OR (publish_up <= '2010-04-12 00:00:00' AND publish_down >= '2010-04-12 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-04-13 00:00:00' AND publish_up <= '2010-04-13 23:59:59') OR (publish_down >= '2010-04-13 00:00:00' AND publish_down <= '2010-04-13 23:59:59') OR (publish_up <= '2010-04-13 00:00:00' AND publish_down >= '2010-04-13 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-04-14 00:00:00' AND publish_up <= '2010-04-14 23:59:59') OR (publish_down >= '2010-04-14 00:00:00' AND publish_down <= '2010-04-14 23:59:59') OR (publish_up <= '2010-04-14 00:00:00' AND publish_down >= '2010-04-14 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-04-15 00:00:00' AND publish_up <= '2010-04-15 23:59:59') OR (publish_down >= '2010-04-15 00:00:00' AND publish_down <= '2010-04-15 23:59:59') OR (publish_up <= '2010-04-15 00:00:00' AND publish_down >= '2010-04-15 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-04-16 00:00:00' AND publish_up <= '2010-04-16 23:59:59') OR (publish_down >= '2010-04-16 00:00:00' AND publish_down <= '2010-04-16 23:59:59') OR (publish_up <= '2010-04-16 00:00:00' AND publish_down >= '2010-04-16 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-04-17 00:00:00' AND publish_up <= '2010-04-17 23:59:59') OR (publish_down >= '2010-04-17 00:00:00' AND publish_down <= '2010-04-17 23:59:59') OR (publish_up <= '2010-04-17 00:00:00' AND publish_down >= '2010-04-17 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-04-18 00:00:00' AND publish_up <= '2010-04-18 23:59:59') OR (publish_down >= '2010-04-18 00:00:00' AND publish_down <= '2010-04-18 23:59:59') OR (publish_up <= '2010-04-18 00:00:00' AND publish_down >= '2010-04-18 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-04-19 00:00:00' AND publish_up <= '2010-04-19 23:59:59') OR (publish_down >= '2010-04-19 00:00:00' AND publish_down <= '2010-04-19 23:59:59') OR (publish_up <= '2010-04-19 00:00:00' AND publish_down >= '2010-04-19 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-04-20 00:00:00' AND publish_up <= '2010-04-20 23:59:59') OR (publish_down >= '2010-04-20 00:00:00' AND publish_down <= '2010-04-20 23:59:59') OR (publish_up <= '2010-04-20 00:00:00' AND publish_down >= '2010-04-20 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-04-21 00:00:00' AND publish_up <= '2010-04-21 23:59:59') OR (publish_down >= '2010-04-21 00:00:00' AND publish_down <= '2010-04-21 23:59:59') OR (publish_up <= '2010-04-21 00:00:00' AND publish_down >= '2010-04-21 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 ((publish_up >= '2010-04-22 00:00:00' AND publish_up <= '2010-04-22 23:59:59') OR (publish_down >= '2010-04-22 00:00:00' AND publish_down <= '2010-04-22 23:59:59') OR (publish_up <= '2010-04-22 00:00:00' AND publish_down >= '2010-04-22 23:59:59')) AND state='1' ORDER BY publish_up ASC
83 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-04-23 00:00:00' AND publish_up <= '2010-04-23 23:59:59') OR (publish_down >= '2010-04-23 00:00:00' AND publish_down <= '2010-04-23 23:59:59') OR (publish_up <= '2010-04-23 00:00:00' AND publish_down >= '2010-04-23 23:59:59')) AND state='1' ORDER BY publish_up ASC
84 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-04-24 00:00:00' AND publish_up <= '2010-04-24 23:59:59') OR (publish_down >= '2010-04-24 00:00:00' AND publish_down <= '2010-04-24 23:59:59') OR (publish_up <= '2010-04-24 00:00:00' AND publish_down >= '2010-04-24 23:59:59')) AND state='1' ORDER BY publish_up ASC
85 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-04-25 00:00:00' AND publish_up <= '2010-04-25 23:59:59') OR (publish_down >= '2010-04-25 00:00:00' AND publish_down <= '2010-04-25 23:59:59') OR (publish_up <= '2010-04-25 00:00:00' AND publish_down >= '2010-04-25 23:59:59')) AND state='1' ORDER BY publish_up ASC
86 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-04-26 00:00:00' AND publish_up <= '2010-04-26 23:59:59') OR (publish_down >= '2010-04-26 00:00:00' AND publish_down <= '2010-04-26 23:59:59') OR (publish_up <= '2010-04-26 00:00:00' AND publish_down >= '2010-04-26 23:59:59')) AND state='1' ORDER BY publish_up ASC
87 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-04-27 00:00:00' AND publish_up <= '2010-04-27 23:59:59') OR (publish_down >= '2010-04-27 00:00:00' AND publish_down <= '2010-04-27 23:59:59') OR (publish_up <= '2010-04-27 00:00:00' AND publish_down >= '2010-04-27 23:59:59')) AND state='1' ORDER BY publish_up ASC
88 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-04-28 00:00:00' AND publish_up <= '2010-04-28 23:59:59') OR (publish_down >= '2010-04-28 00:00:00' AND publish_down <= '2010-04-28 23:59:59') OR (publish_up <= '2010-04-28 00:00:00' AND publish_down >= '2010-04-28 23:59:59')) AND state='1' ORDER BY publish_up ASC
89 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-04-29 00:00:00' AND publish_up <= '2010-04-29 23:59:59') OR (publish_down >= '2010-04-29 00:00:00' AND publish_down <= '2010-04-29 23:59:59') OR (publish_up <= '2010-04-29 00:00:00' AND publish_down >= '2010-04-29 23:59:59')) AND state='1' ORDER BY publish_up ASC
90 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-04-30 00:00:00' AND publish_up <= '2010-04-30 23:59:59') OR (publish_down >= '2010-04-30 00:00:00' AND publish_down <= '2010-04-30 23:59:59') OR (publish_up <= '2010-04-30 00:00:00' AND publish_down >= '2010-04-30 23:59:59')) AND state='1' ORDER BY publish_up ASC
91 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-03-13 00:00:00%' AND publish_down >= '2010-03-13 00:00:00%') OR (publish_up <= '2010-05-12 23:59:59%' AND publish_down >= '2010-05-12 23:59:59%') OR (publish_up <= '2010-05-12 23:59:59%' AND publish_up >= '2010-03-13 00:00:00%') OR (publish_down <= '2010-05-12 23:59:59%' AND publish_down >= '2010-03-13 00:00:00%')) ORDER BY publish_up ASC
92 SELECT id FROM mos_menu WHERE link = 'index.php?option=com_events'
93 SELECT id, name FROM mos_categories WHERE section= 'com_events' AND published='1'
94 SELECT id, username, sendEmail, email FROM mos_users WHERE block ='0'
95 SELECT guest, usertype FROM mos_session
96 SELECT m.* FROM mos_menu AS m WHERE menutype = 'topmenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering
97 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-03-13 06:20' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-13 06:20' ) 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
98 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 = 192 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
99 SELECT id FROM mos_menu WHERE type = 'content_blog_section' AND published = 1 AND componentid = 0
100 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 = 191 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
101 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 = 187 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
102 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 = 180 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id