Search Results For: "bags"

ERROR: SELECT if(locate(`products`.manufacturers_id, '97,92,87,41,118,209,286,322,8' ),1,0) AS top_mfg_sort, `products`.`manufacturers_id` as products_manufacturers_id , `products`.`products_id` as products_products_id , `products`.`products_quantity` as products_products_quantity , `products`.`sales_end_date` as products_sales_end_date , `products`.`products_price` as products_products_price , `products`.`products_price_sale` as products_products_price_sale , `products`.`rush_option_id` as products_rush_option_id , `products`.`rush_free` as products_rush_free , `products`.`products_production_time` as products_products_production_time , `products`.`show_std_price` as products_show_std_price, `products_prices`.`products_prices_id` as products_prices_products_prices_id , `products_prices`.`products_id` as products_prices_products_id , `products_prices`.`products_price` as products_prices_products_price , `products_prices`.`products_sale_price` as products_prices_products_sale_price , `products_prices`.`products_std_price` as products_prices_products_std_price , `products_prices`.`products_rush_price` as products_prices_products_rush_price , `products_prices`.`products_price_qty` as products_prices_products_price_qty , `products_prices`.`order` as products_prices_order , `products_images`.`products_images_id` as products_images_products_images_id , `products_images`.`products_id` as products_images_products_id , `products_images`.`type` as products_images_type , `products_images`.`image` as products_images_image , `products_images`.`title` as products_images_title , `products_description`.`products_id` as products_description_products_id , `products_description`.`products_name` as products_description_products_name , `products_description`.`products_description_brief` as products_description_products_description_brief , `products_to_flags`.`products_id` as products_to_flags_products_id, `products_to_flags`.`flag_id` as products_to_flags_flag_id, `flags`.`flag_id` as `flags_flag_id`, `flags`.`name` as flags_name, `flags`.`image` as flags_image, `flags`.`title` as flags_title,`reviews`.`products_id` as review_products_id, `reviews`.`reviews_id` as review_id, `reviews`.`reviews_rating` as review_rating FROM `products` LEFT JOIN `products_prices` ON `products`.`products_id`=`products_prices`.`products_id` LEFT JOIN `products_images` ON `products`.`products_id`=`products_images`.`products_id` LEFT JOIN `products_description` ON `products`.`products_id`=`products_description`.`products_id` LEFT JOIN `products_to_flags` ON `products`.`products_id`=`products_to_flags`.`products_id` LEFT JOIN `flags` ON `products_to_flags`.`flag_id`=`flags`.`flag_id` LEFT JOIN `reviews` ON (`products`.`products_id`=`reviews`.`products_id` and `reviews`.`approved`=1) where `products`.`products_id` in (30962,18884,18896,29997,18888,18871,18891,14428,24155,30918,18867,31126,17310,31160,14430,25616,17312,31930,4965,32480,24674,18858,30913,11846)