חיפוש – ארכיון הסרטים הישראלי

רגעים

string(3017) " SELECT items.order_item_id as cardID, order_item_name as title, order_id, userdata.meta_value as userID, imeta2.meta_value as startDate, imeta3.meta_value as endDate, imeta4.meta_value as used, imeta5.meta_value as limits, imeta6.meta_value as movies_category, imeta7.meta_value as product_id, imeta8.meta_value as weight, imeta9.meta_value as is_bundle, usermeta.meta_value as connectedUser FROM wp_woocommerce_order_items AS items INNER JOIN wp_woocommerce_order_itemmeta AS imeta1 ON imeta1.order_item_id = items.order_item_id AND imeta1.meta_key = 'is_active' AND imeta1.meta_value = 1 AND imeta1.meta_value = 1 LEFT JOIN wp_woocommerce_order_itemmeta AS imeta2 ON imeta2.order_item_id = items.order_item_id AND imeta2.meta_key = 'start_date' AND (imeta2.meta_value = '' OR imeta2.meta_value <= 1760950622) LEFT JOIN wp_woocommerce_order_itemmeta AS imeta3 ON imeta3.order_item_id = items.order_item_id AND imeta3.meta_key = 'end_date' INNER JOIN wp_woocommerce_order_itemmeta AS imeta4 ON imeta4.order_item_id = items.order_item_id AND imeta4.meta_key = 'used' INNER JOIN wp_woocommerce_order_itemmeta AS imeta5 ON imeta5.order_item_id = items.order_item_id AND imeta5.meta_key = 'limit' AND imeta5.meta_value - imeta4.meta_value > 0 LEFT JOIN wp_woocommerce_order_itemmeta AS imeta6 ON imeta6.order_item_id = items.order_item_id AND imeta6.meta_key = 'movies_categories' INNER JOIN wp_woocommerce_order_itemmeta AS imeta7 ON imeta7.order_item_id = items.order_item_id AND imeta7.meta_key = '_product_id' LEFT JOIN wp_woocommerce_order_itemmeta AS imeta8 ON imeta8.order_item_id = items.order_item_id AND imeta8.meta_key = 'weight' LEFT JOIN wp_woocommerce_order_itemmeta AS imeta9 ON imeta9.order_item_id = items.order_item_id AND imeta9.meta_key = 'is_bundle' LEFT JOIN wp_woocommerce_order_itemmeta AS usermeta ON usermeta.order_item_id = items.order_item_id AND usermeta.meta_key = 'connected_user' INNER JOIN wp_posts as orderTable on orderTable.ID = order_id AND orderTable.post_status != 'trash' INNER JOIN wp_postmeta as userdata ON items.order_id = userdata.post_id AND userdata.meta_key = '_customer_user' GROUP BY items.order_item_id HAVING (userID = 0 AND connectedUser IS NULL OR connectedUser = '') AND (movies_category IS NULL OR movies_category IN (89481) OR is_bundle > 0 OR is_bundle IS NULL AND connectedUser = '') AND (endDate is NULL OR endDate >= 1760950622 OR endDate = '') ORDER BY convert(weight, decimal ) DESC, startDate, cardID "

איזה כיף, המתנה בדרך!

Newsletter