Coimbatore Taxi Valparai - Athirapally Water Falls Tour Packages - Three Days Valparai - Athirapally Water Falls Tour Package from Coimbatore to Valparai - Athirapally Water Falls. Full Day Tour Taxi, Cabs, Car Rentals Packages to Valparai - Athirapally Water Falls from Coimbatore. Get best travel deals on Coimbatore Valparai - Athirapally Water Falls Holiday Packages, Three Days Valparai - Athirapally Water Falls Holidays Packages - Book Valparai - Athirapally Water Falls Tours & 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