Coimbatore Taxi - Coimbatore -Ooty-Coimbatore Tour Packages - Five Days Ooty-Coimbatore Tour Package from Coimbatore to Ooty. Five Days Tourist Taxi, Cabs, Car Rentals Packages to Ooty from Coimbatore. Get best travel deals on Coimbatore Ooty local Sight seeing and Holiday Packages, Five Days Ooty Holidays Packages - Book Ooty Tours and travel packages at Coimbatoretaxi.com - Royal Travel.
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;