| SQLSTATE |
42S22 |
| EXCEPTIONS |
<small><i>not set</i></small> |
| DATASOURCE |
GolfTrips_661 |
| VENDORERRORCODE |
1054 |
| SQL |
SELECT Distinct(ID), CID, Coupon.Coupon, CouponExp, Coupon.CouponDesc,
Courses.id, Courses.Name, Courses.City, Courses.phone, Courses.courselogo,
Courses.courselogoheight, Courses.courselogowidth, 'Course' as CourseType,
Courses.Name as URL, CASE WHEN Client = '' then 'No' else IFNULL(Client,'No') end as ClientYesNo,
rate_discount, rate_regular, Coupon_Cart_Code, Coupon_Cart_msg, Coupon_Players_Code, Coupon_Players_msg,
Coupon_Holes_Code, Coupon_Holes_msg, Coupon_Age_Code, Coupon_Age_msg, DATE_FORMAT(CouponExp, "%d/%m/%Y") as ExpirationDate
FROM Courses
INNER JOIN Coupon ON WiGolfID = ID
LEFT OUTER JOIN coupon_holes ON Coupon.holes_dd = Coupon_holes_ID
LEFT OUTER JOIN coupon_cart ON Coupon.cart_dd = Coupon_cart_id
LEFT OUTER JOIN coupon_golfers ON Coupon.golfers_dd = coupon_players_id
LEFT OUTER JOIN coupon_age ON Coupon.age_dd = coupon_age_id
WHERE Coupon.Coupon IS NOT Null
AND State = 'NV'
AND Coupon.couponexp>= {d '2025-01-22'}
AND IFNULL(Coupon.couponStart, NOW())<={d '2025-01-22'}
UNION
SELECT NonCourse.ID, NonCourse.ID, Coupon, CouponExp, CouponDesc, 0, Name, City, Phone, ImageName,
ImageHeight, ImageWidth, 'Non' as CourseType, URL, 'No' as ClientYesNo, '', '', '',
'', '', '', '', '', '', '', ''
FROM NonCourse
INNER JOIN NonCourseCoupon ON NonCourseCoupon.ID = NonCourse.ID
WHERE Coupon IS NOT Null and couponexp>= {d '2025-01-22'}
AND State = 'NV'
ORDER BY ClientYesNo desc, Name |
|