PALANI TAXI. - Book Taxis / Cabs in online, Palani Taxis, Palani Travels, Palani Car Rentals, Palani Cabs, Palani Tour and Travels, Ooty, Munnar, Kodaikanal, Tours and Travels, Ooty, Kodaikanal, Munnar Tour Packages
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 - (Day 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 = '1' 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 = '1' 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;