Profile

Cover photo
Jeff Peak
Works at Level9 Studios
Attended Missouri Western State University
Lives in Saint Joseph, MO
41 followers|16,554 views
AboutPostsPhotosYouTubeReviews

Stream

 
Ahh.. Valentine's Day... another holiday I don't support or celebrate. :-)
1
Add a comment...

Jeff Peak

Ask the Experts  - 
 
Could somebody help me with this? If so I'd be eternally greatful.

I have a query that needs to return a value, even if it's 0 for every day between a set of timestamps. The problem with the way that I have written my query, is that COUNT() doesn't return anything when a result matching the rest of the query does not exist. I've heard that IFNULL(COUNT(), 0) would not work either because COUNT() doesn't return NULL.

Here is my query.

SELECT DAY( FROM_UNIXTIME( timestamp ) ) AS day,
MONTH( FROM_UNIXTIME( timestamp ) ) AS month,
YEAR( FROM_UNIXTIME( timestamp ) ) AS year,       
COUNT( * ) AS count
FROM diffnetwork.comm_views
WHERE timestamp
BETWEEN '$fromDateUnix' AND '$toDateUnix'
GROUP BY day, month , year
ORDER BY year, month, day

Does this make sense?
1
Daniel M's profile photoJastor M's profile photoJeff Peak's profile photo
9 comments
 
The query runs without errors?
Add a comment...

Jeff Peak

Shared publicly  - 
 
Lol
 
I'M A BUSSSS!
1
Add a comment...

Jeff Peak

Shared publicly  - 
1
Add a comment...

Jeff Peak

Introductions  - 
 
Hello everyone. I've been a member of this community for a couple of years now but haven't spent much time on Google+ until recently. My New Year's resolution to myself was to use Facebook less and less; I found it was rotting my mind and making me manage time poorly.

I joined this community in hopes of finding people of like-minds and who share interests similar to mine. So many of the conversations in this community have been eye opening and enlightening. It's been a pleasure to read through past posts and get caught up. I'm excited about this new year and excited about finally contributing to this G+ community.
4
Malaysha Castillo's profile photoKrishnamurthy Kannan's profile photoJeff Peak's profile photoAdam Black's profile photo
4 comments
 
It's too easy to get caught up in Facebook, i look forward to more of your posts
Add a comment...
Have him in circles
41 people
Kerri Lynn Barton's profile photo
Steve Marks's profile photo
heather giesen's profile photo
Edward Vasques's profile photo
Mike Sturdee's profile photo
Austin Marks's profile photo
Deirdre Alders's profile photo

Jeff Peak

Shared publicly  - 
 
I love how the cat lands on it's back and the dogs look over the edge of the couch.
 
SoO Cute  O/
#Cat #Jump #Funny  
1
Add a comment...

Jeff Peak

commented on a video on YouTube.
Shared publicly  - 
 
It's nice to see that you're making videos regularly again. :-)
1
Add a comment...

Jeff Peak

Shared publicly  - 
 
Two glasses of wine and some internet entertainment and I'm ready for bed. Goodnight my circler's, I can hear ice pellets beginning to hit the window.
1
Add a comment...

Jeff Peak

Discussion - The reason for seeking  - 
 
Hi everyone, my name is Jeff. A friend of mine who is also a medium discovered my abilities about 15 months ago. I've been progressing ever sense and am excited for what 2014 has to bring.
2
Mark Sanders's profile photoJeff Peak's profile photo
6 comments
 
Yes guides are important, as is the "focus" and clearing out the clutter of your own mind.
The clutter is the hardest thing to remember.
Do not try to interpret what spirit is telling you. Be and open channel and give what you get without putting your mind in it.

Always remember to tell your guides to bring you the highest and the best. Never let negativity through. That is putting your mind in it. Spirit will never let anyone leave a reading with a heavy heart.
Add a comment...

Jeff Peak

Cognitive & General PoM Discussion  - 
 
I starred at myself in the mirror for a while last night. Not in an egocentric or vain way, but it a spiritual way. Wondering how I ended up in this body. I star at myself like that from time to time, letting my mind wander and drift through layers of consciousness. Has anybody else ever meditated in this way?
10
TabletopJoe33's profile photoPeter Downer's profile photoJeff Peak's profile photoPaul Hughes's profile photo
7 comments
 
+Paul Hughes I agree so much Paul. It makes me think of a quote "I am not this face or this body, but the soul that lives within.". Or something like that. It's incredibly true and sad how much we visual creatures judge the book before we get to know it.
Add a comment...
People
Have him in circles
41 people
Kerri Lynn Barton's profile photo
Steve Marks's profile photo
heather giesen's profile photo
Edward Vasques's profile photo
Mike Sturdee's profile photo
Austin Marks's profile photo
Deirdre Alders's profile photo
Work
Occupation
I'm an Art Director at a company I helped start, and am the sole member of Last Meltdown. Right now I'm working on a few projects, one with Generationally Relevant Media, Inc. called Downtowndifferent, and another one of my own called Swap Shop Nation, I'm pretty stoked about it.
Skills
Oh wow, umm... I type really fast and accurate. I'm not sure why I'm about to list this as a skill but I feel it's come to that, I know English. Like, I know how to write it correctly; grammar is a big thing. I'm a web programmer/designer (I'm better at design and that's also what I prefer to do). I'm an identity designer, logos, portfolios, books...that sort of stuff. I write music, my band's name is Last Meltdown. There's so much more to list here, if you're interested in having me do something for you or you're just curious, add me to a circle or message me. I don't bite, mainly because people don't really take hygiene seriously anymore, and I just don't like biting people.
Employment
  • Level9 Studios
    Art Director, 2009 - present
    Level9 started after I began work for a local business man. I was creating DVD sets for a monthly subscription service; it went nowhere. We started Level9 together and have been building local business's identities ever since.
  • Plasma Biological
    Phlebotimist, 2009 - 2009
    I stuck sharp things into people and made them bleed into a machine. Yeah, it was gross. No, I never killed anyone.
  • Bredeaux Pizza
    Driver, 2009 - 2009
    I hated delivering pizza and while I was working here my car's engine exploded.
  • A couple server jobs and Best Buy
    2006 - 2007
  • Dominos Pizza
    Delivery Driver, 2012 - 2012
    I forgot how much I hated delivering pizzas, so I thought I'd try again. Turns out, I still hated delivering pizza.
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Saint Joseph, MO
Previously
Gower, MO - Kansas City, MO - Riverside, MO
Links
YouTube
Contributor to
Story
Tagline
Quirky, quick and I keep my tongue firmly planted in my cheek.
Introduction
I'm Jeff Peak from St. Joseph, MO. I went to high school at Central, started college at MWSU. I like grapes, but I like wine better.
Bragging rights
Pretty good singer, piano player and a big computer nerd.
Education
  • Missouri Western State University
    Liberal Arts, 2006 - 2007
Basic Information
Gender
Male
Looking for
Friends
Awesome websites, very creative and beautiful result. Great balance between form and function.
Public - 2 months ago
reviewed 2 months ago
A pretty neat place, awesome work too, if I do say so myself.
Public - 2 months ago
reviewed 2 months ago
3 reviews
Map
Map
Map
Awesome coffee! I don't really go anywhere else anymore.
Public - 2 months ago
reviewed 2 months ago