Coimbatore Taxi Coimbatore to Munnar Tour Packages - Two Days Coimbatore Munnar Tour Package from Coimbatore to Munnar. Two Days Tourist Taxi, Cabs, Car Rentals Packages to Munnar from Coimbatore. Get best travel deals on Coimbatore Munnar local Sight seeing and Holiday Packages, Two Days Munnar Holidays Packages - Book Munnar Tours and travel packages at Coimbatoretaxi.com - Royal Travels.
Registered with
Registered with: Ministry of Tourism - Government of India
  •  
    • Customer Login
  • Enquiry
  • Payment
  • Cancellation
  • 24X7 Call : +91 73738 12345
  • Online Cab Booking
  • Home
  • Tariff
    • Local Tariff - (Hour Basis)
    • Out Station Tariff - (Km Basis)
    • One Way Dropping (Fixed)
    • One Way Dropping (Km Basis)
    • Corporate Bookings
    • SELECT * FROM ( -- Case 1: Tours with package_order SELECT b.*, b.display_order AS intial_order, c.order_no AS inner_order, CAST(c.order_no AS UNSIGNED) AS final_order FROM package_order c JOIN ourtours b ON c.package_id = b.id WHERE b.package = '1' AND FIND_IN_SET('2', b.siteid) <> 0 AND c.site_id = '2' AND c.order_no != '' AND c.order_no IS NOT NULL UNION ALL -- Case 2: Tours without package_order SELECT a.*, a.display_order AS intial_order, '' AS inner_order, CAST(a.display_order AS UNSIGNED) AS final_order FROM ourtours a WHERE a.package = '1' AND FIND_IN_SET('2', a.siteid) <> 0 AND NOT EXISTS ( SELECT 1 FROM package_order e WHERE e.package_id = a.id AND e.site_id = '2' AND e.order_no != '' AND e.order_no IS NOT NULL ) ) AS combined ORDER BY final_order ASC LIMIT 1