cannot calculate position of (`rpnycorgnz2`.`kezjez_3_posts`.`post_date`,'%d-%b-%Y') within )
UNION
select kezjez_3_woocommerce_order_items.order_item_id, kezjez_3_woocommerce_order_items.order_item_name, kezjez_3_woocommerce_order_items.order_item_type, kezjez_3_woocommerce_order_items.order_id, linetotal.meta_value, rpnyc_vw_woocommerce_billing_names.name, date_format(`rpnycorgnz2`.`kezjez_3_posts`.`post_date`,'%d-%b-%Y') as payment_date
from kezjez_3_woocommerce_order_items
left join kezjez_3_woocommerce_order_itemmeta linetotal on (linetotal.order_item_id=kezjez_3_woocommerce_order_items.order_item_id)
left join rpnyc_vw_woocommerce_billing_names on (rpnyc_vw_woocommerce_billing_names.post_id=kezjez_3_woocommerce_order_items.order_id)
join kezjez_3_posts on (kezjez_3_woocommerce_order_items.order_id = kezjez_3_posts.ID)
where linetotal.meta_key='_line_total'
and (kezjez_3_posts.post_status like '%Complete%' or kezjez_3_posts.post_status like '%Processing%')
ORDER BY STR_TO_DATE(payment_date, '%d-%M-%Y') DESC
Paypal monthly reconciliation
sortfield Month sortmonth Product Sales ($)
1
Sep-2015
2015-09
Inshore Racing Entry
6165
1
Sep-2015
2015-09
Offshore Racing Entry
550
3
Sep-2015
2015-09
Club Total
6715
1
Oct-2015
2015-10
Inshore Racing Entry
1160
1
Oct-2015
2015-10
Luau Hawaiian party
1170
1
Oct-2015
2015-10
Membership renewal
840
1
Oct-2015
2015-10
Offshore Racing Entry
1185
3
Oct-2015
2015-10
Club Total
4355
1
Nov-2015
2015-11
2015 Christmas party
450
1
Nov-2015
2015-11
Inshore Racing Entry
0
1
Nov-2015
2015-11
Membership renewal
1000
1
Nov-2015
2015-11
Offshore Racing Entry
445
1
Nov-2015
2015-11
Rum tasting
200
3
Nov-2015
2015-11
Club Total
2095
1
Dec-2015
2015-12
Membership renewal
1060
1
Dec-2015
2015-12
Port Nicholson Regatta Entry
1850
1
Dec-2015
2015-12
Race entry
265
3
Dec-2015
2015-12
Club Total
3175
1
Jan-2016
2016-01
Membership renewal
420
1
Jan-2016
2016-01
Port Nicholson Regatta Entry
2175
1
Jan-2016
2016-01
Race entry
170
3
Jan-2016
2016-01
Club Total
2765
1
Feb-2016
2016-02
Membership renewal
3580
1
Feb-2016
2016-02
Port Nicholson Regatta Entry
2675
1
Feb-2016
2016-02
Race entry
60
3
Feb-2016
2016-02
Club Total
6315
1
Mar-2016
2016-03
Membership renewal
1900
1
Mar-2016
2016-03
Race entry
60
1
Mar-2016
2016-03
Youth Scheme quiz night
420
3
Mar-2016
2016-03
Club Total
2380
1
Apr-2016
2016-04
Membership renewal
6020
1
Apr-2016
2016-04
Race entry
340
1
Apr-2016
2016-04
Youth Scheme quiz night - 7th of April
1085
3
Apr-2016
2016-04
Club Total
7445
1
May-2016
2016-05
Membership renewal
1620
1
May-2016
2016-05
Prizegiving 2016
1597
1
May-2016
2016-05
Race entry
90
1
May-2016
2016-05
Winter series entry
850
3
May-2016
2016-05
Club Total
4157
1
Jun-2016
2016-06
Membership renewal
1720
1
Jun-2016
2016-06
Raise the roof quiz night - 24th of June
525
1
Jun-2016
2016-06
RPNYC burgee
160
1
Jun-2016
2016-06
Winter series entry
1215
3
Jun-2016
2016-06
Club Total
3620
1
Jul-2016
2016-07
Membership renewal
1420
1
Jul-2016
2016-07
Winter series entry
250
3
Jul-2016
2016-07
Club Total
1670
1
Aug-2016
2016-08
Membership renewal
1160
1
Aug-2016
2016-08
RPNYC burgee
320
1
Aug-2016
2016-08
Winter series entry
20
3
Aug-2016
2016-08
Club Total
1500
1
Sep-2016
2016-09
Kapiti cheese and Tuatara beer tasting
210
1
Sep-2016
2016-09
Learn to sail #437
0
1
Sep-2016
2016-09
Membership renewal
3060
1
Sep-2016
2016-09
Race entry
5405
1
Sep-2016
2016-09
RPNYC burgee
40
3
Sep-2016
2016-09
Club Total
8715
1
Oct-2016
2016-10
Membership renewal
2250
1
Oct-2016
2016-10
Race entry
275
1
Oct-2016
2016-10
Spring cocktail party
580
3
Oct-2016
2016-10
Club Total
3105
1
Nov-2016
2016-11
2016-17 Almanac
10
1
Nov-2016
2016-11
Christmas champagne breakfast
1120
1
Nov-2016
2016-11
Membership renewal
1100
1
Nov-2016
2016-11
Race entry
535
1
Nov-2016
2016-11
RPNYC burgee
40
3
Nov-2016
2016-11
Club Total
2805
1
Dec-2016
2016-12
Christmas champagne breakfast
480
1
Dec-2016
2016-12
Membership renewal
1320
1
Dec-2016
2016-12
Port Nicholson Regatta Entry
225
1
Dec-2016
2016-12
Race entry
120
3
Dec-2016
2016-12
Club Total
2145
1
Jan-2017
2017-01
Membership renewal
1350
1
Jan-2017
2017-01
Port Nicholson Regatta Entry
1225
1
Jan-2017
2017-01
Race entry
85
3
Jan-2017
2017-01
Club Total
2660
1
Feb-2017
2017-02
2016-17 season/race entry
390
1
Feb-2017
2017-02
Membership renewal
2100
1
Feb-2017
2017-02
Port Nicholson Regatta Entry
2250
1
Feb-2017
2017-02
Regatta meal packages
115
3
Feb-2017
2017-02
Club Total
4855
1
Mar-2017
2017-03
2016-17 season/race entry
145
1
Mar-2017
2017-03
Membership renewal
2355
1
Mar-2017
2017-03
Port Nicholson Regatta Entry
900
1
Mar-2017
2017-03
Regatta meal packages
1260
3
Mar-2017
2017-03
Club Total
4660
1
Apr-2017
2017-04
2016-17 season/race entry
0
1
Apr-2017
2017-04
2017 prize-giving
504
1
Apr-2017
2017-04
Membership renewal
4780
3
Apr-2017
2017-04
Club Total
5284
1
May-2017
2017-05
2017 prize-giving
972
1
May-2017
2017-05
Membership renewal
1840
3
May-2017
2017-05
Club Total
2812
5
May-2017
2017-05
2017 quiz night
910
9
May-2017
2017-05
Youth Total
910