Property (35)
  Properties for Sale (0)
  Houses & Flats to rent (0)
  Holiday Rentals (0)
  House Swap (0)
  Flatshare - Houseshare (0)
  Parking - Storage (0)
  Commercial (35)

Vehicles (0)
  Used Cars (0)
  Used Motorcycles (0)
  Caravans & Motorhomes (0)
  Used Trucks (0)
  Car Parts (0)
  Used Boats (0)

Buy & Sell (0)
  Antiques + Jewellery (0)
  Art - Books - Collectables (0)
  Audio - TVs - Video (0)
  CDs - DVDs - Video Games (0)
  Food (0)
  Hand Made (0)
  Health - Diet - Beauty (0)
  Home Appliances (0)
  House & Garden (0)
  Kids' corner (0)
  Professional Equipment (0)
  Sports Equipment - Bicycles (0)
  Tickets (travel) (0)
  Used Clothes & Accessories (0)
  Used Computers - PDAs (0)
  Used Furniture (0)
  Other (0)

Classes (0)
  Art (0)
  Computer Courses (0)
  Language courses (0)
  Professional Training (0)
  Private lessons (0)
  Sport Classes (0)
  Other Classes (0)

Community (0)
  Artists (0)
  Carpool (0)
  Charity - Volunteers (0)
  Free Stuff - Swap (0)
  Lost & Found (0)
  Missing People - Connections (0)
  Restaurants (0)
  Recipes (0)
  sports teams/partners (0)
  skills/language swap (0)
  Weekend Activities (0)
  Other Local Events (0)

Jobs (0)
  Accounting jobs (0)
  Advertising/PR/marketing (0)
  Building/Engineering (0)
  Caretakers/Handymen (0)
  Chefs/Cooks/Kitchen (0)
  Computing/IT (0)
  Data entry/Admin (0)
  Farm/Garden/Landscape (0)
  Health/Beauty (0)
  Homecare/Special care (0)
  HR/training (0)
  Job training/Open days (0)
  Legal/Paralegal (0)
  Media/Design/Creative (0)
  Part time (0)
  Reception (0)
  Retail jobs (0)
  Sales jobs (0)
  Sec/PA/Office manage (0)
  Student/Graduate (0)
  Teaching/Nursery (0)
  Travel/Overseas (0)
  Warehouse jobs /Driving (0)
  Workshop/Mechanic/Auto (0)
  Work wanted (0)
  Other Jobs (0)

Services (0)
  Building/Home/Removal (0)
  Computer/Telecom (0)
  Entertainment (0)
  Health and beauty (0)
  Property (0)
  Shipping (0)
  Travel (0)
  Tax/Money/Legal/Visas (0)
  Other Services (0)


  Featured Ads
  Upcoming Featured Events
SELECT a.*, UNIX_TIMESTAMP(a.starton) AS starton_ts, UNIX_TIMESTAMP(a.endon) AS endon_ts, feat.adid AS isfeat, COUNT(*) AS piccount, p.picfile AS picfile, ct.cityname FROM xzclf_events a INNER JOIN xzclf_featured feat ON a.adid = feat.adid AND feat.adtype = 'E' AND feat.featuredtill >= NOW() INNER JOIN xzclf_cities ct ON a.cityid = ct.cityid LEFT OUTER JOIN xzclf_adpics p ON a.adid = p.adid AND p.isevent = '1' WHERE a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() AND a.paid <> '0' AND a.starton >= NOW() GROUP BY a.adid ORDER BY a.starton ASC LIMIT 5Table './eastcals_one/xzclf_events' is marked as crashed and last (automatic?) repair failed