IRC log for ##kierra on 20090130

00:36.07*** join/##kierra Valumzie (n=valumz@75.144.224.155)
00:36.07*** mode/##kierra [+o Valumzie] by ChanServ
01:00.49Valumzie~lart catay
01:00.49purlshoots catay in the head
01:44.15Birdiehow can poker be sooooooooooooooo unlucky on internet
01:44.20Birdiethis game is made for making me mad
02:59.52gn00bie20:01 <@Valumzie> ~lart catay
02:59.55gn00bie20:01  * purl shoots catay in the head
02:59.59gn00bie~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.40gn00biebusy mom
03:34.34kierrahey
03:34.47kierragn00bie: going to California on the 10th
03:35.09kierrai'm going to live dangerously there ;)
03:39.57gn00biekierra: oh you hardly live dangerously
03:40.03gn00bieI need to teach you some of that
03:40.18gn00biebut for now, bed time
03:40.37gn00biegoing to visit the eldest?
03:40.54gn00biebye bye
03:46.32kierrayes
03:46.45kierraoh but I have plans for CA ;)
03:55.59Valumziekierra: ping :)
12:06.20Valumzie~wake brlcad
12:06.42purlACTION throws a barrel-full of ice water on brlcad and shouts "GOOD MORNING!!!!"
12:06.43Valumzienobody wants to wake him :)
12:06.46Valumzieoh
12:06.51Valumzieslow slow purl!
12:10.30kierrahi Valumzie
12:10.42kierra~wake brlcad
12:10.42purlACTION throws a barrel-full of ice water on brlcad and shouts "GOOD MORNING!!!!"
12:10.48kierra~ice brlcad
12:10.48purlACTION sneaks up behind brlcad and dumps an entire bucket of ice on top of them
12:18.36ndim~coffee kierra
12:18.37purlACTION steals some of Pimpi_'s special coffee and gives it to kierra on a silver platter.
12:18.45ndim~coffee Valumzie
12:18.46purlACTION steals some of Winny's special coffee and gives it to Valumzie on a silver platter.
12:18.57ndim~coffee ndim
12:18.58purlACTION steals some of purl's special coffee and gives it to ndim on a silver platter.
12:19.22Valumziecoffee!!!
12:19.23kierraty ndim
12:19.29kierra~tea ndim
12:19.30purlACTION 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.34kierra~pinch Manu
12:19.34purlACTION scuttles after Manu, pinches him, and then scuttles away
12:41.00kierragn00bie: you're right.....I don't live dangerously.....never have except for a few brief episodes :)
12:42.07kierrasky diving comes to mind, mule rides down the Grand Canyon, Soaring, rappeling off the face of a mountain.....
12:42.40ndim...raising TRB
12:44.27Manu~kiss kierra
12:44.28purlACTION forces kierra to give TheRedBaron a big kiss on the ear
12:45.26kierrathat I can handle ;)
12:45.33kierraand trb won't mind
12:45.53kierralol, ndim!
13:23.01brlcadgrumbles and yawns
13:24.39Manuthrows a 5 1/4! floppy into brlcad's mouth
13:37.57*** join/##kierra Upsetter (n=Ups@i59F7F278.versanet.de)
13:40.03kierra~tickle brlcad
13:40.26purlACTION jumps on brlcad, yelling "TICKLE FIGHT!!!!"
13:40.26brlcadsqueals
13:58.19TheRedBaronraising trb ?
13:58.22TheRedBaron~lart ndim
13:58.22purlchops ndim in half with a free AOL CD
13:58.35TheRedBaronI was good boi and easy child compared to my older sisters :P
14:00.44kierraso true, TRB was my brown-eyed handsome man
14:17.13*** join/##kierra Upsetter (n=Ups@i59F7F278.versanet.de)
14:30.07scottgroans
14:30.39gn00bieI think since you were pretty experienced by the time trb came along, he seemed easy
14:30.52gn00biegoing by the maple syrup incident, he could have been a handful
14:31.15gn00biebut then again, maybe the maple syrup incident shows that he loves you a lot
14:31.24gn00bieis Valumzie shaking?
14:34.11TheRedBaronyes she is
14:34.28gn00bieyay yay
14:34.43gn00bieTheRedBaron: still up north?
14:34.52TheRedBarongn00bie loves ~shake? especially when it happens to other people?
14:35.03TheRedBaronno, I'm back on my side of the mason dixon
14:35.06TheRedBaron~weather KTLH
14:35.15TheRedBaron46F :(
14:35.56gn00bieTheRedBaron: I love it when others have to ~shake, yes
14:36.10gn00bie46 F and :(? I would kill for 46 F
14:36.18gn00biewe have gotten 10 feet of snow in 7 weeks :(
14:36.59TheRedBaronbuild a giant snowman!
14:37.09gn00bieI invite you to do it!
14:37.44scotthttp://uk.youtube.com/watch?v=BQALeeHWJyE
14:38.02gn00bie~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.39scottsplity splity
15:27.33TheRedBaronthat was more like a hiccup
15:29.37scottnod
15:30.01scotthugs arrador
15:30.33gn00bie~weather KSYR
15:41.58kierrawhat is the maple syrup incident???
15:42.19scotti even know about it
15:43.17kierramorning scott :)
15:43.18gn00bieok time to shake
15:43.27kierrabye gn00biliscious
15:43.39gn00biekierra: ask Valumzie about the maple syrup incident I am not sure I have authorization to disclose it
15:43.43gn00bielater
15:43.49kierrabye sweetness
16:43.04TheRedBarongn00bie: what? no ~shake ?!?
16:43.16TheRedBaroncatay: 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.13TheRedBaronoh boy, there goes the channel
16:45.31menotumeahweeeee
16:45.40menotumewhat are YOU doing here ?
16:45.45TheRedBaronI got lost
16:45.49TheRedBaronand wandered in here
16:45.58menotumei see
16:46.06TheRedBaronwhich way is the exit ?
16:46.26menotumemake 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.15menotumeor there
16:48.08*** join/##kierra TheRedBaron (n=kemhof@216.173.174.50)
16:48.08*** mode/##kierra [+o TheRedBaron] by ChanServ
16:48.16menotumei see you found it
16:48.21TheRedBaronexcellent
16:48.33TheRedBaronbookmarks the exit for easy location
16:53.46TheRedBaron~spank brad
16:53.47purlACTION bends brad over his knee and tatoos 'ibot' on brad's pasty white buttocks.
16:53.52TheRedBaronBirthday spanking :P
16:55.33TheRedBaronbah, bad mysql dump.
17:20.41TheRedBaroneh, how does one do a cross table sql query ?
17:21.21kierra:P
17:21.39kierraTheRedBaron: i lost the instructions for verifying users :(
17:21.56TheRedBaronwhat 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.25TheRedBaronwhere table A and table B share a column of ID's
17:22.36scottlets see your sql query
17:22.56TheRedBaronSELECT *
17:22.56scottoh i see
17:22.57TheRedBaronFROM
17:22.57TheRedBaronss_subscribers_data
17:22.57TheRedBaronWHERE
17:22.57TheRedBaronss_subscribers_data.fieldid =  '82'
17:22.57TheRedBaronand
17:22.58TheRedBaronss_list_subscribers.listid = '22'
17:25.47kierra~ice menotume
17:25.49purlACTION sneaks up behind menotume and dumps an entire bucket of ice on top of them
17:26.04TheRedBaroncan i do multiple FROM statements ?
17:26.30menotumeyou need another where
17:26.42menotumeor get  VERY long qry :P
17:27.32TheRedBaronyea, the long query is what i'm looking to avoid
17:31.01kierrafeels ignored :(
17:32.22TheRedBaronhrm, I think i need a join statment.
17:38.24TheRedBaronhrm, I think i crashed my poor little dev server :(
17:40.58kierracomes from ignoring your mother
17:41.22TheRedBaronI'm not ignoring you !
17:41.34menotumeok, i'm back
17:41.37kierramenotume ping
17:41.42menotumejust WHAT are you trying to do ? :P
17:41.48menotumenkierra pong
17:41.52TheRedBaronmenotume: am I supposed to have a clue ?
17:41.57kierrameno, check my brother's comment on my fb status....you will appreciate it
17:42.44menotumeTheRedBaron, most likely you need another 'AND' in the where
17:42.53menotumeinner join (i think)
17:43.15menotumewhat fields link the two tables together ? an id of some sort ?
17:43.25TheRedBaronhrm....
17:43.27TheRedBaronyes
17:43.33menotumehehe
17:44.01menotumeAND ss_subscribers_data.id =  ss_list_subscribers.id
17:44.06TheRedBaronbut table A lists the ID more then once
17:44.18menotumethere should be a relation
17:44.25TheRedBaronthere is
17:44.34TheRedBaroni think.
17:44.38TheRedBaron:P
17:44.44TheRedBaronam I helping yet?
17:44.53menotumedoes list_subscribers have an auto_increment field ?
17:44.58menotumeoh ya, lots of help
17:45.31menotumeyay Steelers !
17:45.37TheRedBaronlet me try to explain.
17:45.42TheRedBaron(go steelers!)
17:46.59menotumedon't explain, just answer the question :P
17:48.00TheRedBaronWe have suscriber ID's.  This is unique identifier. Its auto-increment
17:48.19TheRedBaronthe subscribers are grouped by lists. each list as an id (again, auto increment)
17:48.20menotumeyay
17:48.34menotumeyes
17:48.38TheRedBaronthen there is the misc information you can assign to a subscriberid
17:48.51menotumebut, somewhere in the list table, there should be a reference to the subzscriber's id
17:48.51TheRedBaronthis is done via another table,  that lists the information ID, and the subscriberID
17:48.56TheRedBaronthere is
17:49.02menotumeahhh
17:49.13TheRedBaronto table A has, SubscriberID, FIeldID, Data
17:49.26TheRedBarontable B has Subscriber ID, List ID
17:49.31menotumetable C has listid subid
17:49.36menotumeohhh hehe
17:49.38TheRedBaronno list C
17:49.48menotumeerrr
17:50.04TheRedBaronI want all the sbuscribers, from table A, with fieldID "XYZ" that belong to listID "ABC"
17:50.24TheRedBaronListID being in Table B
17:50.33TheRedBaronplease note, tableB has no fieldID column :)
17:50.59TheRedBaronmenotume: thats exactly where I am at this moment
17:51.01TheRedBaronerrrr
17:51.03TheRedBaron:)
17:51.05menotumeselect * from tableA, listID from tableB  where tableB.subscriberid = tableA.subscriberID
17:51.34menotumethen, have additional AND in the WERE to filter what you need
17:52.22menotumeyou got to have the  where 'tableB.subscriberid = tableA.subscriberID' in addition to what you want to filter
17:52.32menotumeor, you'll get millions of resutls :)
17:52.51TheRedBaronyea, thats what crashed my first query :)
17:53.00menotumehehe
17:53.21menotumeso, there IS another table, list Info, i guss, but you don't really need it in this case
17:53.37menotumeso ...
17:54.34menotumeSELECT * from tableA WHERE tableB.listID=22 AND  tableB.subscriberid = tableA.subscriberID AND tableA.fieldID=82
17:54.48menotumebye kierra :)
17:55.14kierra_awaydont smile when you type that!!!!!
17:57.06menotumeTheRedBaron, the "tableB.subscriberid = tableA.subscriberID" is a join
17:57.48TheRedBaronbut I have to specify that right ?
17:58.03menotumeno, it will automatically guess it for you
17:58.08TheRedBaronbecause i'm getting: "unknown column in where clause"
17:58.21menotumewell, i don't know the actual col names :P
17:58.33TheRedBaronyea but I do, and I'm using the correct ones :P
17:58.34menotumeYES, you have to specify it !  :D
17:59.17menotumecan you show me the actual table defs ?
17:59.25TheRedBarondefs ?
17:59.32TheRedBaronuse the queens english :P
17:59.37menotumecut and paste from PMA or something
17:59.41menotumetable structure
17:59.46menotumecolumn names :P
18:02.36menotumeTheRedBaron, PhpMyAdmin / export
18:02.38TheRedBaronooh, i think i got it
18:02.49menotumeselect the 2 tables, UNcheck data
18:02.52menotumeohhh
18:03.58TheRedBaronSELECT * 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.11TheRedBaronyou need to specify both tables first
18:04.22TheRedBaronnot just select from TableA where
18:04.28TheRedBaronyou're selecting from both, duh.
18:04.30menotumewhy not ?
18:04.42menotumeunless you are using table name aliases
18:05.14menotumeSELECT just specifies what columns you actually want
18:06.24menotumeie: what get returned to you in the result set
18:07.13menotumeif you don't want everything from table B, then don't select them, it's a waste of proc time
18:09.58TheRedBaronif I remove the table, then I get the 'unknown column' error
18:10.36menotumehmmm
18:10.56menotumeusing table aliases ?
18:11.03TheRedBaronnope
18:11.10TheRedBaronhrm.
18:11.22menotumeshow me the ACTUAL select part :P
18:11.50TheRedBaronSELECT
18:11.51TheRedBaron*
18:11.51TheRedBaronFROM
18:11.51TheRedBaronTableA, TableB
18:12.14menotumebah
18:12.17menotumenice tabe names
18:16.12ndimTheRedBaron: 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.37ndimIf 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.25ndimWheras with a proper JOIN, it could disregard something like 999999000 combinations much earlier.
18:19.50ndimBringing down workload, IO and RAM usage by a factor of about a million :)
18:20.16TheRedBaronyes.  First I filtered on one table, before joining the tables
18:21.31menotumendim <== correct
18:21.50TheRedBaronfor best speed, the join should be the last statement correct?
18:21.56menotumedoesn't matter
18:22.18menotumesql server SHOULD be smart enough
18:24.58TheRedBaroni think ndim confused me :(
18:28.02ndimGood. Then my day's work is done.
18:28.47TheRedBaronwork? thats not work
18:28.55TheRedBaronI confuse easily enough :P
18:29.21ndim:)
18:31.21ndimTheRedBaron: 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.37menotumewhat about the 'UNDER' and "MIDDLE' joins ?
18:36.54menotumejust to add to the confusion :P
18:38.22TheRedBaronthanks :P
18:39.40menotumenp, always glad to help
18:42.19menotumemy favorite is the UPPER-LEFT-OVER join
18:43.11menotumefollowed closely by the INSIDE-OUT joins
18:43.24menotumealways a lot of fun
18:44.28TheRedBaron~be nice to menotume
18:44.42purlACTION 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.01TheRedBaronhrm
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.34scotthrm
20:52.41brlcadmakes Valumzie some hot cocoa and gets a pillow so she can retire to her quiet room in comfort
20:54.03scottawaits in the "quiet" room
20:57.19TheRedBaronkicks 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.17kierra_away~lart menotume
22:44.17purlbeats menotume over the head with a microkernel
22:51.56Valumzie~brlcad++
22:54.32ValumzieI cant believe kierra_away does not know about the marple syrup incident !
23:21.46ndimnotes it down to ask when he actually meets any of the concerned parties.

Generated by irclog2html.pl Modified by Tim Riker to work with infobot.