E31 Coupe 850 CSi
mvp-
thumb_list type 'products' applying template 'gallery'load_filter filter
extfilter=$VAR1 = { 'content' => [], 'category' => [ 518334 ] }; filter=$VAR1 = { 'type' => 'products', 'category' => [ { '' => [ 518334 ], 'id' => $VAR1->{'category'}[0]{''}, 'type' => '14' } ] };
thumb_list inp
$VAR1 = { 'sortby' => 'popular', 'show_child_products' => '1', 'nolimit' => 0, 'category' => [ { '' => [ 518334 ], 'id' => $VAR1->{'category'}[0]{''}, 'type' => '14' } ], 'sortby_nostock' => 0, 'limit' => 24, 'offset' => 0, 'exsku' => [ 'TBA1109019', 'F1901-13' ], 'show_child_products_parent' => undef, 'username' => 'noreg', 'ignore_nostock' => 0, 'show_zero_price' => '1', 'show_empty' => 0, 'base_unit_price' => '0', 'group_id' => 1, 'show_child_product_reviews' => '1', 'type' => 'products', 'inherit' => 'y' };
thumb_list sql (products)
SELECT SQL_CALC_FOUND_ROWS DISTINCT I.SKU, I.inventory_id, (I.store_quantity+I.build_quantity) AS store_quantity, I.committed_quantity, I.preorder_quantity, I.allow_oversell, I.acc_code, I.model, I.brand, I.retail, G.promo_price,I.start_date, I.tax_inc, I.restock_warning_level, I.reorder_quantity, I.notax, I.unit, I.base_unit, I.base_unit_qty, I.promo_start, I.promo_end, (I.promo_start<=NOW() AND I.promo_end>=NOW() AND G.promo_price<IF(G.store_price IS NOT NULL, G.store_price,I.store_price) AND G.promo_price>0) AS inpromo, IF(G.store_price IS NOT NULL, G.store_price,I.store_price) AS store_price, (I.start_date > CURRENT_DATE) AS preorder, I.start_date AS arrival_date, I.misc4 AS artisit_author, I.misc5 AS format, I.misc7 AS manufacturer_model, I.misc9 AS subtitle, I.misc10 AS availability_description, I.misc11 AS length, I.misc12 AS width, I.misc13 AS height, I.actual_length, I.actual_width, I.actual_height, I.misc14 AS barcode, I.misc15 AS product_type, I.itm_subtype AS product_subtype, I.misc38 AS cubic, I.shipping AS weight, I.`misc6` AS misc1,IF(I.`misc16`='y','y','n') AS misc2,I.`misc20` AS misc4,I.`misc32` AS misc5,I.`misc33` AS misc6,I.`misc35` AS misc7,I.`misc36` AS misc8,I.`misc37` AS misc9,I.`misc39` AS misc10,I.`misc40` AS misc11,I.`misc41` AS misc12,I.`misc42` AS misc13,I.`filter1`,I.`filter2` AS misc15,I.`filter2`,I.`filter3` AS misc17,I.`filter3`,I.`filter4` AS misc18,I.`filter4`,IF(I.`misc46`='y','y','n') AS misc19,IF(I.`misc47`='y','y','n') AS misc20,I.`misc48` AS misc21,I.`misc51` AS misc24,I.`misc74` AS misc47,I.`filter5`,I.`filter6`,I.`filter7`,I.`filter8`,I.`filter9`, I.swatch, I.extra, I.service_only, I.coupons, I.free_gifts, I.short_description, I.rental_only, I.sh_type_id, I.itm_gp_id, I.display_template, I.editable_bundle, I.has_components AS is_kit, (I.has_components AND I.editable_bundle='y') AS has_components, DATE(I.date_created) AS date_created, I.itm_sortorder, I.itm_sortorder2 FROM INVENTORY I INNER JOIN INVENTORY_CONTENTS O1 ON (I.inventory_id=O1.inventory_id) INNER JOIN CONTENT_LEVELS CL1 ON (O1.content_id=CL1.content_id) LEFT JOIN INVENTORY_RECORDS R ON (I.inventory_id=R.inventory_id) LEFT JOIN INVENTORY_PRICES G ON (I.inventory_id=G.inventory_id AND G.group_id='1') WHERE I.visible = 'Y' AND I.approval = 'y' AND (I.gp_restriction=0 OR I.gp_restriction & '1') AND CL1.related_content_id='518334' AND I.SKU NOT IN ('TBA1109019','F1901-13') ORDER BY R.item_rank DESC, I.itm_sortorder,I.model,I.brand, I.inventory_id LIMIT 24 OFFSET 0
thumb_list total_sql
SELECT FOUND_ROWS()