Wrong SQL in class.yith-wcwl.php

Hi, we have the same problem, it’s about malformed query generated by method “get_products” in class.yith-wcwl.php

I have fixed as follow the method:

Line 620-633:

if( ! empty( $id ) ){
                    $sql .= " AND <code>i.ID</code> = %d";
                    $sql_args[] = $id;
                }

                $sql .= " GROUP BY i.prod_id, l.ID";

                if( ! empty( $limit ) ){
                    $sql .= " LIMIT " . $offset . ", " . $limit;
                }

                $wishlist = $wpdb->get_results( $wpdb->prepare( $sql, $sql_args ), ARRAY_A );

Complete File
Ciao ??

Hi Guys

thank you for your report ??

we already fixed this problem on our dev trunk, and we will release the fix ASAP

Unfortunately, we’re in the middle of WC 2.6 compatibility fixes, so we may need some time before we can send a stable revision of the plugin

Thank you again
Have a nice day ??