500 - JDatabaseMySQL::query: 1064 - You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near
'default,newred,tobaccostripes,ruststripes,sandstripes,offwhitestripes,brownprint'
at line 1 SQL=INSERT IGNORE INTO chyc5_hikashop_order_product
(order_id,product_id,order_product_quantity,order_product_name,order_product_code,order_product_price,order_product_tax,order_product_options,order_product_option_parent_id,order_product_tax_info,white,blue,ivory,red,pink,black,purple,persimmon,mint,coral,royal,jade,surfblue,prose,willowpear,magenta,tomatorednavy,shellpink,stone,candy,spearmint,cream,mintsage,mintjade,pearsummer,claretrose,banana,greentea,carib,lemon,pearl,newlavender,sagemint,sweetmustard,toast,steelpurple,sandgreen,springblush,trueroyal,springkelly,bgreyash,fallmustard,springjade,springroyal,sandblack,sandtrueblue,moonlightrose,harborstone,newcoral,mustard,oyster,valleyjade,gardencoral,summerred,charmmustard,peach,steelblue,sunsetcoral,fhuntergreen,fallmagenta,fashiongreen,paradisegreen,bluefloral,royalanimal,jadeanimal,coralanimal,mintcircle,peachcircle,creamchiffon,mintsagechiffon,redprint,blueprint,olivelush,fhgreen,tomatonavy,harborstoneblack,moonlightroseblack,applesage,softpink,deepcoral,deepmagenta,darkcobalt,warmcoral,shalloworange,tealblue,fallrust,coco,olive,seagreen,mocha,greenprint,rustprint,freshred,swissmagenta,aprilorange,sesame,navy,fashionrust,fallgrape,royalgreystripes,jadegreystripes,orangegreystripes,dknavygreystripes,royalgreysmallstripes,blackgreysmallstripes,orangegreysmallstripes,orangeflame,dktrueroyal,pine,fallcobalt,newroyal,nilejade,naturalpeach,sandwhite,rustorange,stonesand,salmon,blackzigzag,blackdenim,navydenim,dustyrose,blackbirdprint,dkcharcoal,olivedots,navydots,newharborgreen,springred,greyhaze,printedmintpeachcoral,mochahaze,denimblue,printedmintsand,juicyrose,pismocoral,deeprose,lttaupe,peachkeen,shadowblue,palerose,blueindigo,jadefancy,turquoise,blackprinted,navyrabbits,blackrabbits,taupelittleanimals,corallittleanimals,bjade,coralprinted,springfuschia,mintstripes,orangestripes,summerlime,newcoralblack,smokygrey,huntergreen,juicycoral,coralmist,limeyellow,limeprint,mellowyellow,deeprust,harbermagenta,tealaqua,fashionred,tangerine,tealjade,zebraprint,charcoal,cobalt,deepnavy,deepred,lightcoral,summerroyal,blueblack,oliveblack,rosered,pinkblack,gingercoral,periwinkle,harborgreen,blacksilver,bluefloralprint,coralbrown,blackfloralprint,deeppurple,shallowblue,vintagerose,dutchblue,spice,fungi,toastalmond,summercoral,smokypink,default,newred,tobaccostripes,ruststripes,sandstripes,offwhitestripes,brownprint,polytoast,jadegreen,sand,rust,eggplant,deeproyal,blushkhaki,seajade,berryred,smoky,modernrust,fashionruby,gardengreen,frenchsage,redrose,burntorange,fallcoco)
VALUES (40,715,1,'T-11361C: 1
cream','T-11361C_75','52.5','0','a:4:{i:1;O:8:\"stdClass\":7:{s:25:\"variant_characteristic_id\";s:2:\"75\";s:18:\"variant_product_id\";s:3:\"715\";s:8:\"ordering\";s:1:\"0\";s:17:\"characteristic_id\";s:2:\"75\";s:24:\"characteristic_parent_id\";s:2:\"76\";s:20:\"characteristic_value\";s:1:\"1\";s:20:\"characteristic_alias\";s:0:\"\";}i:2;O:8:\"stdClass\":7:{s:25:\"variant_characteristic_id\";s:3:\"492\";s:18:\"variant_product_id\";s:3:\"715\";s:8:\"ordering\";s:1:\"0\";s:17:\"characteristic_id\";s:3:\"492\";s:24:\"characteristic_parent_id\";s:3:\"493\";s:20:\"characteristic_value\";s:5:\"cream\";s:20:\"characteristic_alias\";s:0:\"\";}s:15:\"swatch-selector\";s:1:\"1\";s:17:\"T-11361C
swatches\";s:5:\"cream\";}',372,'a:0:{}','','','','','','','','','','','','','','','','','','','','','','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','1','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','')

*You may not be able to visit this page because of:*

 1. an *out-of-date bookmark/favourite*
 2. a search engine that has an *out-of-date listing for this site*
 3. a *mistyped address*
 4. you have *no access* to this page
 5. The requested resource was not found.
 6. An error has occurred while processing your request.

*Please try one of the following pages:*

  * Home Page <http://myfinaltouchinc.com/index.php>

If difficulties persist, please contact the System Administrator of this
site and report the error below..

JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near
'default,newred,tobaccostripes,ruststripes,sandstripes,offwhitestripes,brownprint'
at line 1 SQL=INSERT IGNORE INTO chyc5_hikashop_order_product
(order_id,product_id,order_product_quantity,order_product_name,order_product_code,order_product_price,order_product_tax,order_product_options,order_product_option_parent_id,order_product_tax_info,white,blue,ivory,red,pink,black,purple,persimmon,mint,coral,royal,jade,surfblue,prose,willowpear,magenta,tomatorednavy,shellpink,stone,candy,spearmint,cream,mintsage,mintjade,pearsummer,claretrose,banana,greentea,carib,lemon,pearl,newlavender,sagemint,sweetmustard,toast,steelpurple,sandgreen,springblush,trueroyal,springkelly,bgreyash,fallmustard,springjade,springroyal,sandblack,sandtrueblue,moonlightrose,harborstone,newcoral,mustard,oyster,valleyjade,gardencoral,summerred,charmmustard,peach,steelblue,sunsetcoral,fhuntergreen,fallmagenta,fashiongreen,paradisegreen,bluefloral,royalanimal,jadeanimal,coralanimal,mintcircle,peachcircle,creamchiffon,mintsagechiffon,redprint,blueprint,olivelush,fhgreen,tomatonavy,harborstoneblack,moonlightroseblack,applesage,softpink,deepcoral,deepmagenta,darkcobalt,warmcoral,shalloworange,tealblue,fallrust,coco,olive,seagreen,mocha,greenprint,rustprint,freshred,swissmagenta,aprilorange,sesame,navy,fashionrust,fallgrape,royalgreystripes,jadegreystripes,orangegreystripes,dknavygreystripes,royalgreysmallstripes,blackgreysmallstripes,orangegreysmallstripes,orangeflame,dktrueroyal,pine,fallcobalt,newroyal,nilejade,naturalpeach,sandwhite,rustorange,stonesand,salmon,blackzigzag,blackdenim,navydenim,dustyrose,blackbirdprint,dkcharcoal,olivedots,navydots,newharborgreen,springred,greyhaze,printedmintpeachcoral,mochahaze,denimblue,printedmintsand,juicyrose,pismocoral,deeprose,lttaupe,peachkeen,shadowblue,palerose,blueindigo,jadefancy,turquoise,blackprinted,navyrabbits,blackrabbits,taupelittleanimals,corallittleanimals,bjade,coralprinted,springfuschia,mintstripes,orangestripes,summerlime,newcoralblack,smokygrey,huntergreen,juicycoral,coralmist,limeyellow,limeprint,mellowyellow,deeprust,harbermagenta,tealaqua,fashionred,tangerine,tealjade,zebraprint,charcoal,cobalt,deepnavy,deepred,lightcoral,summerroyal,blueblack,oliveblack,rosered,pinkblack,gingercoral,periwinkle,harborgreen,blacksilver,bluefloralprint,coralbrown,blackfloralprint,deeppurple,shallowblue,vintagerose,dutchblue,spice,fungi,toastalmond,summercoral,smokypink,default,newred,tobaccostripes,ruststripes,sandstripes,offwhitestripes,brownprint,polytoast,jadegreen,sand,rust,eggplant,deeproyal,blushkhaki,seajade,berryred,smoky,modernrust,fashionruby,gardengreen,frenchsage,redrose,burntorange,fallcoco)
VALUES (40,715,1,'T-11361C: 1
cream','T-11361C_75','52.5','0','a:4:{i:1;O:8:\"stdClass\":7:{s:25:\"variant_characteristic_id\";s:2:\"75\";s:18:\"variant_product_id\";s:3:\"715\";s:8:\"ordering\";s:1:\"0\";s:17:\"characteristic_id\";s:2:\"75\";s:24:\"characteristic_parent_id\";s:2:\"76\";s:20:\"characteristic_value\";s:1:\"1\";s:20:\"characteristic_alias\";s:0:\"\";}i:2;O:8:\"stdClass\":7:{s:25:\"variant_characteristic_id\";s:3:\"492\";s:18:\"variant_product_id\";s:3:\"715\";s:8:\"ordering\";s:1:\"0\";s:17:\"characteristic_id\";s:3:\"492\";s:24:\"characteristic_parent_id\";s:3:\"493\";s:20:\"characteristic_value\";s:5:\"cream\";s:20:\"characteristic_alias\";s:0:\"\";}s:15:\"swatch-selector\";s:1:\"1\";s:17:\"T-11361C
swatches\";s:5:\"cream\";}',372,'a:0:{}','','','','','','','','','','','','','','','','','','','','','','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','1','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','')

*Call stack*	
*#*		*Function*		*Location*	
1		JSite->dispatch()		/home3/myfinal4/public_html/index.php:43	
2		JComponentHelper::renderComponent()	
/home3/myfinal4/public_html/includes/application.php:191	
3		require_once()	
/home3/myfinal4/public_html/libraries/joomla/application/component/helper.php:156

4		JController->execute()	
/home3/myfinal4/public_html/components/com_hikashop/hikashop.php:53	
5		checkoutController->step()	
/home3/myfinal4/public_html/libraries/joomla/application/component/controller.php:684

6		checkoutController->after_confirm()	
/home3/myfinal4/public_html/components/com_hikashop/controllers/checkout.php:239

7		hikashopOrderClass->save()	
/home3/myfinal4/public_html/components/com_hikashop/controllers/checkout.php:1130

8		hikashopOrder_productClass->save()	
/home3/myfinal4/public_html/administrator/components/com_hikashop/classes/order.php:102

9		JDatabaseMySQLi->query()	
/home3/myfinal4/public_html/administrator/components/com_hikashop/classes/order_product.php:68

10		JError::raiseError()	
/home3/myfinal4/public_html/libraries/joomla/database/database/mysqli.php:535

11		JError::raise()	
/home3/myfinal4/public_html/libraries/joomla/error/error.php:250	


        Errors

 1. JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax;
    check the manual that corresponds to your MySQL server version for
    the right syntax to use near
    'default,newred,tobaccostripes,ruststripes,sandstripes,offwhitestripes,brownprint'
    at line 1 SQL=INSERT IGNORE INTO chyc5_hikashop_order_product
    (order_id,product_id,order_product_quantity,order_product_name,order_product_code,order_product_price,order_product_tax,order_product_options,order_product_option_parent_id,order_product_tax_info,white,blue,ivory,red,pink,black,purple,persimmon,mint,coral,royal,jade,surfblue,prose,willowpear,magenta,tomatorednavy,shellpink,stone,candy,spearmint,cream,mintsage,mintjade,pearsummer,claretrose,banana,greentea,carib,lemon,pearl,newlavender,sagemint,sweetmustard,toast,steelpurple,sandgreen,springblush,trueroyal,springkelly,bgreyash,fallmustard,springjade,springroyal,sandblack,sandtrueblue,moonlightrose,harborstone,newcoral,mustard,oyster,valleyjade,gardencoral,summerred,charmmustard,peach,steelblue,sunsetcoral,fhuntergreen,fallmagenta,fashiongreen,paradisegreen,bluefloral,royalanimal,jadeanimal,coralanimal,mintcircle,peachcircle,creamchiffon,mintsagechiffon,redprint,blueprint,olivelush,fhgreen,tomatonavy,harborstoneblack,moonlightroseblack,applesage,softpink,deepcoral,deepmagenta,darkcobalt,warmcoral,shalloworange,tealblue,fallrust,coco,olive,seagreen,mocha,greenprint,rustprint,freshred,swissmagenta,aprilorange,sesame,navy,fashionrust,fallgrape,royalgreystripes,jadegreystripes,orangegreystripes,dknavygreystripes,royalgreysmallstripes,blackgreysmallstripes,orangegreysmallstripes,orangeflame,dktrueroyal,pine,fallcobalt,newroyal,nilejade,naturalpeach,sandwhite,rustorange,stonesand,salmon,blackzigzag,blackdenim,navydenim,dustyrose,blackbirdprint,dkcharcoal,olivedots,navydots,newharborgreen,springred,greyhaze,printedmintpeachcoral,mochahaze,denimblue,printedmintsand,juicyrose,pismocoral,deeprose,lttaupe,peachkeen,shadowblue,palerose,blueindigo,jadefancy,turquoise,blackprinted,navyrabbits,blackrabbits,taupelittleanimals,corallittleanimals,bjade,coralprinted,springfuschia,mintstripes,orangestripes,summerlime,newcoralblack,smokygrey,huntergreen,juicycoral,coralmist,limeyellow,limeprint,mellowyellow,deeprust,harbermagenta,tealaqua,fashionred,tangerine,tealjade,zebraprint,charcoal,cobalt,deepnavy,deepred,lightcoral,summerroyal,blueblack,oliveblack,rosered,pinkblack,gingercoral,periwinkle,harborgreen,blacksilver,bluefloralprint,coralbrown,blackfloralprint,deeppurple,shallowblue,vintagerose,dutchblue,spice,fungi,toastalmond,summercoral,smokypink,default,newred,tobaccostripes,ruststripes,sandstripes,offwhitestripes,brownprint,polytoast,jadegreen,sand,rust,eggplant,deeproyal,blushkhaki,seajade,berryred,smoky,modernrust,fashionruby,gardengreen,frenchsage,redrose,burntorange,fallcoco)
    VALUES (40,715,1,'T-11361C: 1
    cream','T-11361C_75','52.5','0','a:4:{i:1;O:8:\"stdClass\":7:{s:25:\"variant_characteristic_id\";s:2:\"75\";s:18:\"variant_product_id\";s:3:\"715\";s:8:\"ordering\";s:1:\"0\";s:17:\"characteristic_id\";s:2:\"75\";s:24:\"characteristic_parent_id\";s:2:\"76\";s:20:\"characteristic_value\";s:1:\"1\";s:20:\"characteristic_alias\";s:0:\"\";}i:2;O:8:\"stdClass\":7:{s:25:\"variant_characteristic_id\";s:3:\"492\";s:18:\"variant_product_id\";s:3:\"715\";s:8:\"ordering\";s:1:\"0\";s:17:\"characteristic_id\";s:3:\"492\";s:24:\"characteristic_parent_id\";s:3:\"493\";s:20:\"characteristic_value\";s:5:\"cream\";s:20:\"characteristic_alias\";s:0:\"\";}s:15:\"swatch-selector\";s:1:\"1\";s:17:\"T-11361C
    swatches\";s:5:\"cream\";}',372,'a:0:{}','','','','','','','','','','','','','','','','','','','','','','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','1','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','')


            Information


            Backtrace

    *Call stack*	
    *#*		*Function*		*Location*	
    1		JSite->dispatch()		/home3/myfinal4/public_html/index.php:43	
    2		JComponentHelper::renderComponent()	
    /home3/myfinal4/public_html/includes/application.php:191	
    3		require_once()	
    /home3/myfinal4/public_html/libraries/joomla/application/component/helper.php:156

    4		JController->execute()	
    /home3/myfinal4/public_html/components/com_hikashop/hikashop.php:53	
    5		checkoutController->step()	
    /home3/myfinal4/public_html/libraries/joomla/application/component/controller.php:684

    6		checkoutController->after_confirm()	
    /home3/myfinal4/public_html/components/com_hikashop/controllers/checkout.php:239

    7		hikashopOrderClass->save()	
    /home3/myfinal4/public_html/components/com_hikashop/controllers/checkout.php:1130

    8		hikashopOrder_productClass->save()	
    /home3/myfinal4/public_html/administrator/components/com_hikashop/classes/order.php:102

    9		JDatabaseMySQLi->query()	
    /home3/myfinal4/public_html/administrator/components/com_hikashop/classes/order_product.php:68

    10		JError::raiseError()	
    /home3/myfinal4/public_html/libraries/joomla/database/database/mysqli.php:535

    11		JError::raise()	
    /home3/myfinal4/public_html/libraries/joomla/error/error.php:250	


        Profile Information

|Application 0.000 seconds (+0.000); 0.80 MB (+0.796) - afterLoad|
|Application 0.090 seconds (+0.089); 8.74 MB (+7.945) - afterInitialise|
|Application 0.104 seconds (+0.014); 10.18 MB (+1.440) - afterRoute|


        Memory Usage

18.01 MB (18,889,712 Bytes)


        46 Queries Logged

 1. SELECT `data`
      FROM `chyc5_session`
      WHERE `session_id` = 'd75gi23qsuuhjs5hros3pvpli3'
 2. SELECT folder AS type, element AS name, params
      FROM chyc5_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1,2)
      ORDER BY ordering
 3. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM chyc5_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
 4. SELECT *
      FROM chyc5_hikashop_config
 5. SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link,
    m.type, m.level, m.language,m.browserNav, m.access, m.params,
    m.home, m.img, m.template_style_id, m.component_id,
    m.parent_id,e.element as component
      FROM chyc5_menu AS m
      LEFT JOIN chyc5_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
 6. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM chyc5_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_hikashop'
 7. SELECT *
      FROM chyc5_languages
      WHERE published=1
      ORDER BY ordering ASC
 8. SELECT id, home, template, s.params
      FROM chyc5_template_styles as s
      LEFT JOIN chyc5_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
 9. SELECT a.*
      FROM chyc5_hikashop_cart AS a
      WHERE a.cart_id = 142
      ORDER BY a.cart_modified DESC
      LIMIT 1
10. SELECT a.id
      FROM chyc5_user_usergroup_map AS map
      LEFT JOIN chyc5_usergroups AS a
      ON a.id = map.group_id
      WHERE map.user_id = 92
11. SELECT b.*,c.*
      FROM chyc5_hikashop_cart_product AS b
      LEFT JOIN chyc5_hikashop_product AS c
      ON b.product_id=c.product_id
      WHERE b.cart_id = 142
      AND b.product_id > 0
      AND (c.product_access = 'all' OR c.product_access LIKE '%,2,%')
      ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
12. SELECT a.*,b.*
      FROM chyc5_hikashop_user AS a
      LEFT JOIN chyc5_users AS b
      ON a.user_cms_id=b.id
      WHERE a.user_cms_id=92
13. SELECT a.*,b.*
      FROM chyc5_hikashop_user AS a
      LEFT JOIN chyc5_users AS b
      ON a.user_cms_id=b.id
      WHERE a.user_id=50
14. SELECT currency_id
      FROM chyc5_hikashop_currency
      WHERE currency_published=1 OR currency_id = 2
15. SELECT *
      FROM chyc5_hikashop_address
      WHERE address_id = '11'
      LIMIT 1
16. SELECT *
      FROM chyc5_hikashop_zone
      WHERE zone_namekey = 'state_Bulacan_2914'
      LIMIT 1
17. SELECT *
      FROM chyc5_hikashop_address
      WHERE address_id = '11'
      LIMIT 1
18. SELECT b.*,c.*
      FROM chyc5_hikashop_cart_product AS b
      LEFT JOIN chyc5_hikashop_product AS c
      ON b.product_id=c.product_id
      WHERE b.cart_id = 142
      AND b.product_id > 0
      AND (c.product_access = 'all' OR c.product_access LIKE '%,2,%')
      ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
19. SELECT *
      FROM chyc5_hikashop_file
      WHERE file_ref_id IN (714,715)
      AND file_type = 'product'
      ORDER BY file_ref_id ASC, file_ordering ASC
20. SELECT a.*,b.*
      FROM chyc5_hikashop_variant AS a
      LEFT JOIN chyc5_hikashop_characteristic AS b
      ON a.variant_characteristic_id=b.characteristic_id
      WHERE a.variant_product_id IN (714,715)
      ORDER BY a.ordering,b.characteristic_value
21. SELECT *
      FROM chyc5_hikashop_price
      WHERE price_currency_id IN (2)
      AND price_product_id IN (714,715)
      AND (price_access = 'all' OR price_access LIKE '%,2,%')
      ORDER BY price_value DESC
22. SELECT *
      FROM chyc5_hikashop_currency
      WHERE currency_id IN (2)
23. SELECT *
      FROM chyc5_hikashop_address
      WHERE address_id = '11'
      LIMIT 1
24. SELECT b.*,c.*
      FROM chyc5_hikashop_category AS a
      LEFT JOIN chyc5_hikashop_taxation AS b
      ON a.category_namekey=b.category_namekey
      LEFT JOIN chyc5_hikashop_tax AS c
      ON b.tax_namekey=c.tax_namekey
      WHERE a.category_id = 11
      AND b.taxation_published=1
      AND ( taxation_type = '' OR taxation_type = 'individual' )
      AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,2,%')
25. SELECT *
      FROM chyc5_hikashop_zone
      WHERE zone_id = 2914
26. SELECT *
      FROM chyc5_hikashop_discount
      WHERE discount_type='discount'
      AND discount_published=1
      AND ( discount_quota>discount_used_times OR discount_quota=0 )
      AND discount_start < 1343963336
      AND ( discount_end > 1343963336 OR discount_end = 0 )
      AND ( discount_product_id IN (714,715) OR discount_product_id=0 )
      AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
      AND (discount_access = 'all' OR discount_access LIKE '%,2,%')
27. SELECT *
      FROM chyc5_hikashop_file
      WHERE file_ref_id IN (714,715)
      AND file_type='product'
      ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
28. SELECT category_id
      FROM chyc5_hikashop_product_category
      WHERE product_id=714
      ORDER BY ordering ASC
29. SELECT DISTINCT b.*
      FROM chyc5_hikashop_category AS a
      LEFT JOIN chyc5_hikashop_category AS b
      ON a.category_left >= b.category_left
      WHERE b.category_right >= a.category_right
      AND a.category_id IN (197,43,13)
      ORDER BY b.category_left
30. SELECT *
      FROM chyc5_hikashop_field as a
      WHERE a.`field_published` = 1
      AND a.`field_frontcomp` = 1
      AND a.field_table='product'
      AND (a.field_access = 'all' OR a.field_access LIKE '%,2,%')
      AND ((field_with_sub_categories=0
      AND (field_categories="all" OR field_categories LIKE '%,197,%' OR
    field_categories LIKE '%,43,%' OR field_categories LIKE '%,13,%'))OR
    (field_with_sub_categories=1
      AND (field_categories="all" OR field_categories LIKE '%,1,%' OR
    field_categories LIKE '%,2,%' OR field_categories LIKE '%,13,%' OR
    field_categories LIKE '%,43,%' OR field_categories LIKE '%,197,%')))
      ORDER BY a.`field_ordering` ASC
31. SELECT *
      FROM chyc5_hikashop_discount
      WHERE discount_type='coupon'
      AND discount_published=1
      AND discount_auto_load=1
      AND (discount_access = 'all' OR discount_access LIKE '%,2,%')
      ORDER BY discount_minimum_order DESC, discount_minimum_products DESC
32. SELECT *
      FROM chyc5_hikashop_address
      WHERE address_id = '11'
      LIMIT 1
33. SELECT *
      FROM chyc5_hikashop_address
      WHERE address_id = '11'
      LIMIT 1
34. SELECT *
      FROM chyc5_hikashop_field as a
      WHERE a.`field_published` = 1
      AND a.`field_frontcomp` = 1
      AND a.field_table='address'
      AND (a.field_access = 'all' OR a.field_access LIKE '%,2,%')
      ORDER BY a.`field_ordering` ASC
35. SELECT a.*
      FROM chyc5_hikashop_zone_link AS a
      WHERE a.zone_child_namekey IN
    ('state_Bulacan_2914','country_Philippines_168');
36. SELECT a.*
      FROM chyc5_hikashop_zone_link AS a
      WHERE a.zone_child_namekey IN ('country_Philippines_168');
37. SELECT *
      FROM chyc5_hikashop_shipping
      WHERE (shipping_access = 'all' OR shipping_access LIKE '%,2,%')
      ORDER BY shipping_ordering ASC
38. SELECT a.variant_product_id as product_id,b.characteristic_id as
    value_id,b.characteristic_value as value,c.characteristic_id as
    name_id,c.characteristic_value as name
      FROM chyc5_hikashop_variant AS a
      LEFT JOIN chyc5_hikashop_characteristic AS b
      ON a.variant_characteristic_id=b.characteristic_id
      LEFT JOIN chyc5_hikashop_characteristic AS c
      ON b.characteristic_parent_id = c.characteristic_id
      WHERE a.variant_product_id IN (715)
39. SELECT *
      FROM chyc5_hikashop_field as a
      WHERE a.`field_published` = 1
      AND a.`field_frontcomp` = 1
      AND a.field_table='item'
      AND (a.field_access = 'all' OR a.field_access LIKE '%,2,%')
      ORDER BY a.`field_ordering` ASC
40. INSERT IGNORE INTO `chyc5_hikashop_order` (
    `order_user_id`,`order_status`,`order_shipping_address_id`,`order_billing_address_id`,`order_currency_id`,`order_type`,`order_full_price`,`order_tax_info`,`order_shipping_price`,`order_shipping_tax`,`order_discount_tax`,`order_discount_price`,`order_shipping_id`,`order_shipping_method`,`order_payment_id`,`order_payment_method`,`order_created`,`order_ip`,`order_modified`
    )
      VALUES (
    '50','created','11','11','2','sale','52.5','a:0:{}','0','0','0','0','6','manual','2','banktransfer','1343963336','124.6.181.55','1343963336'
    )
41. UPDATE `chyc5_hikashop_order`
      SET
    `order_user_id`='50',`order_status`='created',`order_shipping_address_id`='11',`order_billing_address_id`='11',`order_currency_id`='2',`order_type`='sale',`order_full_price`='52.5',`order_shipping_price`='0',`order_shipping_tax`='0',`order_discount_tax`='0',`order_discount_price`='0',`order_shipping_id`='6',`order_shipping_method`='manual',`order_payment_id`='2',`order_payment_method`='banktransfer',`order_created`='1343963336',`order_ip`='124.6.181.55',`order_modified`='1343963336',`order_number`='B4T0'

      WHERE `order_id`='40'
42. SELECT *
      FROM chyc5_hikashop_product
      WHERE product_id = '715'
      LIMIT 1
43. UPDATE chyc5_hikashop_product
      SET product_quantity = product_quantity - 1
      WHERE product_id IN (715,714)
      AND product_quantity > -1
44. UPDATE chyc5_hikashop_product
      SET product_sales = product_sales + 1
      WHERE product_id IN (715,714)
45. INSERT IGNORE INTO chyc5_hikashop_order_product
    (order_id,product_id,order_product_quantity,order_product_name,order_product_code,order_product_price,order_product_tax,order_product_options,order_product_option_parent_id,order_product_tax_info,white,blue,ivory,red,pink,black,purple,persimmon,mint,coral,royal,jade,surfblue,prose,willowpear,magenta,tomatorednavy,shellpink,stone,candy,spearmint,cream,mintsage,mintjade,pearsummer,claretrose,banana,greentea,carib,lemon,pearl,newlavender,sagemint,sweetmustard,toast,steelpurple,sandgreen,springblush,trueroyal,springkelly,bgreyash,fallmustard,springjade,springroyal,sandblack,sandtrueblue,moonlightrose,harborstone,newcoral,mustard,oyster,valleyjade,gardencoral,summerred,charmmustard,peach,steelblue,sunsetcoral,fhuntergreen,fallmagenta,fashiongreen,paradisegreen,bluefloral,royalanimal,jadeanimal,coralanimal,mintcircle,peachcircle,creamchiffon,mintsagechiffon,redprint,blueprint,olivelush,fhgreen,tomatonavy,harborstoneblack,moonlightroseblack,applesage,softpink,deepcoral,deepmagenta,darkcobalt,warmcoral,shalloworange,tealblue,fallrust,coco,olive,seagreen,mocha,greenprint,rustprint,freshred,swissmagenta,aprilorange,sesame,navy,fashionrust,fallgrape,royalgreystripes,jadegreystripes,orangegreystripes,dknavygreystripes,royalgreysmallstripes,blackgreysmallstripes,orangegreysmallstripes,orangeflame,dktrueroyal,pine,fallcobalt,newroyal,nilejade,naturalpeach,sandwhite,rustorange,stonesand,salmon,blackzigzag,blackdenim,navydenim,dustyrose,blackbirdprint,dkcharcoal,olivedots,navydots,newharborgreen,springred,greyhaze,printedmintpeachcoral,mochahaze,denimblue,printedmintsand,juicyrose,pismocoral,deeprose,lttaupe,peachkeen,shadowblue,palerose,blueindigo,jadefancy,turquoise,blackprinted,navyrabbits,blackrabbits,taupelittleanimals,corallittleanimals,bjade,coralprinted,springfuschia,mintstripes,orangestripes,summerlime,newcoralblack,smokygrey,huntergreen,juicycoral,coralmist,limeyellow,limeprint,mellowyellow,deeprust,harbermagenta,tealaqua,fashionred,tangerine,tealjade,zebraprint,charcoal,cobalt,deepnavy,deepred,lightcoral,summerroyal,blueblack,oliveblack,rosered,pinkblack,gingercoral,periwinkle,harborgreen,blacksilver,bluefloralprint,coralbrown,blackfloralprint,deeppurple,shallowblue,vintagerose,dutchblue,spice,fungi,toastalmond,summercoral,smokypink,default,newred,tobaccostripes,ruststripes,sandstripes,offwhitestripes,brownprint,polytoast,jadegreen,sand,rust,eggplant,deeproyal,blushkhaki,seajade,berryred,smoky,modernrust,fashionruby,gardengreen,frenchsage,redrose,burntorange,fallcoco)

      VALUES (40,715,1,'T-11361C<span
    class=\"hikashop_product_variant_subname\">: 1
    cream</span>','T-11361C_75','52.5','0','a:4:{i:1;O:8:\"stdClass\":7:{s:25:\"variant_characteristic_id\";s:2:\"75\";s:18:\"variant_product_id\";s:3:\"715\";s:8:\"ordering\";s:1:\"0\";s:17:\"characteristic_id\";s:2:\"75\";s:24:\"characteristic_parent_id\";s:2:\"76\";s:20:\"characteristic_value\";s:1:\"1\";s:20:\"characteristic_alias\";s:0:\"\";}i:2;O:8:\"stdClass\":7:{s:25:\"variant_characteristic_id\";s:3:\"492\";s:18:\"variant_product_id\";s:3:\"715\";s:8:\"ordering\";s:1:\"0\";s:17:\"characteristic_id\";s:3:\"492\";s:24:\"characteristic_parent_id\";s:3:\"493\";s:20:\"characteristic_value\";s:5:\"cream\";s:20:\"characteristic_alias\";s:0:\"\";}s:15:\"swatch-selector\";s:1:\"1\";s:17:\"T-11361C
    swatches\";s:5:\"cream\";}',372,'a:0:{}','','','','','','','','','','','','','','','','','','','','','','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','1','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','')
46. UPDATE `chyc5_session`
      SET `data` =
    '__default|a:8:{s:15:\"session.counter\";i:74;s:19:\"session.timer.start\";i:1343961359;s:18:\"session.timer.last\";i:1343963322;s:17:\"session.timer.now\";i:1343963336;s:22:\"session.client.browser\";s:99:\"Mozilla/5.0
    (Windows NT 6.1) AppleWebKit/537.1 (KHTML, like Gecko)
    Chrome/21.0.1180.60
    Safari/537.1\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:12:\"com_hikashop\";O:8:\"stdClass\":22:{s:7:\"zone_id\";s:4:\"2914\";s:12:\"ssl_redirect\";i:0;s:7:\"cart_id\";i:142;s:15:\"shipping_method\";s:6:\"manual\";s:11:\"shipping_id\";i:6;s:13:\"shipping_data\";O:8:\"stdClass\":16:{s:11:\"shipping_id\";s:1:\"6\";s:13:\"shipping_type\";s:6:\"manual\";s:21:\"shipping_zone_namekey\";s:0:\"\";s:15:\"shipping_tax_id\";s:1:\"0\";s:14:\"shipping_price\";s:7:\"0.00000\";s:20:\"shipping_currency_id\";s:1:\"2\";s:13:\"shipping_name\";s:3:\"UCL\";s:20:\"shipping_description\";s:0:\"\";s:18:\"shipping_published\";s:1:\"1\";s:17:\"shipping_ordering\";s:1:\"1\";s:15:\"shipping_params\";O:8:\"stdClass\":18:{s:19:\"shipping_percentage\";s:1:\"0\";s:20:\"shipping_per_product\";s:1:\"0\";s:26:\"shipping_price_per_product\";s:0:\"\";s:18:\"shipping_min_price\";s:0:\"\";s:18:\"shipping_max_price\";s:0:\"\";s:25:\"shipping_virtual_included\";s:1:\"0\";s:25:\"shipping_override_address\";s:1:\"0\";s:30:\"shipping_override_address_text\";s:0:\"\";s:19:\"shipping_min_weight\";s:0:\"\";s:19:\"shipping_max_weight\";s:0:\"\";s:20:\"shipping_weight_unit\";s:2:\"kg\";s:19:\"shipping_zip_prefix\";s:0:\"\";s:16:\"shipping_min_zip\";s:0:\"\";s:16:\"shipping_max_zip\";s:0:\"\";s:19:\"shipping_zip_suffix\";s:0:\"\";s:19:\"shipping_min_volume\";s:0:\"\";s:19:\"shipping_max_volume\";s:0:\"\";s:18:\"shipping_size_unit\";s:1:\"m\";}s:15:\"shipping_images\";s:0:\"\";s:15:\"shipping_access\";s:3:\"all\";s:23:\"shipping_price_with_tax\";d:0;s:28:\"shipping_price_orig_with_tax\";d:0;s:5:\"total\";O:8:\"stdClass\":1:{s:6:\"prices\";a:1:{i:0;O:8:\"stdClass\":6:{s:11:\"price_value\";d:52.5;s:20:\"price_value_with_tax\";d:52.5;s:17:\"price_currency_id\";i:2;s:5:\"taxes\";a:0:{}s:37:\"price_value_without_shipping_with_tax\";d:52.5;s:28:\"price_value_without_shipping\";d:52.5;}}}}s:14:\"payment_method\";s:12:\"banktransfer\";s:10:\"payment_id\";i:2;s:12:\"payment_data\";O:8:\"stdClass\":27:{s:10:\"payment_id\";s:1:\"2\";s:12:\"payment_name\";s:26:\"credit
    card by fax /
    phone\";s:19:\"payment_description\";s:0:\"\";s:14:\"payment_images\";s:13:\"Bank_transfer\";s:14:\"payment_params\";O:8:\"stdClass\":2:{s:12:\"order_status\";s:7:\"created\";s:11:\"information\";s:0:\"\";}s:12:\"payment_type\";s:12:\"banktransfer\";s:20:\"payment_zone_namekey\";s:0:\"\";s:14:\"payment_access\";s:3:\"all\";s:24:\"payment_shipping_methods\";s:0:\"\";s:16:\"payment_currency\";s:0:\"\";s:12:\"extension_id\";s:5:\"10007\";s:4:\"name\";s:37:\"HikaShop
    bank transfer payment
    plugin\";s:4:\"type\";s:6:\"plugin\";s:7:\"element\";s:12:\"banktransfer\";s:6:\"folder\";s:15:\"hikashoppayment\";s:9:\"client_id\";s:1:\"0\";s:7:\"enabled\";s:1:\"1\";s:6:\"access\";s:1:\"1\";s:9:\"protected\";s:1:\"0\";s:14:\"manifest_cache\";s:0:\"\";s:6:\"params\";s:0:\"\";s:11:\"custom_data\";s:0:\"\";s:11:\"system_data\";s:0:\"\";s:11:\"checked_out\";s:1:\"0\";s:16:\"checked_out_time\";s:19:\"0000-00-00
    00:00:00\";s:8:\"ordering\";s:1:\"0\";s:5:\"state\";s:1:\"0\";}s:16:\"shipping_address\";s:2:\"11\";s:15:\"billing_address\";s:2:\"11\";s:14:\"checkout_terms\";s:1:\"1\";s:18:\"checkout_fields_ok\";i:0;s:8:\"order_id\";i:39;s:11:\"coupon_code\";s:0:\"\";s:9:\"cc_number\";s:0:\"\";s:8:\"cc_month\";s:0:\"\";s:7:\"cc_year\";s:0:\"\";s:6:\"cc_CCV\";s:0:\"\";s:8:\"cc_owner\";s:0:\"\";s:8:\"cc_valid\";i:0;s:15:\"checkout_fields\";N;}s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":1:{s:4:\"data\";a:0:{}}}}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";s:2:\"92\";s:4:\"name\";s:4:\"test\";s:8:\"username\";s:14:\"test@gmail.com\";s:5:\"email\";s:22:\"kim.carigtan@gmail.com\";s:8:\"password\";s:65:\"b9663584f77ecd8acdd4d18656dca7a5:tU6TMuvn6w4IPYJq8WiF3mum7mnubjC4\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2012-07-27
    14:39:40\";s:13:\"lastvisitDate\";s:19:\"2012-08-03
    02:11:36\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{s:10:\"Registered\";s:1:\"2\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:2;}s:14:\"\0*\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:2;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"1303c205d4f7bf07e10ce72e2487a681\";}hikashop_viewed_products|a:2:{i:849;i:849;i:714;i:714;}hikashop_item_data|O:8:\"stdClass\":2:{s:5:\"cream\";s:1:\"0\";s:11:\"huntergreen\";s:1:\"1\";}',
    `time` = 1343963336
      WHERE `session_id` = 'd75gi23qsuuhjs5hros3pvpli3'


        33 Query Types Logged, Sorted by Occurrences.


          SELECT Tables:

 1. 5 × SELECT * FROM chyc5_hikashop_address
 2. 3 × SELECT * FROM chyc5_hikashop_field as a
 3. 2 × SELECT a.*,b.* FROM chyc5_hikashop_user AS a LEFT JOIN
    chyc5_users AS b ON a.user_cms_id=b.id
 4. 2 × SELECT * FROM chyc5_hikashop_file
 5. 2 × SELECT * FROM chyc5_hikashop_discount
 6. 2 × SELECT a.* FROM chyc5_hikashop_zone_link AS a
 7. 2 × SELECT b.*,c.* FROM chyc5_hikashop_cart_product AS b LEFT JOIN
    chyc5_hikashop_product AS c ON b.product_id=c.product_id
 8. 2 × SELECT * FROM chyc5_hikashop_zone
 9. 2 × SELECT extension_id AS "id", element AS "option", params,
    enabled FROM chyc5_extensions
10. 1 × SELECT DISTINCT b.* FROM chyc5_hikashop_category AS a LEFT JOIN
    chyc5_hikashop_category AS b ON a.category_left >= b.category_left
11. 1 × SELECT * FROM chyc5_hikashop_confi
12. 1 × SELECT category_id FROM chyc5_hikashop_product_category
13. 1 × SELECT folder AS type, element AS name, params FROM chyc5_extensions
14. 1 × SELECT * FROM chyc5_hikashop_product
15. 1 × SELECT a.variant_product_id as product_id,b.characteristic_id as
    value_id,b.characteristic_value as value,c.characteristic_id as
    name_id,c.characteristic_value as name FROM chyc5_hikashop_variant
    AS a LEFT JOIN chyc5_hikashop_characteristic AS b ON
    a.variant_characteristic_id=b.characteristic_id LEFT JOIN
    chyc5_hikashop_characteristic AS c ON b.characteristic_parent_id =
    c.characteristic_id
16. 1 × SELECT * FROM chyc5_hikashop_shipping
17. 1 × SELECT b.*,c.* FROM chyc5_hikashop_category AS a LEFT JOIN
    chyc5_hikashop_taxation AS b ON
    a.category_namekey=b.category_namekey LEFT JOIN chyc5_hikashop_tax
    AS c ON b.tax_namekey=c.tax_namekey
18. 1 × SELECT * FROM chyc5_hikashop_currency
19. 1 × SELECT currency_id FROM chyc5_hikashop_currency
20. 1 × SELECT id, home, template, s.params FROM chyc5_template_styles
    as s LEFT JOIN chyc5_extensions as e ON e.element=s.template AND
    e.type='template' AND e.client_id=s.client_id
21. 1 × SELECT a.* FROM chyc5_hikashop_cart AS a
22. 1 × SELECT * FROM chyc5_languages
23. 1 × SELECT `data` FROM `chyc5_session`
24. 1 × SELECT * FROM chyc5_hikashop_price
25. 1 × SELECT a.*,b.* FROM chyc5_hikashop_variant AS a LEFT JOIN
    chyc5_hikashop_characteristic AS b ON
    a.variant_characteristic_id=b.characteristic_id
26. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route,
    m.link, m.type, m.level, m.language,m.browserNav, m.access,
    m.params, m.home, m.img, m.template_style_id, m.component_id,
    m.parent_id,e.element as component FROM chyc5_menu AS m LEFT JOIN
    chyc5_extensions AS e ON m.component_id = e.extension_id
27. 1 × SELECT a.id FROM chyc5_user_usergroup_map AS map LEFT JOIN
    chyc5_usergroups AS a ON a.id = map.group_id


          OTHER Tables:

 1. 1 × INSERT IGNORE INTO chyc5_hikashop_order_product
    (order_id,product_id,order_product_quantity,order_product_name,order_product_code,order_product_price,order_product_tax,order_product_options,order_product_option_parent_id,order_product_tax_info,white,blue,ivory,red,pink,black,purple,persimmon,mint,coral,royal,jade,surfblue,prose,willowpear,magenta,tomatorednavy,shellpink,stone,candy,spearmint,cream,mintsage,mintjade,pearsummer,claretrose,banana,greentea,carib,lemon,pearl,newlavender,sagemint,sweetmustard,toast,steelpurple,sandgreen,springblush,trueroyal,springkelly,bgreyash,fallmustard,springjade,springroyal,sandblack,sandtrueblue,moonlightrose,harborstone,newcoral,mustard,oyster,valleyjade,gardencoral,summerred,charmmustard,peach,steelblue,sunsetcoral,fhuntergreen,fallmagenta,fashiongreen,paradisegreen,bluefloral,royalanimal,jadeanimal,coralanimal,mintcircle,peachcircle,creamchiffon,mintsagechiffon,redprint,blueprint,olivelush,fhgreen,tomatonavy,harborstoneblack,moonlightroseblack,applesage,softpink,deepcoral,deepmagenta,darkcobalt,warmcoral,shalloworange,tealblue,fallrust,coco,olive,seagreen,mocha,greenprint,rustprint,freshred,swissmagenta,aprilorange,sesame,navy,fashionrust,fallgrape,royalgreystripes,jadegreystripes,orangegreystripes,dknavygreystripes,royalgreysmallstripes,blackgreysmallstripes,orangegreysmallstripes,orangeflame,dktrueroyal,pine,fallcobalt,newroyal,nilejade,naturalpeach,sandwhite,rustorange,stonesand,salmon,blackzigzag,blackdenim,navydenim,dustyrose,blackbirdprint,dkcharcoal,olivedots,navydots,newharborgreen,springred,greyhaze,printedmintpeachcoral,mochahaze,denimblue,printedmintsand,juicyrose,pismocoral,deeprose,lttaupe,peachkeen,shadowblue,palerose,blueindigo,jadefancy,turquoise,blackprinted,navyrabbits,blackrabbits,taupelittleanimals,corallittleanimals,bjade,coralprinted,springfuschia,mintstripes,orangestripes,summerlime,newcoralblack,smokygrey,huntergreen,juicycoral,coralmist,limeyellow,limeprint,mellowyellow,deeprust,harbermagenta,tealaqua,fashionred,tangerine,tealjade,zebraprint,charcoal,cobalt,deepnavy,deepred,lightcoral,summerroyal,blueblack,oliveblack,rosered,pinkblack,gingercoral,periwinkle,harborgreen,blacksilver,bluefloralprint,coralbrown,blackfloralprint,deeppurple,shallowblue,vintagerose,dutchblue,spice,fungi,toastalmond,summercoral,smokypink,default,newred,tobaccostripes,ruststripes,sandstripes,offwhitestripes,brownprint,polytoast,jadegreen,sand,rust,eggplant,deeproyal,blushkhaki,seajade,berryred,smoky,modernrust,fashionruby,gardengreen,frenchsage,redrose,burntorange,fallcoco)
    VALUES (40,715,1,'T-11361C: 1
    cream','T-11361C_75','52.5','0','a:4:{i:1;O:8:\"stdClass\":7:{s:25:\"variant_characteristic_id\";s:2:\"75\";s:18:\"variant_product_id\";s:3:\"715\";s:8:\"ordering\";s:1:\"0\";s:17:\"characteristic_id\";s:2:\"75\";s:24:\"characteristic_parent_id\";s:2:\"76\";s:20:\"characteristic_value\";s:1:\"1\";s:20:\"characteristic_alias\";s:0:\"\";}i:2;O:8:\"stdClass\":7:{s:25:\"variant_characteristic_id\";s:3:\"492\";s:18:\"variant_product_id\";s:3:\"715\";s:8:\"ordering\";s:1:\"0\";s:17:\"characteristic_id\";s:3:\"492\";s:24:\"characteristic_parent_id\";s:3:\"493\";s:20:\"characteristic_value\";s:5:\"cream\";s:20:\"characteristic_alias\";s:0:\"\";}s:15:\"swatch-selector\";s:1:\"1\";s:17:\"T-11361C
    swatches\";s:5:\"cream\";}',372,'a:0:{}','','','','','','','','','','','','','','','','','','','','','','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','1','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''
 2. 1 × UPDATE `chyc5_session` SET `data` =
    '__default|a:8:{s:15:\"session.counter\";i:74;s:19:\"session.timer.start\";i:1343961359;s:18:\"session.timer.last\";i:1343963322;s:17:\"session.timer.now\";i:1343963336;s:22:\"session.client.browser\";s:99:\"Mozilla/5.0
    (Windows NT 6.1) AppleWebKit/537.1 (KHTML, like Gecko)
    Chrome/21.0.1180.60
    Safari/537.1\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:12:\"com_hikashop\";O:8:\"stdClass\":22:{s:7:\"zone_id\";s:4:\"2914\";s:12:\"ssl_redirect\";i:0;s:7:\"cart_id\";i:142;s:15:\"shipping_method\";s:6:\"manual\";s:11:\"shipping_id\";i:6;s:13:\"shipping_data\";O:8:\"stdClass\":16:{s:11:\"shipping_id\";s:1:\"6\";s:13:\"shipping_type\";s:6:\"manual\";s:21:\"shipping_zone_namekey\";s:0:\"\";s:15:\"shipping_tax_id\";s:1:\"0\";s:14:\"shipping_price\";s:7:\"0.00000\";s:20:\"shipping_currency_id\";s:1:\"2\";s:13:\"shipping_name\";s:3:\"UCL\";s:20:\"shipping_description\";s:0:\"\";s:18:\"shipping_published\";s:1:\"1\";s:17:\"shipping_ordering\";s:1:\"1\";s:15:\"shipping_params\";O:8:\"stdClass\":18:{s:19:\"shipping_percentage\";s:1:\"0\";s:20:\"shipping_per_product\";s:1:\"0\";s:26:\"shipping_price_per_product\";s:0:\"\";s:18:\"shipping_min_price\";s:0:\"\";s:18:\"shipping_max_price\";s:0:\"\";s:25:\"shipping_virtual_included\";s:1:\"0\";s:25:\"shipping_override_address\";s:1:\"0\";s:30:\"shipping_override_address_text\";s:0:\"\";s:19:\"shipping_min_weight\";s:0:\"\";s:19:\"shipping_max_weight\";s:0:\"\";s:20:\"shipping_weight_unit\";s:2:\"kg\";s:19:\"shipping_zip_prefix\";s:0:\"\";s:16:\"shipping_min_zip\";s:0:\"\";s:16:\"shipping_max_zip\";s:0:\"\";s:19:\"shipping_zip_suffix\";s:0:\"\";s:19:\"shipping_min_volume\";s:0:\"\";s:19:\"shipping_max_volume\";s:0:\"\";s:18:\"shipping_size_unit\";s:1:\"m\";}s:15:\"shipping_images\";s:0:\"\";s:15:\"shipping_access\";s:3:\"all\";s:23:\"shipping_price_with_tax\";d:0;s:28:\"shipping_price_orig_with_tax\";d:0;s:5:\"total\";O:8:\"stdClass\":1:{s:6:\"prices\";a:1:{i:0;O:8:\"stdClass\":6:{s:11:\"price_value\";d:52.5;s:20:\"price_value_with_tax\";d:52.5;s:17:\"price_currency_id\";i:2;s:5:\"taxes\";a:0:{}s:37:\"price_value_without_shipping_with_tax\";d:52.5;s:28:\"price_value_without_shipping\";d:52.5;}}}}s:14:\"payment_method\";s:12:\"banktransfer\";s:10:\"payment_id\";i:2;s:12:\"payment_data\";O:8:\"stdClass\":27:{s:10:\"payment_id\";s:1:\"2\";s:12:\"payment_name\";s:26:\"credit
    card by fax /
    phone\";s:19:\"payment_description\";s:0:\"\";s:14:\"payment_images\";s:13:\"Bank_transfer\";s:14:\"payment_params\";O:8:\"stdClass\":2:{s:12:\"order_status\";s:7:\"created\";s:11:\"information\";s:0:\"\";}s:12:\"payment_type\";s:12:\"banktransfer\";s:20:\"payment_zone_namekey\";s:0:\"\";s:14:\"payment_access\";s:3:\"all\";s:24:\"payment_shipping_methods\";s:0:\"\";s:16:\"payment_currency\";s:0:\"\";s:12:\"extension_id\";s:5:\"10007\";s:4:\"name\";s:37:\"HikaShop
    bank transfer payment
    plugin\";s:4:\"type\";s:6:\"plugin\";s:7:\"element\";s:12:\"banktransfer\";s:6:\"folder\";s:15:\"hikashoppayment\";s:9:\"client_id\";s:1:\"0\";s:7:\"enabled\";s:1:\"1\";s:6:\"access\";s:1:\"1\";s:9:\"protected\";s:1:\"0\";s:14:\"manifest_cache\";s:0:\"\";s:6:\"params\";s:0:\"\";s:11:\"custom_data\";s:0:\"\";s:11:\"system_data\";s:0:\"\";s:11:\"checked_out\";s:1:\"0\";s:16:\"checked_out_time\";s:19:\"0000-00-00
    00:00:00\";s:8:\"ordering\";s:1:\"0\";s:5:\"state\";s:1:\"0\";}s:16:\"shipping_address\";s:2:\"11\";s:15:\"billing_address\";s:2:\"11\";s:14:\"checkout_terms\";s:1:\"1\";s:18:\"checkout_fields_ok\";i:0;s:8:\"order_id\";i:39;s:11:\"coupon_code\";s:0:\"\";s:9:\"cc_number\";s:0:\"\";s:8:\"cc_month\";s:0:\"\";s:7:\"cc_year\";s:0:\"\";s:6:\"cc_CCV\";s:0:\"\";s:8:\"cc_owner\";s:0:\"\";s:8:\"cc_valid\";i:0;s:15:\"checkout_fields\";N;}s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":1:{s:4:\"data\";a:0:{}}}}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";s:2:\"92\";s:4:\"name\";s:4:\"test\";s:8:\"username\";s:14:\"test@gmail.com\";s:5:\"email\";s:22:\"kim.carigtan@gmail.com\";s:8:\"password\";s:65:\"b9663584f77ecd8acdd4d18656dca7a5:tU6TMuvn6w4IPYJq8WiF3mum7mnubjC4\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2012-07-27
    14:39:40\";s:13:\"lastvisitDate\";s:19:\"2012-08-03
    02:11:36\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{s:10:\"Registered\";s:1:\"2\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:2;}s:14:\"\0*\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:2;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"1303c205d4f7bf07e10ce72e2487a681\";}hikashop_viewed_products|a:2:{i:849;i:849;i:714;i:714;}hikashop_item_data|O:8:\"stdClass\":2:{s:5:\"cream\";s:1:\"0\";s:11:\"huntergreen\";s:1:\"1\";}',
    `time` = 1343963336
 3. 1 × UPDATE chyc5_hikashop_product SET product_sales = product_sales + 1
 4. 1 × UPDATE chyc5_hikashop_product SET product_quantity =
    product_quantity - 1
 5. 1 × UPDATE `chyc5_hikashop_order` SET
    `order_user_id`='50',`order_status`='created',`order_shipping_address_id`='11',`order_billing_address_id`='11',`order_currency_id`='2',`order_type`='sale',`order_full_price`='52.5',`order_shipping_price`='0',`order_shipping_tax`='0',`order_discount_tax`='0',`order_discount_price`='0',`order_shipping_id`='6',`order_shipping_method`='manual',`order_payment_id`='2',`order_payment_method`='banktransfer',`order_created`='1343963336',`order_ip`='124.6.181.55',`order_modified`='1343963336',`order_number`='B4T0'
 6. 1 × INSERT IGNORE INTO `chyc5_hikashop_order` (
    `order_user_id`,`order_status`,`order_shipping_address_id`,`order_billing_address_id`,`order_currency_id`,`order_type`,`order_full_price`,`order_tax_info`,`order_shipping_price`,`order_shipping_tax`,`order_discount_tax`,`order_discount_price`,`order_shipping_id`,`order_shipping_method`,`order_payment_id`,`order_payment_method`,`order_created`,`order_ip`,`order_modified`
    ) VALUES (
    '50','created','11','11','2','sale','52.5','a:0:{}','0','0','0','0','6','manual','2','banktransfer','1343963336','124.6.181.55','1343963336'