basket_products_data <style>


	table.cfdump_wddx,
	table.cfdump_xml,
	table.cfdump_struct,
	table.cfdump_varundefined,
	table.cfdump_array,
	table.cfdump_query,
	table.cfdump_cfc,
	table.cfdump_object,
	table.cfdump_binary,
	table.cfdump_udf,
	table.cfdump_udfbody,
	table.cfdump_udfarguments {
		font-size: xx-small;
		font-family: verdana, arial, helvetica, sans-serif;
		cell-spacing: 2px;
	}

	table.cfdump_wddx th,
	table.cfdump_xml th,
	table.cfdump_struct th,
	table.cfdump_varundefined th,
	table.cfdump_array th,
	table.cfdump_query th,
	table.cfdump_cfc th,
	table.cfdump_object th,
	table.cfdump_binary th,
	table.cfdump_udf th,
	table.cfdump_udfbody th,
	table.cfdump_udfarguments th {
		text-align: left;
		color: white;
		padding: 5px;
	}

	table.cfdump_wddx td,
	table.cfdump_xml td,
	table.cfdump_struct td,
	table.cfdump_varundefined  td,
	table.cfdump_array td,
	table.cfdump_query td,
	table.cfdump_cfc td,
	table.cfdump_object td,
	table.cfdump_binary td,
	table.cfdump_udf td,
	table.cfdump_udfbody td,
	table.cfdump_udfarguments td {
		padding: 3px;
		background-color: #ffffff;
		vertical-align : top;
	}

	table.cfdump_wddx {
		background-color: #000000;
	}
	table.cfdump_wddx th.wddx {
		background-color: #444444;
	}


	table.cfdump_xml {
		background-color: #888888;
	}
	table.cfdump_xml th.xml {
		background-color: #aaaaaa;
	}
	table.cfdump_xml td.xml {
		background-color: #dddddd;
	}

	table.cfdump_struct {
		background-color: #0000cc ;
	}
	table.cfdump_struct th.struct {
		background-color: #4444cc ;
	}
	table.cfdump_struct td.struct {
		background-color: #ccddff;
	}

	table.cfdump_varundefined {
		background-color: #CC3300 ;
	}
	table.cfdump_varundefined th.varundefined {
		background-color: #CC3300 ;
	}
	table.cfdump_varundefined td.varundefined {
		background-color: #ccddff;
	}

	table.cfdump_array {
		background-color: #006600 ;
	}
	table.cfdump_array th.array {
		background-color: #009900 ;
	}
	table.cfdump_array td.array {
		background-color: #ccffcc ;
	}

	table.cfdump_query {
		background-color: #884488 ;
	}
	table.cfdump_query th.query {
		background-color: #aa66aa ;
	}
	table.cfdump_query td.query {
		background-color: #ffddff ;
	}


	table.cfdump_cfc {
		background-color: #ff0000;
	}
	table.cfdump_cfc th.cfc{
		background-color: #ff4444;
	}
	table.cfdump_cfc td.cfc {
		background-color: #ffcccc;
	}


	table.cfdump_object {
		background-color : #ff0000;
	}
	table.cfdump_object th.object{
		background-color: #ff4444;
	}

	table.cfdump_binary {
		background-color : #eebb00;
	}
	table.cfdump_binary th.binary {
		background-color: #ffcc44;
	}
	table.cfdump_binary td {
		font-size: x-small;
	}
	table.cfdump_udf {
		background-color: #aa4400;
	}
	table.cfdump_udf th.udf {
		background-color: #cc6600;
	}
	table.cfdump_udfarguments {
		background-color: #dddddd;
		cell-spacing: 3;
	}
	table.cfdump_udfarguments th {
		background-color: #eeeeee;
		color: #000000;
	}

