14 Comments
тна Return to thread

I'm trying to get the online Parkhomov SQL program here

https://www.nanosoft.co.nz/Fusion.php

to duplicate Bob's results on the bottom line here.

https://youtu.be/ysvsdwHUETg?t=409

Anybody got any tips?

Expand full comment

Here is the full query. All I did is add the elements observed to have been synthesised or increased. This points to the underlying state of the level of the process.

E1 in ('O') and E2 in ('W' ) and E3 in ('Si', 'Ca', 'V', 'Cr', 'Fe', 'Cu', 'Zn', 'Zr') order by MeV desc

Expand full comment
Comment deleted
Dec 15, 2021
Comment deleted
Expand full comment

They are still heavy and will fission further.

Expand full comment

OK. I saw your latest query. TwoToTwoAll works.

select * from TwoToTwoAll where E1 in ('O') and E2 in ('W' ) and E3 in ('Si', 'Ca', 'V', 'Cr', 'Fe', 'Cu', 'Zn', 'Zr') order by MeV desc limit 1000

Expand full comment

UPDATE (much later)...

I had used the Fusion functions instead of the TwoToTwo (exchange) functions. Fission didn't have enough inputs, lol. :-)

To anyone reading this.

[Attempt to tag @m3sca1 here.]

You can select where to input you query text at links at the top of the page or you can enter the full query string in the input box for any of the functions. (This may be useful if you want to keep your variables but you're on the wrong page... or if you just like typing a lot, lol.)

For a *full query string* that will take you to the page that's appropriate for your query regardless of where you started:

Input:

select * from <table> where <conditions> order by <col> <dir> limit <n>

====================================

* table: FissionAll[NewPlus], FusionAll[NewPlust], TwoToTwoAll[NewPlust], etc.

* conditions: ColumnX = 'ValueX' or ColumnX in ('Value1', 'Value2', ...) ...

. . | boolean operators: and, or, (not?)

. . | (parenthetic nesting: yes?)

Expand full comment
Comment deleted
Dec 15, 2021
Comment deleted
Expand full comment

This worked

E1 in ('O') and A2 = 180 and E3 in ('Si', 'Ca', 'V', 'Cr', 'Fe', 'Cu', 'Zn', 'Zr') order by MeV desc

Expand full comment

What is it that you are after?

Expand full comment

I think I'm sorta getting this.

Is this something of interest to you?

N14 ... W184 MeV = 123.464448

Using (code limit 202 for ID in the buffer)

e1 in ( 'n' ) and a2 in ( 184 ) and e2 < > 'Os' and a4 > = 100 and MeV > 115 order by MeV desc limit 202

[Keeping Osmium out because we only want W184 (the common isotope).]

This link *might* still work if you want to see it.

https://www.nanosoft.co.nz/results/select_*_from_TwoToTwoAllNewPlus_where_e1inlbnrbanda2inlb184rbande2ltgtOsanda4gteq100andMeVgt115ByMeVDescLimit202.html

If there's O2 in there there might also be N2, no? And this packs a little more punch if I understand how this works.

Expand full comment

Yes there will be N2 from Air, but as I have said, O2 is uniquely paramagnetic for the elements at the bottom of the table and it aggregates the EVOs that can transmute matter in a way that N2 is less good at and O2 is something that will come from the water and the Air.

I just chose it as indicative.

Expand full comment

Just trying to duplicate your results.

Also seeing how the spreadsheet is set up. Lots of experimenting. Even cheaper than ULTR !! :-)

Gotta run. I'll probably bug you again later...

Expand full comment

E1 in ('O') and E2 in ('W' ) and E3 in ('Zr') order by MeV desc

Expand full comment

This probably works for you. No results for me tho.

E1 in ('O') and A2 in (180) and E3 in ('Zr') order by MeV desc

Expand full comment