mvp-

thumb_list type 'products' applying template 'gallery'

load_filter filter

extfilter=$VAR1 = {
          'content' => [],
          'category' => [
                          526510
                        ]
        };

filter=$VAR1 = {
          'type' => 'products',
          'category' => [
                          {
                            '' => [
                                    526510
                                  ],
                            'id' => $VAR1->{'category'}[0]{''},
                            'type' => '14'
                          }
                        ]
        };

thumb_list inp

$VAR1 = {
          'sortby' => 'popular',
          'show_child_products' => '1',
          'nolimit' => 0,
          'category' => [
                          {
                            '' => [
                                    526510
                                  ],
                            '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='526510'
		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