SQL queries (MySQL & PHP)
file TABLE file_id - unique file_url file_service file_thumbnailurl file_width file_height file_userid – person who add this file file_datetime – datetime file added, using mysql timestamp, like this “2012-02-02 13:11:24” info TABLE info_file_id – unique, refer to file_id in file TABLE info_title – varchar, title of the file... info_description – text, description of the file... info_category1 – one value, for example “3” info_category2 – one value, for example “1” info_tag – tag list, it looks like “michael jackson, rock, favorite star” info_userid – person who add this info_datetime – info added, using mysql timestamp, like this “2012-02-02 13:11:24” info_safemode – 1 is on, 0 is off . counter TABLE counter_file_id – unique, refer to file_id in file TABLE counter_view – number of views counter_comment – number of comments counter_like – number of likes counter_share - number of shares counter_point – a total point for sum all the value(for example 1 view = 1 point, 1 comment = 20 points, 1 like = 10 points, 1 share = 20 points) We need YOU to provide 13 SQL queries - all result must be unique (file_id) - able to apply paging (currently i use LIMIT offset, row-per-page) - all datetime base on server, and refer to the info TABLE, not file TABLE. 1.get the last 30 days records sort by counter_point desc, that means the highest point come first 2.get the last 30 days records with specific category sort by counter_point desc, that means the highest point come first, the category match either category 1 & category 2. 3.randomly get any 4 records 4.get the latest 4 records with specific category sort by latest come first 5.get all records sort by counter_point desc. 6.get records with specific category sort by counter_point desc. 7.get all the latest records sort by latest come first 8.get the latest records with specific category sort by latest come first 9.get all the records with specific keyword(the search thru – title, description, tag) sort by latest come first 10.get all the records with specific keyword(the search thru – title, description, tag) sort by counter_point desc, highest point come first 11.get all the records with specific tag, sort by latest come first 12.get all the records with specific tag, sort by highest point come first 13.get all the result similar to one of them. for example this record, fileid= eg. 123, category1=”music”, category2=”mtv” & tag=”michael jackson, album, tribute”. So, we need to get the revelent records that similar to this. (if it is slow&heavy, we will do/update this records via “cronjob” every hour that store the revelent list in another table)
Latest related projects
| Project name/Short description | Project type | Posted time | Budget |
|---|---|---|---|
Need PSD to HTML5 slicer. I have 6 psd that need to be converted to XHTML in valid w3 code. Also need: - JS Modulars as on the photoshop files (jQuery?) - Images Sprites. My budget is $75 Full details » | 11 minutes ago | $30 - 250 | |
Looking for a coder I am looking for someone who will be up to coding already done templates for a simple site with header (with hover buttons), advertisements, a list of latest uploaded albums for image viewer with ones uploaded within last 24 highlighted, an album image viewer and footer. Should I be satisfied with coder's work on this project, there is a chance for the eventual winner to be involved in a future, bigger ... Full details » | 17 minutes ago | $30 - 250 | |
Programming Project Hi All ! Need a calender like this http://www.apphp.com/php-calendar/examples/sample3/example_small.php for hotel Booking tracking system . I do not want clone . I need it for booking schedule . Thanks Full details » | 26 minutes ago | n/a | |
Embed an iframe into a site Hello to everybody, this is a very simple project for anyone to work with. What I need is an to take an iframe from another website and put it on my own. I just need the code to do that. The difficult part is that the iframe recognizes if its on another site and if it is then it breaks. Thanks everybody. Full details » | 29 minutes ago | $2 - 6 | |
Search Function Script Needs To Be Correctly Installed readme text file is here http://flaworld.com/addons/chainedsearch/readme.txt current viewable errors are here http://flaworld.com/index.php?action=page_display&PageID=3 file creating errors is attached Please no high ridiculous bids Full details » | 38 minutes ago | n/a | |
65701100000 Ea games need for speed world boost point generator or equivalent I have spent over 130 usd on this game it keeps coming out with new cars boost prices are nuts gust need some help getting boost points without tearing my leg and my arm off at same time never say i spent over 65 usd on a full version game butt now its different they say its free but gust look and see. Full details » | 42 minutes ago | $30 - 250 | |
Facebook cloaking script Looking for someone who can produce a strong stable cloaking script for facebook advertising. Should be stabe and as strong as could be, tested to work and updated. Plus - everything should be legal... Thanks Full details » | 47 minutes ago | $250 - 750 | |
php sql simple mailing list I am looking for a simple text box on my website that will allow users to add there email address to our mailing list. they need to be able to select if they are interested in; Sewing Skills Quilting Machine Embroidery Everything - Remove email (this will delete that email from list.) i then need a page that displays all the email addresses separated by a comma. on this page if i click the create ... Full details » | 48 minutes ago | $30 - 250 | |
Network Marketing WebSite Project Hello, I want to develop a website like this http://www.ubcnetworkmarketing.com/index.php but in different design and features the features are: 1- User Profile & Control Panel 2- Bonus System 3- My Products 4- Contact US 5- Company Profile 6- Opportunity User Profile & Control Panel ----------------- Name , address , email , mobile , etc.. Also the member can see the network marketing tree ... Full details » | 59 minutes ago | $750 - 1500 | |
Route search I need to do e "Route Search", similar to that in http://www.shiply.com/search.php under "Power Tools". The user inserts "start location", "end location", "Km off route" to filter a table of less than 10.000 records and find best matches. I'll do integrate the code in my website, so I just need a clean working example with code, using php > 5.3. I ... Full details » | 1 hour ago | $30 - 250 | |
WordPress MultiSite (Real Estate) Project We have three wordpress themes for real estate agents that we would like modified. The entire list is below; Person MUST know the following: - Wordpress MultiSite Network (IMPORTANT!) - New Google Maps API (IMPORTANT!) - PHP (VERY IMPORTANT!) - MySQL5 (VERY IMPORTANT!) 1. all themes should have all theme branding removed (i.e.furu) from code. This includes database prefixes, css, <!-- code, content, ... Full details » | 1 hour ago | $250 - 750 | |
website caravan I require a muti page website advertising a static caravan for rent. Preferably it will have a flash header featuring photos of the interior of the caravan, if not pictures to feature on the homepage, an automated check out facility with calander which display dates when the caravan is available to rent with the option to cancel or amend booking dates, an embeded ebay section showing relevant listings, ... Full details » | 1 hour ago | $250 - 750 | |
Convert Joomla 1.5 Vintage_001 template to Joomla 2.5 I currently have an existing joomla 2.5 template that was converted from joomla 1.5. There are 3 module positions that are not working on the joomla 2.5 template that I would like to get to work. I can provide original 1.5 template and the current 2.5 partially completed template. Full details » | 1 hour ago | $30 - 250 | |
Website with CMS A Private project for HRInfoCare SCOPE 1. The website around 10 standard pages, need to maintained by CMS 2. What's News Listing and Detail pages, need to maintained by CMS 3. Product Catalog and Product Detail pages, around 2-3 level Catalog need to maintained by CMS 4. Three languages required 5. Integrate with Facebook and Twitter, when input a News at CMS then post to Website, Facebook Wall and ... Full details » | 1 hour ago | $250 - 750 | |
Programmer for tumblr template wanted Hello, I'm loking for a professional to realise a cstomised tumblr layout. Layout as PDF, text ,visuals will be delivered to you. You're expected to have the tumblr site looking exactly the same and advise in case of technical limitations. Optimising search engine capabilities is part of the project. Skype will be used for discussion. Please work directly in the tumblr account we will provide. Looking ... Full details » | 2 hours ago | $250 - 750 | |
Magento shop and mobile We are looking for an experienced magento developer that can build a magento shop/site for us. And also can make the shop/site mobile. We already have an online shop made in joomla, www.bejj.nl. The design of the shop will be different than the joomla shop. Need references! Full details » | 2 hours ago | $750 - 1500 | |
Quick Php Form 2 I need a form that allows me to display the company name, email, phone, web address and phone number of the listing and upload photo as thumbnail for listing. The listing page should display up to 25 results at a time before the user has to click on the arrow to see additional results. At the top of the listing page there should be a search selection for the user to beable to select the viewable ... Full details » | 2 hours ago | n/a | |
PSD to WordPress Conversion - Simple Site I need someone fast to convert one PSD to WordPress Theme. I can't get do it my self, because of other projects and this one is to help my good friend to finish his site. Budget is quite small, 30$ but also the PSD is very simple. Thank you. Full details » | 2 hours ago | $30 - 30 | |
Android App 2 2 Develop application that open up into a full screen window. The window will open up a specified website address. On the top right will be an exit button, when pressed when prompt for a password to exit. In the center of the menu bar will be a website address bar to the left of the address bar will be a home button. The the left of the home button will be a favorites button then when press shows a drop ... Full details » | 2 hours ago | n/a | |
Wordpress site customization Customize Wordpress website with custom jquery, java script, creating of 5 custom pages. jquery with automated slider required Full details » | 2 hours ago | $30 - 250 | |
Email and SMS Marketing Website Email and SMS Marketing -import customers from dbs, cvs, xls - manual entry - activity overview (what, when and how was delivered) - automatic contact list feature (i.e. pick first X contact who hasn't received a message in last N days) - send later feature Email - html/plain text email using CK editor - send emais - save drafts - templates (using existing CK Editor template system) - opt out feature - ... Full details » | 2 hours ago | $750 - 1500 | |
Developer .Net We are a French Startup based in Paris. We are looking for a .Net developer with 3-6 years experience in software development. The development will take about 6 months and will take place in our office in Paris. If you are interested, whatever where you come form, please send us your CV Full details » | 2 hours ago | $15 - 25 | |
Finish small WP / Woocommerce site This project is to complete a Wordpress/woocommerce site in a test environment, and once demoed and approved, upload it to its live site. Theme: woocommerce shelflive blue Engine: wocommerce Plugins: paypal digital goods, auspost, viral voucher, a sitemap module, wordpress seo by yoast Config: disable posting on static pages, only blog and shop. Approvals for all comments and reviews, sharethis module Rename ... Full details » | 2 hours ago | $100 - 200 | |
Convert website to Joomla AND code a plugin I need a website in Joomla with a custom plugin. It should be an exact copy of an existing old website (made in .Net). You will be informed of where you can access the old site when chosen for the job. You need to set up everything - templates/sections/content types and so on, so the website will be easy to edit and expand. You need to set up the actual website ON a live server. (Not your own server. ... Full details » | 2 hours ago | $250 - 750 | |
Shirt and Suit designer for webshop. Hi everybody. I am starting a webshop, where customers can design their own business shirt and/or suit and have it made to fit their own body measurements. I would like, if the customers are able to see, how the different options affect the look of the shirt/suit. There will be several options, - when designing a shirt, you have to choose fabric, collar, cuffs, pockets etc... I think, I have found ... Full details » | 2 hours ago | $750 - 1500 | |
operate a website with a creative idea We want to operate a website with a creative idea which includes many services and options to our customers. The customer will pay amount of money to sign up in this website with nominal fees in this website will include many departments and functions. See the attachment for more info. Full details » | 2 hours ago | $1500 - 3000 | |
Web Site Design Dear freelancers, We need an elegant, good looking Website design/HTML for our company. our company deals in calling card and home accounts where user will come and will create account in our website. These user will call to their countries or other destination from their computers. reference services: 1: http://www.raza.com/ 2:http://www.pennytalk.com/ 3: http://www.pidipompi.com/ 4:http://vopium.com/ One ... Full details » | 2 hours ago | $30 - 250 | |
Htaccess File Bug Fix Needed I have phpfox v1.6 installed and sitelok (http://www.vibralogix.com/sitelokpw/downloads.php) I need my .access file fix so that it allows one of sitelok scripts to work and lets phpfox work normally I also need instruction on how to setup files on the site that are viewable and accessible without login to phpfox Full details » | 2 hours ago | n/a | |
Groupdeal agriya fix bugs & add feature Need someone to customize an agriya project named "groupdeal" script. Bid only if you have skills on that script and if you know agriya projects. Bid only if you have very good knowledge base with cakephp, php, sql, css, and especially with agriya project named "groupdeal". The project is: 1. fix small categories bugs. 2. add subdeal/pay in advance feature (already on newest versions). The script ... Full details » | 2 hours ago | $30 - 250 | |
Build a website with pdfs scraped and embed functions I am looking forward to develop a site where the pdf from the net are scraped from the web with various APIs and post to wordpress or any other CMS. Each such posted pdf should have a search engine friendly URL and a brief content associated with it for SEO and to provide value to the user. The pdfs should be programmed to be embedded into the single page and overall, the site should grow on auto pilot. ... Full details » | 2 hours ago | $250 - 750 | |
Convert Access program to web base application I have an Access program that has a backend to MSSQL Database, would like to convert Software program to an web base software application using java or etc, which has a backend to MYSQL or MSSQL Software program is done but need to move it to web base. Full details » | 2 hours ago | $750 - 1500 | |
Update Fedex Print Labels On Cre Loaded From Oscommerce We are in the process of moving our store from an old osCommerce install to a new CRE Loaded install. One of the things that needed to be done is updating the Print labels from the old system to the new fedex api that goes into affect next month. The guy I have doing the move does not seem to be able to get the fedex module finished correctly. It is working for one box per order but some ... Full details » | 2 hours ago | n/a | |
Ebook Landing Page for Clickbank service We need a landing page redesign from this (MP45.com): http://mp45.com/ to one that will convert much more easily and will be compatible with clickbank. It needs to include a thank you page that will be approved by clickbank and the zip files for download need to be secured with a security key using proper script that will prevent users from sharing download url and sharing zip files. We want it ... Full details » | 3 hours ago | $30 - 250 | |
accounting software My company is an accounting software for it. This type of accounting software in the stock and sales, and accounting must be calculated. Full details » | 3 hours ago | $40 - 60 | |
Rewrite File Extension From .htm To .php I need a desktop exe to change the file extension of certain files from .htm to .php Please see attached pdf for a diagram of how the files are arranged:- I start off with ‘folder' Inside this are around 200 subfolders. Inside each of these are 4 files. I want to be able to rename the file named index.htm to index.php in all of the 200 subfolders. Full details » | 3 hours ago | n/a | |
Freight forwarder comp -website Front page PSD file with grid provided - need to create word press website navigation structure provided. Need to layout the relevant pages. Full details » | 3 hours ago | $50 - 125 | |
Joomla/wordpress site Need to design a joomla or wordpress website to look as similar to www.midtronics.com as possible, as far as layout. We are the local supplier in australia of their products and need a design similar. Needs to be as easy as possible to update with new information etc. Have used designers in the past that lock things down once they have finished, needs to be able for us to add plugins etc. Our current ... Full details » | 3 hours ago | $750 - 1500 | |
Articles Site under Wordpress I want to have an Article Site where user will be able to sign in to publish their articles and me or one of the admins will be allow or disallow the articles. I want it ready to use with 60 days of technical support. I also would need it using wordpress in hebrew with RTL support. Please supply you relevant portfolio, examples of similar sites you know, ETA and quote. thanks Gery Full details » | 3 hours ago | $250 - 750 | |
Magento and M2ePro Error *NEW* I am getting this error Fatal error: Ignoring exception from Ess_M2ePro_Model_Connectors_Ebay_Item_List_Single::__destruct() while an exception is already active (Uncaught Zend_Db_Statement_Exception in /home/MYSITE/public_html/store/lib/Zend/Db/Statement/Pdo.php on line 234) in /home/MYSITE/public_html/store/app/code/community/Ess/M2ePro/Model/Connectors/Ebay/Item/Dispatcher.php on line 120 I ... Full details » | 3 hours ago | $30 - 50 | |
Restaurant - SIMPLE Professional HTML Editing / Enhancement Hi, Looking for simple editing to be done on Restaurant website. http://indiadelights.com.au Editing must be clean and be able to be re-edited by myself :) Any suggestions will be considered to enhance website! 1. HOME MENU - Facebook and Urbanspoon icon below 2. HOME MENU - Timed swapping of pictures 10 seconds? Also able to manually change like a gallery 3. ABOUT US / MENU - Background picture ... Full details » | 3 hours ago | $30 - 250 | |
gmail email addresses extractor script What i need is pretty simple. A script (which will be installed on a website naturally) that can extract email addresses from gmail accounts. Report with number of messages processed and number of email addresses extracted will be sent to the user + an attachment of the csv file including the addressed extracted. In short, a simple and clean gmailextract dot com like website Terms: If i find out ... Full details » | 3 hours ago | $30 - 150 | |
Private Project for Travis This is a private project for Travis to fix a a Jcomments plugin that has stopped working since upgrading K2 Full details » | 3 hours ago | $40 - 40 | |
Professional adult website I'm in need of an adult website. I dont know anything about website. And I dont want anybody who ask about something about this subject. That is why im here. If you are a very skilled professional website builder who can do everything from programming to design, then make a bid! Since this is an adult website it is also required to have a membership area. I use Zombaio. So you have to sit down and ... Full details » | 3 hours ago | $750 - 1500 | |
Online Flash Multiplayer Chess Online Multiplayer Chess with the same design as Gamezer Version, but in Flash Version, much stable and with decent look. It should look like: http://gamezer.com/chess/ But developer should consider that all text materials must be translated into Georgian (ქართული) and should provide instruction comments to make it happen easily without creating extra bugs. We ... Full details » | 3 hours ago | $750 - 1500 | |
Website Development Hi Everyone.... I need a website same to http://www.homeshop18.com/. website will be similar but may be little bit change in colour scheme or images. Also need a control panel with it to handle the website. Please come with your existing work and a good Freelancer profile. Please DO NOT bid if you are new to web development field. Technology: PHP,HTML5,CSS3,JQuery and Mysql must be used. Thank ... Full details » | 3 hours ago | $250 - 750 | |
Username/Password Login page with form and confirmation page Pre-Information (What we already have got): We´ve got a website where the user arrives through a i) login page (page #1) where he enters his credentials (Username/password) and being forwarded then to a ii) second page (page #2) where he will be greeted by his correct name, title, etc. (data therefore retrieved from the MySQL database) At the bottom of this page he´s supposed to forwarded iii) via ... Full details » | 3 hours ago | $30 - 250 | |
Migrate Joomla to Wordpress and beautiful Wordpress template Hi, I am after a skilled freelancer who can covert my site from joomla to wordpress. A solid skills are required, not just php/wordpress/css and html but also graphical skills as I am after quality work. The new Wordpress template would be only css/html/xhtml with ajax, no tables, it would have to have beautiful, but simple design, no logo design is required, but few customs icons for sure plus few ... Full details » | 3 hours ago | $250 - 750 | |
Convert JPG files to XHTML I have 28 JPG layouts and i want some to convert them to XHTML in next few hours. Very fast turnaround needed. Almost pages are same so conversion is not too tough. $50 is my budget. Full details » | 3 hours ago | $30 - 250 | |
Extract And Export Html Table Data To Excel Hi guys, I need to scrape this site (http://www.optometrists.asn.au/) for its database of Optometrists, and their contact details. Manually, this requires doing a wildcard surname search by the first letter (e.g. search 'A' for all Optometrists with surnames beginning with letter A). I'd like it if you'd be able to automate this process by running some script to scrape the search result ... Full details » | 3 hours ago | n/a | |
Additions To A Drupal-based Website (new Section) Job type: Make additions to existing website (new sub-section). Site details: Built in Drupal with multiple customised PHP contents. The additions will be made to a .co.uk website. The additions required for this project are divided in 2 Tasks. Task 1 Description: Home Page We need to remove an existing section from the Primary Navigation Links on the Home Page (this menu appears on every ... Full details » | 4 hours ago | n/a |
