SELECT ra.image_name, a.id, a.title, a.description, a.url_slug FROM rotation_articles ra, articles a
WHERE ra.article_id = a.id AND ra.disp_status = '1' AND ra.hpa_site_id = 1 ORDER BY ra.rotation_order LIMIT 1
Vietnam is a country with lots to offer the intrepid traveller. One week will barely scratch the surface and with two large cities both serviced by direct flights on airlines originating from Kuala Lumpur, flying into one and out of the other makes perfect sense.
On March 8, Malaysia Airlines released a statement confirming that flight MH370 had lost contact with Subang Air Traffic Control. Here's what we know so far.
Troubles in tin town? Read about Perak's tumultuous history that saw invaders coming from all over for a piece of the treasure: tin!
Perak offers many gems of interest to the tourist, and Manveen Mann has the run-down of the places that should be on your radar when heading to the silver state.
Sitting in any nice restaurant in KL, you might forget for a moment that you're not in a western city. As Chad Merchant has unhappily discovered, however, that similarity ends when it comes to service.
Penang has long held a special place in the hearts of locals and tourists alike. David Bowden traipses through the streets of George Town to find a city that celebrates its heritage while embracing facets of modernity.
A Look at the Collaboration between Home-Grown Fashion Label Dude & Duchess and Designer Jonathan Liang
Homegrown cult fashion label Dude & Duchess tapped local designer Jonathan Liang for an accessible high-fashion collection. Desmond Lim Zhengs has the lowdown on this popular label.
It has been said that good things come in small packages. Vatsala Devi speaks to a pint-sized Malaysian singer-songwriter who is taking the music world by storm.
Gavin Yap, a Malaysian actor for film and theatre has recently tried his hand in directing a movie for the big screen.
The photos of the two men who used stolen passports to board Malaysia Airlines flight MH370 to Beijing last Saturday was released yesterday evening.
The Future Music Festival Asia 2014 will be hitting Malaysian grounds again this week from 13 to 15 March 2014 at the Bukit Jalil National Stadium, Kuala Lumpur.
The Malaysian authorities will soon release pictures of the two passengers who boarded flight MH370 on Saturday using stolen passports.
The two passengers using stolen passports on board the missing Malaysia Airlines flight MH370 did not buy a return ticket.