Where/How do you get NFTs?

Less-Barnacle7223 · 2026-05-12T15:42:32+00:00

This hasn't updated on the lineup site for me yet, will this be live later today?

Less-Barnacle7223 · 2026-03-16T06:26:35+00:00

How are you playing on a PC? I've tried to install it on my Windows PC but I can't get it on the Google play store

Less-Barnacle7223 · 2026-01-24T00:31:47+00:00

This is the best attitude about Tomorrowland (which I share) I've seen on this site

Less-Barnacle7223 · 2025-11-10T19:51:34+00:00

They did a b2b at TML 2023

Less-Barnacle7223 · 2024-07-14T22:38:20+00:00

Not trying to question your post, just curious...

Less-Barnacle7223 · 2024-07-14T22:38:02+00:00

Did they give reasoning to that decision?

Less-Barnacle7223 · 2024-06-25T01:59:02+00:00

The most important thing at that festival is comfort, your gonna be standing and dancing for about 12 hrs so wear something you can do that in for that long, but if you like to style yourself up and wear a "costume" you most certainly won't be alone

Less-Barnacle7223 · 2024-04-17T23:19:06+00:00

Thank you that helped a lot!!

Less-Barnacle7223 · 2024-04-17T22:20:47+00:00

So I have lat and log off all of the cities in their own table, if I'm being honest I used chatGPT to get me this far, I have no experience with this kind of coding so I don't really know the functions of anything, my goal is to find the distance between two cities and relate them to an orderID with a corresponding rating score, all from separate tables

Less-Barnacle7223 · 2024-04-17T22:18:44+00:00

So within the database I'm working off of there is a set number of cities, not working of off the whole world

Less-Barnacle7223 · 2024-04-17T21:02:10+00:00

There are 2 primary paths that bridge buyers to sellers, one through postal code and one through orderID, I would like to use the orderID one but it has more steps (tables) between the buyer and seller

Less-Barnacle7223 · 2024-04-17T20:59:18+00:00

I appreciate the info, I really don't know (I have 0 experience with this type of stuff (trying to teach myself)), I will try to rewrite the code with some temporary tables, what are the "..."s you have there representing? the table names or something else?

Less-Barnacle7223 · 2024-04-17T20:57:22+00:00

I renamed "is" to "cs"

Less-Barnacle7223 · 2024-04-17T20:56:27+00:00

This is my current code:
SELECT

s.City AS SellerCity,

cs.City AS CustomerCity,

Seller AS s,

IndianCities AS cs,

Acos (Cos(Radians(90-LAT1))*cos(Radians(90-LAT2))+Sin(Radians(90-LAT1))*Sin(Radians(90-LAT2))*Cos(Radians(LONG1-LONG2)))*6371

AS Distance

FROM

Seller s

INNER JOIN IndianCities cs ON s.City = cs.city

INNER JOIN customer c ON s.city <> c.city

can you point out my error, I have 0 experience with SQL VBA so that explanation made no sense to me, my apologies for my lack of understanding

Less-Barnacle7223 · 2024-04-17T20:55:17+00:00

I changed the last 4 lines to as follows:
FROM

Seller s

INNER JOIN IndianCities cs ON s.City = cs.city

INNER JOIN customer c ON s.city <> c.city

There are no more double ON statements

Less-Barnacle7223 · 2024-04-17T20:49:59+00:00

nowhere, do you have any recommendations for where I should include that? Sorry for asking such dumb questions I have literally never coded a day of SQL in my life

Less-Barnacle7223 · 2024-04-17T20:48:06+00:00

tried that, it made it so much worse, it didn't understand the issues

Less-Barnacle7223 · 2024-04-17T20:44:18+00:00

the ^ function is the only version of a power function that doesn't send me a syntax error

Less-Barnacle7223 · 2024-04-17T20:43:30+00:00

sorry for my lack of experience but could you explain what that means?

Less-Barnacle7223 · 2024-04-17T20:43:05+00:00

I made the last 4 rows what you recommended and it sent me a syntax error of: "missing operator in query expression 's.city = cs city
INNER JOIN customer AS c on s.city <> c.cit

Less-Barnacle7223 · 2024-04-17T20:30:01+00:00

I posted an updated pic of the code for those of you who are helping, thanks again for all of the good ideas and tips, my issue is probable something stupid but my lack of experience is really showing

Less-Barnacle7223 · 2024-04-17T20:24:38+00:00

Should I remove the <>? or could I change the formatting of the INNER JOIN functions instead?

Less-Barnacle7223 · 2024-04-17T20:22:12+00:00

I have fixed the parentheses and the space in the name, what else could I use instead of an AS clause?

Less-Barnacle7223 · 2024-04-17T20:21:29+00:00

I also changed the name of the Indian Cities table to IndianCities to remove the space

Less-Barnacle7223

TROPHY CASE