</style> 
		<table class="cfdump_query">
			<tr>
			
			
			<th class="query" colspan="2">query</th>
			</tr>
			<tr  class="query" valign="top">
				<td class="query"  onClick="cfdump_toggleRow_qry(this);">RESULTSET</td>
				<td>
				<table class="cfdump_query">
				<tr>
			
				<th class="query" colspan="33">query</th>
				</tr>
			
				<tr bgcolor="eeaaaa" >
				<td class="query"  onClick="cfdump_toggleRow_qry(this);">&nbsp;</td>
				
				<td class="query">AGE_RESTRICTED</td>
				
				<td class="query">ALLOW_DELIVERY_ADDRESS</td>
				
				<td class="query">ALLOW_FINANCE</td>
				
				<td class="query">ALLOW_INTERNATIONAL_DELIVERY</td>
				
				<td class="query">BASKET_ITEM_ID</td>
				
				<td class="query">CATEGORY_ID</td>
				
				<td class="query">CATEGORY_TITLE</td>
				
				<td class="query">COLOUR</td>
				
				<td class="query">CREATED_DATE</td>
				
				<td class="query">DATE_CREATED</td>
				
				<td class="query">DATE_CREATED</td>
				
				<td class="query">FREE_ITEM</td>
				
				<td class="query">IMAGE_THUMB_URL</td>
				
				<td class="query">MANUFACTURER_CODE</td>
				
				<td class="query">MANUFACTURER_ID</td>
				
				<td class="query">MANUFACTURER_TITLE</td>
				
				<td class="query">OPTION_ID</td>
				
				<td class="query">OPTION_MANUFACTURER_CODE</td>
				
				<td class="query">OPTION_TITLE</td>
				
				<td class="query">POSTAGE_SIZE_CLASS</td>
				
				<td class="query">PRICE</td>
				
				<td class="query">PRODUCT_ID</td>
				
				<td class="query">QUANTITY</td>
				
				<td class="query">RFD_RESTRICTED</td>
				
				<td class="query">SHOPPER_ID</td>
				
				<td class="query">SPECIAL_OFFER</td>
				
				<td class="query">STOCK_CODE</td>
				
				<td class="query">STOCK_LEVEL</td>
				
				<td class="query">STOCK_PACK_SIZE</td>
				
				<td class="query">TITLE</td>
				
				<td class="query">TOTAL_ITEMS</td>
				
				<td class="query">URL_SAFE_TITLE</td>
				
				</tr>
				
				
				</table>
				</td>
			</tr>
			
			
						<tr bgcolor="eeaaaa" >
						<td class="query" onClick="cfdump_toggleRow_qry(this);" >CACHED</td>
						<td>false </td>
						</tr>
					
						<tr bgcolor="eeaaaa" >
						<td class="query" onClick="cfdump_toggleRow_qry(this);" >EXECUTIONTIME</td>
						<td>0 </td>
						</tr>
					
						<tr bgcolor="eeaaaa" >
						<td class="query" onClick="cfdump_toggleRow_qry(this);" >SQL</td>
						<td>SELECT
                tblShoppersBasketItems.shopperBasketItemID AS basket_item_id,
                tblShoppersBasketItems.shopperID AS shopper_id,
                tblShoppersBasketItems.optionID AS option_id,
                tblShoppersBasketItems.shopperbasketitemQuantity AS quantity,
                tblShoppersBasketItems.categoryID AS category_id,
            	tblShoppersBasketItems.ShopperBasketItemCreatedDate AS created_date,
            	tblShoppersBasketItems.ShopperBasketItemCreatedDate AS date_created,
                tblManufacturers.Name AS manufacturer_title,
                tblManufacturers.ID AS manufacturer_id,
                tblProducts.ManufacturerCode AS manufacturer_code,
                tblProducts.ID AS product_id,
                tblProducts.Title AS title,
                tblProducts.Colour AS colour,
                tblProducts.PostageSizeClass AS postage_size_class,
                tblProducts.AgeRestricted AS age_restricted,
                tblProducts.AllowDeliveryAddress AS allow_delivery_address,
                tblProducts.AllowInternationalDelivery AS allow_international_delivery,
                tblProducts.RFDRestricted AS rfd_restricted,
                tblProducts.URLSafeTitle AS url_safe_title,
                tblProducts.ImageThumb_URL AS image_thumb_url,
                tblProducts.isSpecialOffer AS special_offer,
                ISNULL(tblProducts.AllowFinance, 1) AS allow_finance,
                tblOptions.Title AS option_title,
                tblOptions.Price AS price,
                tblOptions.StockCode AS stock_code,
                tblOptions.ManufacturerCode AS option_manufacturer_code,
                tblOptions.Quantity AS stock_pack_size,
                shopperbasketitemCreatedDate AS date_created,
                dbo.sf_getStockLevel_V3(tblOptions.StockCode, 1) AS stock_level,
                tblCategories.Title AS category_title,
                0 AS free_item,
                (
                	SELECT SUM(shopperbasketitemQuantity)
                    FROM tblShoppersBasketItems
                    WHERE (shopperID = ?)
                	AND (shopperbasketitemQuantity &gt; 0)
                ) AS total_items
            FROM
                tblShoppersBasketItems
                INNER JOIN tblOptions ON tblShoppersBasketItems.optionID = tblOptions.ID
                INNER JOIN tblProducts ON tblOptions.ProductID = tblProducts.ID
                INNER JOIN tblManufacturers ON tblManufacturers.ID = tblProducts.ManufacturerID
                INNER JOIN tblCategories ON tblCategories.ID = tblShoppersBasketItems.categoryID
            WHERE
                (tblShoppersBasketItems.shopperID = ?)
                AND (tblShoppersBasketItems.shopperbasketitemQuantity &gt; 0)
            ORDER BY
            	tblShoppersBasketItems.ShopperBasketItemCreatedDate </td>
						</tr>
					
						<tr bgcolor="eeaaaa" >
						<td class="query" onClick="cfdump_toggleRow_qry(this);" >SQLPARAMETERS</td>
						<td>
				<table class="cfdump_array">
				<tr><th class="array" colspan="2">array
				</th></tr>
				
					<tr><td class="array">1</td>
					<td> 629295149 </td></tr> 
					<tr><td class="array">2</td>
					<td> 629295149 </td></tr> 
			</table>
		</td>
						</tr>
					
		</table>