mysql> select * from lp_analysis where typename like "%nirvana%";
+------------+-------------+---------------+----------+----------+---------+--------------+--------------+--------------+---------+----------+--------------+--------------------------------------+---------+----------------+
| isk_per_lp | isk_per_lpc | corporationid | offer_id | quantity | type_id | buy_price    | total_cost   | offer_cost   | lp_cost | week_vol | 1pcbuyvol_lp | typename                             | itemID  | npc            |
+------------+-------------+---------------+----------+----------+---------+--------------+--------------+--------------+---------+----------+--------------+--------------------------------------+---------+----------------+
|    3613.09 |       0.000 |       1000162 |    16421 |        1 |   53727 | 667351126.84 | 345223136.89 |  85000000.00 |   85000 |  13.5000 |    255000.00 | Mid-Grade Nirvana Omega Blueprint    | 1000162 | True Power     |
|    3613.09 |       0.000 |       1000161 |    16421 |        1 |   53727 | 667351126.84 | 345223136.89 |  85000000.00 |   85000 |  13.5000 |    255000.00 | Mid-Grade Nirvana Omega Blueprint    | 1000161 | True Creations |
|    3330.18 |       0.000 |       1000162 |    16419 |        1 |   53725 | 459438345.21 | 299242976.22 |  45000000.00 |   45000 |  20.5000 |    225000.00 | Mid-Grade Nirvana Epsilon Blueprint  | 1000162 | True Power     |
|    3330.18 |       0.000 |       1000161 |    16419 |        1 |   53725 | 459438345.21 | 299242976.22 |  45000000.00 |   45000 |  20.5000 |    225000.00 | Mid-Grade Nirvana Epsilon Blueprint  | 1000161 | True Creations |
|    2382.11 |       0.000 |       1000162 |    16420 |        1 |   53726 | 293739364.34 | 251398523.06 |  15000000.00 |   15000 |  19.5000 |     75000.00 | Mid-Grade Nirvana Gamma Blueprint    | 1000162 | True Power     |
|    2382.11 |       0.000 |       1000161 |    16420 |        1 |   53726 | 293739364.34 | 251398523.06 |  15000000.00 |   15000 |  19.5000 |     75000.00 | Mid-Grade Nirvana Gamma Blueprint    | 1000161 | True Creations |
|    1396.86 |       0.000 |       1000161 |    16416 |        1 |   53722 | 192521220.09 | 177713052.41 |   7500000.00 |    7500 |  24.0000 |     22500.00 | Mid-Grade Nirvana Alpha Blueprint    | 1000161 | True Creations |
|    1396.86 |       0.000 |       1000162 |    16416 |        1 |   53722 | 192521220.09 | 177713052.41 |   7500000.00 |    7500 |  24.0000 |     22500.00 | Mid-Grade Nirvana Alpha Blueprint    | 1000162 | True Power     |
|    1200.84 |       0.000 |       1000161 |    16424 |        1 |   53729 | 434099989.27 | 386506136.99 |  32000000.00 |   31500 |  42.0000 |    252000.00 | High-Grade Nirvana Beta Blueprint    | 1000161 | True Creations |
|    1200.84 |       0.000 |       1000162 |    16424 |        1 |   53729 | 434099989.27 | 386506136.99 |  32000000.00 |   31500 |  42.0000 |    252000.00 | High-Grade Nirvana Beta Blueprint    | 1000162 | True Power     |
|    1084.47 |       0.000 |       1000161 |    16425 |        1 |   53730 | 608099189.47 | 509015220.63 |  75000000.00 |   78750 |  34.0000 |    787500.00 | High-Grade Nirvana Delta Blueprint   | 1000161 | True Creations |
|    1084.47 |       0.000 |       1000162 |    16425 |        1 |   53730 | 608099189.47 | 509015220.63 |  75000000.00 |   78750 |  34.0000 |    787500.00 | High-Grade Nirvana Delta Blueprint   | 1000162 | True Power     |
|     793.96 |       0.000 |       1000162 |    16428 |        1 |   53733 | 950000356.76 | 716042501.01 | 265000000.00 |  267750 |  34.0000 |   2677500.00 | High-Grade Nirvana Omega Blueprint   | 1000162 | True Power     |
|     793.96 |       0.000 |       1000161 |    16428 |        1 |   53733 | 950000356.76 | 716042501.01 | 265000000.00 |  267750 |  34.0000 |   2677500.00 | High-Grade Nirvana Omega Blueprint   | 1000161 | True Creations |
|     584.39 |       0.000 |       1000161 |    16427 |        1 |   53732 | 506000018.39 | 467002746.17 |  50000000.00 |   47250 |  34.5000 |    378000.00 | High-Grade Nirvana Gamma Blueprint   | 1000161 | True Creations |
|     584.39 |       0.000 |       1000162 |    16427 |        1 |   53732 | 506000018.39 | 467002746.17 |  50000000.00 |   47250 |  34.5000 |    378000.00 | High-Grade Nirvana Gamma Blueprint   | 1000162 | True Power     |
|     381.70 |       0.000 |       1000161 |    16417 |        1 |   53723 | 219621735.42 | 210863271.81 |  10000000.00 |   10000 |  26.5000 |     50000.00 | Mid-Grade Nirvana Beta Blueprint     | 1000161 | True Creations |
|     381.70 |       0.000 |       1000162 |    16417 |        1 |   53723 | 219621735.42 | 210863271.81 |  10000000.00 |   10000 |  26.5000 |     50000.00 | Mid-Grade Nirvana Beta Blueprint     | 1000162 | True Power     |
|     139.56 |       0.000 |       1000161 |    16426 |        1 |   53731 | 620009025.94 | 586275595.74 | 140000000.00 |  141750 |  29.5000 |   1134000.00 | High-Grade Nirvana Epsilon Blueprint | 1000161 | True Creations |
|     139.56 |       0.000 |       1000162 |    16426 |        1 |   53731 | 620009025.94 | 586275595.74 | 140000000.00 |  141750 |  29.5000 |   1134000.00 | High-Grade Nirvana Epsilon Blueprint | 1000162 | True Power     |
|    -346.30 |       0.000 |       1000161 |    16418 |        1 |   53724 | 272000201.11 | 274537749.12 |  25000000.00 |   25000 |  25.0000 |    150000.00 | Mid-Grade Nirvana Delta Blueprint    | 1000161 | True Creations |
|    -346.30 |       0.000 |       1000162 |    16418 |        1 |   53724 | 272000201.11 | 274537749.12 |  25000000.00 |   25000 |  25.0000 |    150000.00 | Mid-Grade Nirvana Delta Blueprint    | 1000162 | True Power     |
|    -469.48 |       0.000 |       1000162 |    16423 |        1 |   53728 | 323005087.43 | 326829055.24 |  23000000.00 |   23625 |  28.0000 |    307125.00 | High-Grade Nirvana Alpha Blueprint   | 1000162 | True Power     |
|    -469.48 |       0.000 |       1000161 |    16423 |        1 |   53728 | 323005087.43 | 326829055.24 |  23000000.00 |   23625 |  28.0000 |    307125.00 | High-Grade Nirvana Alpha Blueprint   | 1000161 | True Creations |
+------------+-------------+---------------+----------+----------+---------+--------------+--------------+--------------+---------+----------+--------------+--------------------------------------+---------+----------------+