SELECT 
  combination 
FROM 
  cscart_product_options_inventory 
WHERE 
  product_id = 3321 
  AND amount > 0 
  AND combination != ''

Query time 0.00158

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_options_inventory range pc pc 770 125 Using index condition; Using where

Result

combination
1215_22739_1214_22741_1216_22731
1215_22739_1214_22741_1216_22732
1215_22739_1214_22741_1216_22734
1215_22739_1214_22741_1216_22735
1215_22739_1214_22741_1216_24196
1215_22739_1214_22742_1216_22731
1215_22739_1214_22742_1216_22734
1215_22739_1214_22742_1216_22735
1215_22739_1214_22742_1216_24196
1215_22739_1214_22743_1216_22731
1215_22739_1214_22743_1216_22732
1215_22739_1214_22743_1216_22734
1215_22739_1214_22743_1216_22735
1215_22739_1214_22743_1216_24196
1215_22739_1214_22744_1216_22731
1215_22739_1214_22744_1216_22732
1215_22739_1214_22744_1216_22734
1215_22739_1214_22744_1216_22735
1215_22739_1214_22744_1216_24196
1215_22739_1214_22745_1216_22731
1215_22739_1214_22745_1216_22732
1215_22739_1214_22745_1216_22734
1215_22739_1214_22745_1216_22735
1215_22739_1214_22745_1216_24196
1215_22739_1214_22746_1216_22731
1215_22739_1214_22746_1216_22732
1215_22739_1214_22746_1216_22734
1215_22739_1214_22746_1216_22735
1215_22739_1214_22746_1216_24196
1215_22739_1214_22747_1216_22731
1215_22739_1214_22747_1216_22732
1215_22739_1214_22747_1216_22734
1215_22739_1214_22747_1216_22735
1215_22739_1214_22747_1216_24196
1215_22739_1214_22748_1216_22731
1215_22739_1214_22748_1216_22732
1215_22739_1214_22748_1216_22734
1215_22739_1214_22748_1216_22735
1215_22739_1214_22748_1216_24196
1215_22739_1214_22749_1216_22731
1215_22739_1214_22749_1216_22732
1215_22739_1214_22749_1216_22734
1215_22739_1214_22749_1216_22735
1215_22739_1214_22749_1216_24196
1215_22739_1214_22750_1216_22731
1215_22739_1214_22750_1216_22732
1215_22739_1214_22750_1216_22734
1215_22739_1214_22750_1216_22735
1215_22739_1214_22750_1216_24196
1215_22739_1214_22751_1216_22731
1215_22739_1214_22751_1216_22732
1215_22739_1214_22751_1216_22734
1215_22739_1214_22751_1216_22735
1215_22739_1214_22751_1216_24196
1215_22739_1214_22752_1216_22731
1215_22739_1214_22752_1216_22732
1215_22739_1214_22752_1216_22734
1215_22739_1214_22752_1216_22735
1215_22739_1214_22752_1216_24196
1215_22739_1214_22753_1216_22731
1215_22739_1214_22753_1216_22732
1215_22739_1214_22753_1216_22734
1215_22739_1214_22753_1216_22735
1215_22739_1214_22753_1216_24196
1215_22739_1214_22754_1216_22731
1215_22739_1214_22754_1216_22732
1215_22739_1214_22754_1216_22734
1215_22739_1214_22754_1216_22735
1215_22739_1214_22754_1216_24196
1215_22739_1214_22755_1216_22731
1215_22739_1214_22755_1216_22732
1215_22739_1214_22755_1216_22734
1215_22739_1214_22755_1216_22735
1215_22739_1214_22755_1216_24196
1215_22739_1214_22756_1216_22731
1215_22739_1214_22756_1216_22732
1215_22739_1214_22756_1216_22734
1215_22739_1214_22756_1216_22735
1215_22739_1214_22756_1216_24196
1215_22739_1214_22757_1216_22731
1215_22739_1214_22757_1216_22732
1215_22739_1214_22757_1216_22734
1215_22739_1214_22757_1216_22735
1215_22739_1214_22757_1216_24196
1215_22739_1214_22758_1216_22731
1215_22739_1214_22758_1216_22732
1215_22739_1214_22758_1216_22734
1215_22739_1214_22758_1216_22735
1215_22739_1214_22758_1216_24196
1215_22739_1214_22759_1216_22731
1215_22739_1214_22759_1216_22732
1215_22739_1214_22759_1216_22734
1215_22739_1214_22759_1216_22735
1215_22739_1214_22759_1216_24196
1215_22739_1214_22760_1216_22731
1215_22739_1214_22760_1216_22732
1215_22739_1214_22760_1216_22734
1215_22739_1214_22760_1216_22735
1215_22739_1214_22760_1216_24196
1215_22739_1214_22761_1216_22731
1215_22739_1214_22761_1216_22732
1215_22739_1214_22761_1216_22734
1215_22739_1214_22761_1216_22735
1215_22739_1214_22761_1216_24196
1215_22740_1214_22741_1216_22731
1215_22740_1214_22741_1216_22732
1215_22740_1214_22741_1216_22734
1215_22740_1214_22741_1216_22735
1215_22740_1214_22741_1216_24196
1215_22740_1214_22742_1216_22731
1215_22740_1214_22742_1216_22732
1215_22740_1214_22742_1216_22734
1215_22740_1214_22742_1216_22735
1215_22740_1214_22742_1216_24196
1215_22740_1214_22743_1216_22731
1215_22740_1214_22743_1216_22732
1215_22740_1214_22743_1216_22734
1215_22740_1214_22743_1216_22735
1215_22740_1214_22743_1216_24196
1215_22740_1214_22744_1216_22731
1215_22740_1214_22744_1216_22732
1215_22740_1214_22744_1216_22734
1215_22740_1214_22744_1216_22735
1215_22740_1214_22744_1216_24196
1215_22740_1214_22745_1216_22731
1215_22740_1214_22745_1216_22732
1215_22740_1214_22745_1216_22734
1215_22740_1214_22745_1216_22735
1215_22740_1214_22745_1216_24196
1215_22740_1214_22746_1216_22731
1215_22740_1214_22746_1216_22732
1215_22740_1214_22746_1216_22734
1215_22740_1214_22746_1216_22735
1215_22740_1214_22746_1216_24196
1215_22740_1214_22747_1216_22731
1215_22740_1214_22747_1216_22732
1215_22740_1214_22747_1216_22734
1215_22740_1214_22747_1216_22735
1215_22740_1214_22747_1216_24196
1215_22740_1214_22748_1216_22731
1215_22740_1214_22748_1216_22732
1215_22740_1214_22748_1216_22734
1215_22740_1214_22748_1216_22735
1215_22740_1214_22748_1216_24196
1215_22740_1214_22749_1216_22731
1215_22740_1214_22749_1216_22732
1215_22740_1214_22749_1216_22734
1215_22740_1214_22749_1216_22735
1215_22740_1214_22749_1216_24196
1215_22740_1214_22750_1216_22731
1215_22740_1214_22750_1216_22732
1215_22740_1214_22750_1216_22734
1215_22740_1214_22750_1216_22735
1215_22740_1214_22750_1216_24196
1215_22740_1214_22751_1216_22731
1215_22740_1214_22751_1216_22732
1215_22740_1214_22751_1216_22734
1215_22740_1214_22751_1216_22735
1215_22740_1214_22751_1216_24196
1215_22740_1214_22752_1216_22731
1215_22740_1214_22752_1216_22732
1215_22740_1214_22752_1216_22734
1215_22740_1214_22752_1216_22735
1215_22740_1214_22752_1216_24196
1215_22740_1214_22753_1216_22731
1215_22740_1214_22753_1216_22732
1215_22740_1214_22753_1216_22734
1215_22740_1214_22753_1216_22735
1215_22740_1214_22753_1216_24196
1215_22740_1214_22754_1216_22731
1215_22740_1214_22754_1216_22732
1215_22740_1214_22754_1216_22734
1215_22740_1214_22754_1216_22735
1215_22740_1214_22754_1216_24196
1215_22740_1214_22755_1216_22731
1215_22740_1214_22755_1216_22732
1215_22740_1214_22755_1216_22734
1215_22740_1214_22755_1216_22735
1215_22740_1214_22755_1216_24196
1215_22740_1214_22756_1216_22731
1215_22740_1214_22756_1216_22732
1215_22740_1214_22756_1216_22734
1215_22740_1214_22756_1216_22735
1215_22740_1214_22756_1216_24196
1215_22740_1214_22757_1216_22731
1215_22740_1214_22757_1216_22732
1215_22740_1214_22757_1216_22734
1215_22740_1214_22757_1216_22735
1215_22740_1214_22757_1216_24196
1215_22740_1214_22758_1216_22731
1215_22740_1214_22758_1216_22732
1215_22740_1214_22758_1216_22734
1215_22740_1214_22758_1216_22735
1215_22740_1214_22758_1216_24196
1215_22740_1214_22759_1216_22731
1215_22740_1214_22759_1216_22732
1215_22740_1214_22759_1216_22734
1215_22740_1214_22759_1216_22735
1215_22740_1214_22759_1216_24196
1215_22740_1214_22760_1216_22731
1215_22740_1214_22760_1216_22732
1215_22740_1214_22760_1216_22734
1215_22740_1214_22760_1216_22735
1215_22740_1214_22760_1216_24196
1215_22740_1214_22761_1216_22731
1215_22740_1214_22761_1216_22732
1215_22740_1214_22761_1216_22734
1215_22740_1214_22761_1216_22735
1215_22740_1214_22761_1216_24196