00:36.07 | *** join/##kierra Valumzie (n=valumz@75.144.224.155) |
00:36.07 | *** mode/##kierra [+o Valumzie] by ChanServ |
01:00.49 | Valumzie | ~lart catay |
01:00.49 | purl | shoots catay in the head |
01:44.15 | Birdie | how can poker be sooooooooooooooo unlucky on internet |
01:44.20 | Birdie | this game is made for making me mad |
02:59.52 | gn00bie | 20:01 <@Valumzie> ~lart catay |
02:59.55 | gn00bie | 20:01 * purl shoots catay in the head |
02:59.59 | gn00bie | ~Valumzie++ |
03:05.46 | *** join/##kierra kierra (n=jolie@c-98-230-5-184.hsd1.fl.comcast.net) |
03:05.47 | *** mode/##kierra [+o kierra] by ChanServ |
03:11.40 | gn00bie | busy mom |
03:34.34 | kierra | hey |
03:34.47 | kierra | gn00bie: going to California on the 10th |
03:35.09 | kierra | i'm going to live dangerously there ;) |
03:39.57 | gn00bie | kierra: oh you hardly live dangerously |
03:40.03 | gn00bie | I need to teach you some of that |
03:40.18 | gn00bie | but for now, bed time |
03:40.37 | gn00bie | going to visit the eldest? |
03:40.54 | gn00bie | bye bye |
03:46.32 | kierra | yes |
03:46.45 | kierra | oh but I have plans for CA ;) |
03:55.59 | Valumzie | kierra: ping :) |
12:06.20 | Valumzie | ~wake brlcad |
12:06.42 | purl | ACTION throws a barrel-full of ice water on brlcad and shouts "GOOD MORNING!!!!" |
12:06.43 | Valumzie | nobody wants to wake him :) |
12:06.46 | Valumzie | oh |
12:06.51 | Valumzie | slow slow purl! |
12:10.30 | kierra | hi Valumzie |
12:10.42 | kierra | ~wake brlcad |
12:10.42 | purl | ACTION throws a barrel-full of ice water on brlcad and shouts "GOOD MORNING!!!!" |
12:10.48 | kierra | ~ice brlcad |
12:10.48 | purl | ACTION sneaks up behind brlcad and dumps an entire bucket of ice on top of them |
12:18.36 | ndim | ~coffee kierra |
12:18.37 | purl | ACTION steals some of Pimpi_'s special coffee and gives it to kierra on a silver platter. |
12:18.45 | ndim | ~coffee Valumzie |
12:18.46 | purl | ACTION steals some of Winny's special coffee and gives it to Valumzie on a silver platter. |
12:18.57 | ndim | ~coffee ndim |
12:18.58 | purl | ACTION steals some of purl's special coffee and gives it to ndim on a silver platter. |
12:19.22 | Valumzie | coffee!!! |
12:19.23 | kierra | ty ndim |
12:19.29 | kierra | ~tea ndim |
12:19.30 | purl | ACTION realizes it's time for high tea and gets busy in the kitchen. He brings out tea, crumpets, scones and an assortment of delectable goodies and serves them properly to ndim and others |
12:19.34 | kierra | ~pinch Manu |
12:19.34 | purl | ACTION scuttles after Manu, pinches him, and then scuttles away |
12:41.00 | kierra | gn00bie: you're right.....I don't live dangerously.....never have except for a few brief episodes :) |
12:42.07 | kierra | sky diving comes to mind, mule rides down the Grand Canyon, Soaring, rappeling off the face of a mountain..... |
12:42.40 | ndim | ...raising TRB |
12:44.27 | Manu | ~kiss kierra |
12:44.28 | purl | ACTION forces kierra to give TheRedBaron a big kiss on the ear |
12:45.26 | kierra | that I can handle ;) |
12:45.33 | kierra | and trb won't mind |
12:45.53 | kierra | lol, ndim! |
13:23.01 | brlcad | grumbles and yawns |
13:24.39 | Manu | throws a 5 1/4! floppy into brlcad's mouth |
13:37.57 | *** join/##kierra Upsetter (n=Ups@i59F7F278.versanet.de) |
13:40.03 | kierra | ~tickle brlcad |
13:40.26 | purl | ACTION jumps on brlcad, yelling "TICKLE FIGHT!!!!" |
13:40.26 | brlcad | squeals |
13:58.19 | TheRedBaron | raising trb ? |
13:58.22 | TheRedBaron | ~lart ndim |
13:58.22 | purl | chops ndim in half with a free AOL CD |
13:58.35 | TheRedBaron | I was good boi and easy child compared to my older sisters :P |
14:00.44 | kierra | so true, TRB was my brown-eyed handsome man |
14:17.13 | *** join/##kierra Upsetter (n=Ups@i59F7F278.versanet.de) |
14:30.07 | scott | groans |
14:30.39 | gn00bie | I think since you were pretty experienced by the time trb came along, he seemed easy |
14:30.52 | gn00bie | going by the maple syrup incident, he could have been a handful |
14:31.15 | gn00bie | but then again, maybe the maple syrup incident shows that he loves you a lot |
14:31.24 | gn00bie | is Valumzie shaking? |
14:34.11 | TheRedBaron | yes she is |
14:34.28 | gn00bie | yay yay |
14:34.43 | gn00bie | TheRedBaron: still up north? |
14:34.52 | TheRedBaron | gn00bie loves ~shake? especially when it happens to other people? |
14:35.03 | TheRedBaron | no, I'm back on my side of the mason dixon |
14:35.06 | TheRedBaron | ~weather KTLH |
14:35.15 | TheRedBaron | 46F :( |
14:35.56 | gn00bie | TheRedBaron: I love it when others have to ~shake, yes |
14:36.10 | gn00bie | 46 F and :(? I would kill for 46 F |
14:36.18 | gn00bie | we have gotten 10 feet of snow in 7 weeks :( |
14:36.59 | TheRedBaron | build a giant snowman! |
14:37.09 | gn00bie | I invite you to do it! |
14:37.44 | scott | http://uk.youtube.com/watch?v=BQALeeHWJyE |
14:38.02 | gn00bie | ~weather KSYR |
14:57.15 | *** join/##kierra ep (n=mdr@about/essy/guynextdoor/ep) |
15:14.27 | *** join/##kierra QuantumTim (n=tim@62.249.230.206) [NETSPLIT VICTIM] |
15:26.39 | scott | splity splity |
15:27.33 | TheRedBaron | that was more like a hiccup |
15:29.37 | scott | nod |
15:30.01 | scott | hugs arrador |
15:30.33 | gn00bie | ~weather KSYR |
15:41.58 | kierra | what is the maple syrup incident??? |
15:42.19 | scott | i even know about it |
15:43.17 | kierra | morning scott :) |
15:43.18 | gn00bie | ok time to shake |
15:43.27 | kierra | bye gn00biliscious |
15:43.39 | gn00bie | kierra: ask Valumzie about the maple syrup incident I am not sure I have authorization to disclose it |
15:43.43 | gn00bie | later |
15:43.49 | kierra | bye sweetness |
16:43.04 | TheRedBaron | gn00bie: what? no ~shake ?!? |
16:43.16 | TheRedBaron | catay: gn00bie needs help! |
16:44.49 | *** join/##kierra menotume (n=menotume@c-68-42-4-45.hsd1.pa.comcast.net) |
16:44.49 | *** mode/##kierra [+o menotume] by ChanServ |
16:45.13 | TheRedBaron | oh boy, there goes the channel |
16:45.31 | menotume | ahweeeee |
16:45.40 | menotume | what are YOU doing here ? |
16:45.45 | TheRedBaron | I got lost |
16:45.49 | TheRedBaron | and wandered in here |
16:45.58 | menotume | i see |
16:46.06 | TheRedBaron | which way is the exit ? |
16:46.26 | menotume | make a left at albuquerque |
16:47.07 | *** kick/##kierra [TheRedBaron!n=menotume@c-68-42-4-45.hsd1.pa.comcast.net] by menotume (menotume) |
16:47.15 | menotume | or there |
16:48.08 | *** join/##kierra TheRedBaron (n=kemhof@216.173.174.50) |
16:48.08 | *** mode/##kierra [+o TheRedBaron] by ChanServ |
16:48.16 | menotume | i see you found it |
16:48.21 | TheRedBaron | excellent |
16:48.33 | TheRedBaron | bookmarks the exit for easy location |
16:53.46 | TheRedBaron | ~spank brad |
16:53.47 | purl | ACTION bends brad over his knee and tatoos 'ibot' on brad's pasty white buttocks. |
16:53.52 | TheRedBaron | Birthday spanking :P |
16:55.33 | TheRedBaron | bah, bad mysql dump. |
17:20.41 | TheRedBaron | eh, how does one do a cross table sql query ? |
17:21.21 | kierra | :P |
17:21.39 | kierra | TheRedBaron: i lost the instructions for verifying users :( |
17:21.56 | TheRedBaron | what I"d like to do, is list all the records in table A, where "search clause here" and filter by "index/unique ID from table B column C" |
17:22.25 | TheRedBaron | where table A and table B share a column of ID's |
17:22.36 | scott | lets see your sql query |
17:22.56 | TheRedBaron | SELECT * |
17:22.56 | scott | oh i see |
17:22.57 | TheRedBaron | FROM |
17:22.57 | TheRedBaron | ss_subscribers_data |
17:22.57 | TheRedBaron | WHERE |
17:22.57 | TheRedBaron | ss_subscribers_data.fieldid = '82' |
17:22.57 | TheRedBaron | and |
17:22.58 | TheRedBaron | ss_list_subscribers.listid = '22' |
17:25.47 | kierra | ~ice menotume |
17:25.49 | purl | ACTION sneaks up behind menotume and dumps an entire bucket of ice on top of them |
17:26.04 | TheRedBaron | can i do multiple FROM statements ? |
17:26.30 | menotume | you need another where |
17:26.42 | menotume | or get VERY long qry :P |
17:27.32 | TheRedBaron | yea, the long query is what i'm looking to avoid |
17:31.01 | kierra | feels ignored :( |
17:32.22 | TheRedBaron | hrm, I think i need a join statment. |
17:38.24 | TheRedBaron | hrm, I think i crashed my poor little dev server :( |
17:40.58 | kierra | comes from ignoring your mother |
17:41.22 | TheRedBaron | I'm not ignoring you ! |
17:41.34 | menotume | ok, i'm back |
17:41.37 | kierra | menotume ping |
17:41.42 | menotume | just WHAT are you trying to do ? :P |
17:41.48 | menotume | nkierra pong |
17:41.52 | TheRedBaron | menotume: am I supposed to have a clue ? |
17:41.57 | kierra | meno, check my brother's comment on my fb status....you will appreciate it |
17:42.44 | menotume | TheRedBaron, most likely you need another 'AND' in the where |
17:42.53 | menotume | inner join (i think) |
17:43.15 | menotume | what fields link the two tables together ? an id of some sort ? |
17:43.25 | TheRedBaron | hrm.... |
17:43.27 | TheRedBaron | yes |
17:43.33 | menotume | hehe |
17:44.01 | menotume | AND ss_subscribers_data.id = ss_list_subscribers.id |
17:44.06 | TheRedBaron | but table A lists the ID more then once |
17:44.18 | menotume | there should be a relation |
17:44.25 | TheRedBaron | there is |
17:44.34 | TheRedBaron | i think. |
17:44.38 | TheRedBaron | :P |
17:44.44 | TheRedBaron | am I helping yet? |
17:44.53 | menotume | does list_subscribers have an auto_increment field ? |
17:44.58 | menotume | oh ya, lots of help |
17:45.31 | menotume | yay Steelers ! |
17:45.37 | TheRedBaron | let me try to explain. |
17:45.42 | TheRedBaron | (go steelers!) |
17:46.59 | menotume | don't explain, just answer the question :P |
17:48.00 | TheRedBaron | We have suscriber ID's. This is unique identifier. Its auto-increment |
17:48.19 | TheRedBaron | the subscribers are grouped by lists. each list as an id (again, auto increment) |
17:48.20 | menotume | yay |
17:48.34 | menotume | yes |
17:48.38 | TheRedBaron | then there is the misc information you can assign to a subscriberid |
17:48.51 | menotume | but, somewhere in the list table, there should be a reference to the subzscriber's id |
17:48.51 | TheRedBaron | this is done via another table, that lists the information ID, and the subscriberID |
17:48.56 | TheRedBaron | there is |
17:49.02 | menotume | ahhh |
17:49.13 | TheRedBaron | to table A has, SubscriberID, FIeldID, Data |
17:49.26 | TheRedBaron | table B has Subscriber ID, List ID |
17:49.31 | menotume | table C has listid subid |
17:49.36 | menotume | ohhh hehe |
17:49.38 | TheRedBaron | no list C |
17:49.48 | menotume | errr |
17:50.04 | TheRedBaron | I want all the sbuscribers, from table A, with fieldID "XYZ" that belong to listID "ABC" |
17:50.24 | TheRedBaron | ListID being in Table B |
17:50.33 | TheRedBaron | please note, tableB has no fieldID column :) |
17:50.59 | TheRedBaron | menotume: thats exactly where I am at this moment |
17:51.01 | TheRedBaron | errrr |
17:51.03 | TheRedBaron | :) |
17:51.05 | menotume | select * from tableA, listID from tableB where tableB.subscriberid = tableA.subscriberID |
17:51.34 | menotume | then, have additional AND in the WERE to filter what you need |
17:52.22 | menotume | you got to have the where 'tableB.subscriberid = tableA.subscriberID' in addition to what you want to filter |
17:52.32 | menotume | or, you'll get millions of resutls :) |
17:52.51 | TheRedBaron | yea, thats what crashed my first query :) |
17:53.00 | menotume | hehe |
17:53.21 | menotume | so, there IS another table, list Info, i guss, but you don't really need it in this case |
17:53.37 | menotume | so ... |
17:54.34 | menotume | SELECT * from tableA WHERE tableB.listID=22 AND tableB.subscriberid = tableA.subscriberID AND tableA.fieldID=82 |
17:54.48 | menotume | bye kierra :) |
17:55.14 | kierra_away | dont smile when you type that!!!!! |
17:57.06 | menotume | TheRedBaron, the "tableB.subscriberid = tableA.subscriberID" is a join |
17:57.48 | TheRedBaron | but I have to specify that right ? |
17:58.03 | menotume | no, it will automatically guess it for you |
17:58.08 | TheRedBaron | because i'm getting: "unknown column in where clause" |
17:58.21 | menotume | well, i don't know the actual col names :P |
17:58.33 | TheRedBaron | yea but I do, and I'm using the correct ones :P |
17:58.34 | menotume | YES, you have to specify it ! :D |
17:59.17 | menotume | can you show me the actual table defs ? |
17:59.25 | TheRedBaron | defs ? |
17:59.32 | TheRedBaron | use the queens english :P |
17:59.37 | menotume | cut and paste from PMA or something |
17:59.41 | menotume | table structure |
17:59.46 | menotume | column names :P |
18:02.36 | menotume | TheRedBaron, PhpMyAdmin / export |
18:02.38 | TheRedBaron | ooh, i think i got it |
18:02.49 | menotume | select the 2 tables, UNcheck data |
18:02.52 | menotume | ohhh |
18:03.58 | TheRedBaron | SELECT * FROM tableA, TableB where fieldID = 'xya' and tableA.subscriberID = tableB.subscriberID and tableB.subscriberID = 'abc' |
18:04.07 | *** part/##kierra kierra_away (n=jolie@c-98-230-5-184.hsd1.fl.comcast.net) |
18:04.11 | TheRedBaron | you need to specify both tables first |
18:04.22 | TheRedBaron | not just select from TableA where |
18:04.28 | TheRedBaron | you're selecting from both, duh. |
18:04.30 | menotume | why not ? |
18:04.42 | menotume | unless you are using table name aliases |
18:05.14 | menotume | SELECT just specifies what columns you actually want |
18:06.24 | menotume | ie: what get returned to you in the result set |
18:07.13 | menotume | if you don't want everything from table B, then don't select them, it's a waste of proc time |
18:09.58 | TheRedBaron | if I remove the table, then I get the 'unknown column' error |
18:10.36 | menotume | hmmm |
18:10.56 | menotume | using table aliases ? |
18:11.03 | TheRedBaron | nope |
18:11.10 | TheRedBaron | hrm. |
18:11.22 | menotume | show me the ACTUAL select part :P |
18:11.50 | TheRedBaron | SELECT |
18:11.51 | TheRedBaron | * |
18:11.51 | TheRedBaron | FROM |
18:11.51 | TheRedBaron | TableA, TableB |
18:12.14 | menotume | bah |
18:12.17 | menotume | nice tabe names |
18:16.12 | ndim | TheRedBaron: Caution with those SQL queries. If you only do a lot of FROM a,b,c,... WHERE a.id = b.id AND b.id=c.id AND ... etc. the server might just create COUNT(a)*COUNT(b)*COUNT(c)*.... records before applying the WHERE part. The proper JOIN could disregard a lot of those combinations earlier on. |
18:18.37 | ndim | If tables a,b, and c contain a thousand rows each, that would mean the SQL would have to look at a billion records before deciding which to pass through the WHERE filter. |
18:19.25 | ndim | Wheras with a proper JOIN, it could disregard something like 999999000 combinations much earlier. |
18:19.50 | ndim | Bringing down workload, IO and RAM usage by a factor of about a million :) |
18:20.16 | TheRedBaron | yes. First I filtered on one table, before joining the tables |
18:21.31 | menotume | ndim <== correct |
18:21.50 | TheRedBaron | for best speed, the join should be the last statement correct? |
18:21.56 | menotume | doesn't matter |
18:22.18 | menotume | sql server SHOULD be smart enough |
18:24.58 | TheRedBaron | i think ndim confused me :( |
18:28.02 | ndim | Good. Then my day's work is done. |
18:28.47 | TheRedBaron | work? thats not work |
18:28.55 | TheRedBaron | I confuse easily enough :P |
18:29.21 | ndim | :) |
18:31.21 | ndim | TheRedBaron: http://www.wellho.net/mouth/158_MySQL-LEFT-JOIN-and-RIGHT-JOIN-INNER-JOIN-and-OUTER-JOIN.html (quick Google result) appears to have the correct examples on how to convert the billion row query into a thousand row query. |
18:36.37 | menotume | what about the 'UNDER' and "MIDDLE' joins ? |
18:36.54 | menotume | just to add to the confusion :P |
18:38.22 | TheRedBaron | thanks :P |
18:39.40 | menotume | np, always glad to help |
18:42.19 | menotume | my favorite is the UPPER-LEFT-OVER join |
18:43.11 | menotume | followed closely by the INSIDE-OUT joins |
18:43.24 | menotume | always a lot of fun |
18:44.28 | TheRedBaron | ~be nice to menotume |
18:44.42 | purl | ACTION pats menotume on the back and slips menotume a $50 to shut up |
19:12.35 | *** join/##kierra menotume (n=menotume@c-68-42-4-45.hsd1.pa.comcast.net) |
19:12.35 | *** mode/##kierra [+o menotume] by ChanServ |
19:34.35 | *** join/##kierra Pimpi (n=frank@gondolin.pimpi.org) |
19:34.35 | *** mode/##kierra [+o Pimpi] by ChanServ |
20:35.01 | TheRedBaron | hrm |
20:39.58 | *** join/##kierra menotume (n=menotume@c-68-42-4-45.hsd1.pa.comcast.net) |
20:39.58 | *** mode/##kierra [+o menotume] by ChanServ |
20:41.34 | scott | hrm |
20:52.41 | brlcad | makes Valumzie some hot cocoa and gets a pillow so she can retire to her quiet room in comfort |
20:54.03 | scott | awaits in the "quiet" room |
20:57.19 | TheRedBaron | kicks scott out of the quiet room |
21:36.47 | *** join/##kierra LongDon (n=LongDon@host-091-097-176-201.ewe-ip-backbone.de) |
21:36.52 | *** part/##kierra LongDon (n=LongDon@host-091-097-176-201.ewe-ip-backbone.de) |
21:37.45 | *** part/##kierra TheRedBaron (n=kemhof@216.173.174.50) |
21:50.45 | *** join/##kierra Upsetter (n=Ups@dslb-088-072-210-208.pools.arcor-ip.net) |
22:23.12 | *** join/##kierra kierra_away (n=jolie@c-98-230-5-184.hsd1.fl.comcast.net) |
22:23.13 | *** mode/##kierra [+o kierra_away] by ChanServ |
22:23.26 | *** topic/##kierra by kierra_away -> Welcome: || ñ || "There is nothing worse than aggressive stupidity." || âFaith is an oasis in the heart which can never be reached by the caravan of thinkingâ|| |
22:44.17 | kierra_away | ~lart menotume |
22:44.17 | purl | beats menotume over the head with a microkernel |
22:51.56 | Valumzie | ~brlcad++ |
22:54.32 | Valumzie | I cant believe kierra_away does not know about the marple syrup incident ! |
23:21.46 | ndim | notes it down to ask when he actually meets any of the concerned parties. |