So I came across a scenario where I need to know the top developers of applications based on how many times their software has been downloaded.
There are 3 tables involved here.
The developers table
the orders_software table
the orders_software_downloads table
The whole goal is get this information with 1 Sql query.The basic relationships are as follows:
there are many developers in the developer table
there are many softwares to 1 order in the orders_software table
there are many downloads to 1 software to 1 order in the orders_software_downloads table.
So we select the developer name from the developer table, and the download count from the orders_software_downloads table. Left join to get all the tables together. Exclude counts that are null. Then group the results by the owner of each software. Which is a row of the software table.
This will be a great case to use SUM
we can modify the download count to sum(download_count) and as long as we have that group by, it will sum up the group.
So sql will look like this:
SELECT developer.name, SUM(orders_software_download.download_count) as sum
LEFT JOIN orders_software on software.id = orders_software.software_id
LEFT JOIN orders_products_download on orders_products.orders_software_id = orders_products_download.id
WHERE orders_software_download.download_count IS NOT NULLGROUP BY software.software_owner
ORDER BY sum DESC
And then from this the result will give you an array of the top developers where you can know who the developer is an how many times in total their software was downloaded
Updated 05-13-2010 at 10:01 AM by optikalefx
What is it?
The Habey BIS-6620 is a SFF PC powered by an Intel Atom Z510 processor.
The Verdict: The Habey USA BIS-6620 is an absolute marvel of a design. The manufacturer has created fully functioning PC cable of running the latest software in a form factor which can fit in the palm of your hand. Quite frankly, the BIS-6620 could be used at home, in the car, or as an embedded platform. Unfortunately it’s small size and power-sipping capabilities mean this PC would probably be a lot more comfortable with Windows Embedded than with Windows 7.
The BIS-6620 is available now at the MP3Car store
What's in the box:
The BIS-6620 comes with the PC, a PS/2 Keyboard/Mouse splitter cable, 12v power brick, and driver and utilities installation disc. Also included are four long screws for VESA mount support.
Right out of the box the Habey USA BIS-6620 has a certain “wow” factor. Measuring at only 4.5 x 4.5 x 1.5”, it immediately has the potential to be everyone’s dream car PC. The BIS-6620 is also built with a completely fan-less design, making it silent in operation. It’s powered by a single-core Intel Z510 processor clocked at 1 GHz and is built to use up to 2 GHz of SODIMM (laptop) ram. Despite its size, the BIS-6620 is surprisingly flexible when it comes to drive storage. Internally, the 6620 accepts a 1.8” SATA hard drive. However, thanks to a bios setting which allows removable drives to be emulated as physical disks, you have the option to install and run your primary operating system from a compact flash card. There is also an SD card slot on the front of the PC just adjacent to the CF slot.
The BIS-6620 is powered by a simple 12v power brick, further enhancing its potential to be used as a car PC. The computer is a true power-sipper, and can be run with less than 10w and 2amps. It’s hard to imagine that a PC that’s fully capable of running windows 7 can do so with less power than your average car speaker requires to play sound.
Upon installing the components required to make the BIS-6620 power up, I connected a USB DVD-Rom and installed a fresh copy of windows 7 32-bit. Once installation was complete I was brought into the OS. I quickly noticed that the BIS-6620 doesn’t support Aero, or the transparent glass effects on a standard non-Aero windows 7 installation. Moving through windows dialogs seemed to occur with ample speed, but waiting for basic programs like Wndows Media Payer and Centrafuse 3 became quite the chore even at their most basic program settings. It’s clear that while there are many pros to the BIS-6620, the obvious setback is the 1 GHz processor. That said; the BIS-6620 handled MP3 playback with ease. It will even play 1080p videos with little to no skipping and video sync issues thanks to hardware decoding.
Video is provided only via VGA or S-Video connections. There is no support for DVI or HDMI and based on the form factor of the BIS-6620 (Habey has different models that do have DVI & HDMI output in the same form factor), you probably won’t be adding a video card capable of such. There is a single audio output jack on the front, and a microphone input just next to that. The lack of a line-in jack means your radio and other input devices better have “audio over USB” support. There is a single LAN port, a total of 4 USB ports, and a single PS/2 which can provide both keyboard and mouse support with the enclosed splitter cable.
The case of the BIS-6620 is a marvel in itself. The finned design on the top serves as a fully functioning heat-sink for the Intel processor. Because of this design the casing does run hotter than your average computer case, but never to the point where the case was simply too hot to touch. On the edges of the case are four holes which allow the BIS-6620 to be mounted on a VESA mount. All this allows for the BIS-6620 to truly be an ultra-compact, silent, and unseen fully functioning PC.
• Small design but capable fully functioning PC
• Flexible storage options
• Performance and reliability of the Intel Atom product
• Energy efficient design (
Updated 05-26-2010 at 11:33 AM by Jensen2000
What is it?
Destinator 9 is Intrinsync's entry into the rather crowded iPhone GPS space. The app comes with real-time traffic, integrated maps, POIs, Weather, and Google search integrated.
Destinator has made it's way onto the first page of my iPhone. The feature rich GPS app has replaced the multiple GPS apps if for no other reason than the superior graphical interface. Having tested the TomTom, Navigon, and Waze, Destinator seems to have the most updated maps, most features and the ability to route to contacts or google results is a huge plus. The ability to download a trial before purchase will explain why to spend the extra money on this app versus the others. The app is very large(updates are normally 1.6 GB+) and must be downloaded over wifi and tends to be slow to open. Once running it does not drain the battery horribly like the TomTom and if you close it the destination is retained so youc an conserve some battery on long drives.Navigator 9 is available now at ITunes StoreScreenshots
Destinator 9 uses voice guided turn-by-turn directions with Navteq Maps with a graphical display in either 2D or 3D. Traffic conditions, points-of-interest information, and weather information are included when available. Multi-Stop trips can be imported or destinations can be set by tapping on a location on a map, selecting addresses from contacts, or using the traditional address import methods. To augment the address imports you can select by town, street, intersection, or Latitude/Longitude. The app is available as a free trial download with a splash screen that can be toggled off to try the app initially. Once you purchase the app, you get additional features including speed limit notification and warnings. Upon starting the app, you are able to control your ipod collection from within the program. You can also check the real-time traffic and weather from the bottom menu. During navigation the display will change throughout your trip to show the overhead signs on the highway, as well as lane directions to guide you both visually and vocally. You can view the directions either vertically or horizontally and the display changes automatically with orientation of the iphone. The app start up is very slow as I think it loads all the maps, however once it starts the gps finds your location very quickly. Much better than on the competing apps. The maps have been up to date and the app seems to be getting updated about once every couple weeks. The app is also available for Windows Mobile and Android
Graphical Interface is easy to use3D view shows upcoming street signsBackground shows current weatherGoogle Search integrationReal-Time TrafficMaintains DestinationUp-to-Date MapsIpod Controls IntegratedSpeed Limit Warnings
Slow to openVery Large DownloadDoes not have the standard "Take me Home" option$69.99 Price
Updated 05-03-2010 at 09:12 AM by Heather
A proud mp3Car customer shows us their use case for the mighty Xenarc 702TSVs they purchased from the mp3Car store. Eventually being used in a tactical Humvee for desert military operations, these Xenarc monitors are being used as bright displays for a prototype vehicle here in the U.S.
Updated 04-30-2010 at 11:18 AM by Jensen2000
What is it?
Jukebox Jockey is a touch-friendly media player and karaoke front end.
The Verdict:The Jukebox Jockey software has been a joy to review. Its very feature-rich and some new innovations not yet seen in the car PC arena. The software is as simple or as flexible as you choose for it to be and never gets in a users way thanks to a clever GUI. Any mobile PC user looking for well-supported program to manage most of their media on the go should look first at Jukebox Jockey.
Jukebox Jockey is available now at http://www.jukeboxjockey.com/
Jukebox Jockey is a windows application built to be a simple yet fully functioning media player. It’s different from the multitude of existing media player software in that Jukebox Jockey is built from the ground up to be touchscreen-friendly. This obviously has plenty of benefits on a small screened car PC, but Jukebox Jockey also shines in a party environment. Most of my review will focus on Jukebox Jockeys aspirations as a simple media car PC front end, but I will say the app is simply the best application out there for controlling music, video, and karaoke playback for a group of people.
A person looking for a simple and powerful media player for their 7-inch touchscreen should seriously consider Jukebox Jockey. While it lacks the expansion that most other commercially available mobile PC front ends offer, it does what it’s meant to do with absolute ease. The entire interface is skinnable. The buttons are large enough to be pressed on your standard car touchscreen and for the most part they are text-labeled when they need to be. This means you know what the button does before you press it. While the application will run at 800x600, the developer is currently working on skinning options for resolutions that low. There is no “home” screen which houses all of the media options, rather a simple “Change Mode” button which brings up a small menu which allows selection.
From there, it’s easy to find the media you’re looking for. The top portion of the application window allows you to select how you wish to find your media. Browse-by-album-art is present, and will perhaps be the preferred method. The ability to sort by decades is a new and welcomed feature when comparing to other vehicle front ends. There is also a pretty handy instant search function which searches for results each time a key on the on-screen QWERTY keyboard is pressed. All media is scanned into Jukebox Jockey via the options button on the top of the application. Scanning media is relatively quick, but it does have to be done each time new music/videos are added.
Playlists are housed on the right side of the application window. Jukebox Jockey has a different take on playlist handling. By default, the playlist shrinks as songs are played. In Jukebox Jockey the playlist is more of a request list, and this makes sense considering the software doubles as DJ software. Overall the music and video players rivals most other media players on the market.
What you won’t find in most media players and especially on car PCs is a karaoke mode. This mode was by far the most fun to use in a party environment, but I did have passengers in the car playing as I drove down the road. Jukebox Jockey is very easy for passengers and newcomers to control. There is even a specific party mode which administrators can enable to lock down settings and controls that secondary users would not need access too.
• Built to be touchscreen friendly
• Built-in media library which organizes/searches media in a multitude of ways
• Fully Skinnable• 2nd Screen support for media information and karaoke lyrics
• Simple installation on any PC with windows XP or newer
• Small footprint and doesn’t use too much memory
• Easy to use for beginners, a huge list of options for experienced users
• Bass audio engine for high audio fidelity
• Actively supported
• Video player did not support h264 encoded videos
• No current skin for 800x480
The Jukebox Jockey software has been a joy to review. Its very feature-rich and some new innovations not yet seen in the car PC arena. The software is as simple or as flexible as you choose for it to be and never gets in a users way thanks to a clever GUI. Any mobile PC user looking for well-supported program to manage most of their media on the go should look first at Jukebox Jockey.
Jukebox Jockey is available now at http://www.jukeboxjockey.com/
Updated 04-27-2010 at 03:11 PM by Sonicxtacy02