Products tagged with: 'fuzzy'

SELECT `e`.*, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status`, IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) AS `visibility`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '273') AND `at_status_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '273') AND (`at_status`.`store_id` = 1) INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id IN(1) INNER JOIN `catalog_product_entity_int` AS `at_visibility_default` ON (`at_visibility_default`.`entity_id` = `e`.`entity_id`) AND (`at_visibility_default`.`attribute_id` = '526') AND `at_visibility_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`entity_id` = `e`.`entity_id`) AND (`at_visibility`.`attribute_id` = '526') AND (`at_visibility`.`store_id` = 1) LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = 1) AND (`e`.`entity_id` IN('9620', '9426', '9318', '8874', '8875', '8876', '8877', '8878', '9301', '9339', '9340', '9341', '9342', '9343', '9354', '8070', '8071', '8072', '8073', '8879', '8894', '8042', '8043', '8044', '8046', '8919', '8920', '8921', '8925', '9131', '4868', '4869', '4870', '4871', '4877', '6087', '6088', '4927', '4928', '4929', '4930', '4931', '7344', '7345', '7346', '4884', '4885', '4886', '4887', '4888', '4874', '4878', '8158', '8159', '8160', '8161', '8162', '6862', '6863', '6864', '6865', '6866', '6867', '6868', '6869', '9422', '9423', '9424', '9425', '6853', '6854', '9432', '9433', '9434', '9435', '6872', '6873', '6874', '6875', '6876', '9565', '9566', '9567', '9568', '6095', '6096', '6097', '6098', '6099', '6469', '6470', '9616', '9617', '9618', '9619', '8045')) AND (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) IN(2, 3, 4)) ORDER BY `e`.`entity_id` DESC, `e`.`entity_id` asc LIMIT 12

Order Column: e.entity_id Order Direction: DESC Order Column: e.entity_id Order Direction: asc order by: "position" D: "asc"options: "{\"productListToolbarForm\":{\"mode\":\"product_list_mode\",\"direction\":\"product_list_dir\",\"order\":\"product_list_order\",\"limit\":\"product_list_limit\",\"modeDefault\":\"grid\",\"directionDefault\":\"asc\",\"orderDefault\":\"position\",\"limitDefault\":12,\"url\":\"https:\\\/\\\/letowholesale.com\\\/tag\\\/product\\\/view\\\/tag\\\/fuzzy\\\/\",\"formKey\":\"vht0BWWmvMrPdosO\",\"post\":false}}" D: "asc"options: {"type":"Magento\\Catalog\\Block\\Product\\ProductList\\Toolbar\\Interceptor","_current_grid_order":"position","_current_grid_mode":"grid","_current_limit":12,"_current_grid_direction":"asc"} D: "asc"