INSERT INTO `usp_product_to_category` (`product_id`, `category_id`) VALUES ((SELECT product_id FROM usp_product WHERE sku = 'sku'),(SELECT category_id FROM usp_category_description WHERE name = 'Subcategory'))



INSERT INTO `usp_product_to_category` (`product_id`, `category_id`) VALUES ((SELECT product_id FROM usp_product WHERE sku = 'sku'),(SELECT category_id FROM usp_category_description WHERE name = 'Topcategory'))



*************************** 1. row ***************************
  Field: category_id
   Type: int(11)
   Null: NO
    Key: PRI
Default: NULL
  Extra: auto_increment
*************************** 2. row ***************************
  Field: image
   Type: varchar(255)
   Null: YES
    Key:
Default: NULL
  Extra:
*************************** 3. row ***************************
  Field: parent_id
   Type: int(11)
   Null: NO
    Key:
Default: 0
  Extra:
*************************** 4. row ***************************
  Field: sort_order
   Type: int(3)
   Null: NO
    Key:
Default: 0
  Extra:
*************************** 5. row ***************************
  Field: date_added
   Type: datetime
   Null: NO
    Key:
Default: 0000-00-00 00:00:00
  Extra:
*************************** 6. row ***************************
  Field: date_modified
   Type: datetime
   Null: NO
    Key:
Default: 0000-00-00 00:00:00
  Extra:
*************************** 7. row ***************************
  Field: status
   Type: int(1)
   Null: NO
    Key:
Default: 1
  Extra:
7 rows in set (0.00 sec)



describe usp_category_description \G;
*************************** 1. row ***************************
  Field: category_id
   Type: int(11)
   Null: NO
    Key: PRI
Default: NULL
  Extra:
*************************** 2. row ***************************
  Field: language_id
   Type: int(11)
   Null: NO
    Key: PRI
Default: NULL
  Extra:
*************************** 3. row ***************************
  Field: name
   Type: varchar(32)
   Null: NO
    Key: MUL
Default:
  Extra:
*************************** 4. row ***************************
  Field: meta_description
   Type: varchar(255)
   Null: NO
    Key:
Default: NULL
  Extra:
*************************** 5. row ***************************
  Field: description
   Type: text
   Null: NO
    Key:
Default: NULL
  Extra:
5 rows in set (0.00 sec)