Cacher is the code snippet organizer for pro developers

<mvt:foreach iterator="product" array="products">
	<mvt:item name="toolkit" param="attr|acount|l.all_settings:product:id" />
	<mvt:if expr="g.acount GT 0">
	<mvt:item name="toolkit" param="variantarray|vcount|l.all_settings:product:code" />
	<mvt:foreach iterator="variant" array="variants">
	<mvt:assign name="l.settings:query:query" value="'SELECT id FROM s01_Products WHERE code =  \"'$ l.settings:variant:variant_code $'\"'" />
		<mvt:item name="sql" param="l.settings:query" />
		<mvt:foreach iterator="q" array="query:results">
			<mvt:assign name="variantid" value="l.settings:q" />
		</mvt:foreach>
	</mvt:foreach>
	<mvt:assign name="l.settings:update1:query" value="'UPDATE s01_SS_REVIEWS_reviews SET product_id = ' $ l.settings:product:id $ ' WHERE product_id = ' $ g.variantid" />
	<mvt:assign name="l.settings:update2:query" value="'UPDATE s01_SS_REVIEWS_ratings SET product_id = ' $ l.settings:product:id $ ' WHERE product_id = ' $ g.variantid" />
	<mvt:item name="sql" param="l.settings:update1" />
	<mvt:item name="sql" param="l.settings:update2" />
	</mvt:if>
</mvt:foreach>