Coimbatore Taxi - Coimbatore to Ooty and Kodaikanal-Munnar-Cochin Tour Packages - Seven Days Ooty-Kodaikanal-Cochin Tour Package from Coimbatore to Ooty and Kodaikanal-Munnar-Cochin. Seven Days Tourist Taxi, Cabs, Car Rentals Packages to Ooty and Kodaikanal-Munnar-Cochin from Coimbatore. Get best travel deals on Coimbatore Ooty and Kodaikanal-Munnar-Cochin local Sight seeing and Holiday Packages, Seven Days Ooty and Kodaikanal-Munnar-Cochin Holidays Packages - Book Ooty Tours and travel packages at Coimbatore taxi.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 initial_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 JOIN package_sites ps ON ps.package_id = b.id AND ps.site_id = c.site_id WHERE b.package = '1' AND ps.site_id = '2' AND c.order_no IS NOT NULL AND c.order_no != '' UNION ALL -- Case 2: Tours without package_order SELECT a.*, a.display_order AS initial_order, '' AS inner_order, CAST(a.display_order AS UNSIGNED) AS final_order FROM ourtours a JOIN package_sites ps ON ps.package_id = a.id WHERE a.package = '1' AND ps.site_id = '2' AND NOT EXISTS ( SELECT 1 FROM package_order e WHERE e.package_id = a.id AND e.site_id = ps.site_id AND e.order_no IS NOT NULL AND e.order_no != '' ) ) AS combined ORDER BY final_order ASC LIMIT 1;