Products tagged with: 'ribbed'

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('9639', '9648', '9744', '6246', '6247', '6248', '7163', '7164', '7165', '7166', '7167', '7168', '7169', '7170', '7171', '7172', '7173', '7174', '9569', '9570', '9571', '9572', '9573', '9611', '9612', '9613', '9614', '9615', '9644', '9645', '9646', '9647', '9684', '9685', '9686', '9687', '9295', '9296', '9297', '9298', '9299', '9406', '9407', '9408', '9409', '9649', '9650', '9651', '9652', '6671', '6672', '6673', '6674', '6675', '6676', '8616', '8639', '8640', '8641', '8642', '8643', '8644', '8788', '9126', '9080', '9081', '9082', '9083', '9765', '7941', '7942', '7943', '7944', '7945', '7946', '7969', '7970', '7971', '7972', '7973', '7974', '8677', '8776', '8777', '8819', '9006', '9007', '8717', '8718', '8719', '8720', '7884', '7885', '7886', '7887', '8756', '7668', '7669', '7670', '7671', '8549', '9300')) 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\\\/ribbed\\\/\",\"formKey\":\"vx3MxhXnv16AmWfM\",\"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"