SEOClerks

Want a wordpress theme or site created

Want a wordpress theme or site created

I need a website like saucey. An alcohol delivery app. All the website/wordpress theme is like a commerce site, but it will notify me or a user whenver an order is bought because the drink is going to be delivered.
https://play.google.com/store/apps/details?id=com.saucey&hl=en


Requirements

Map shows users location. Map notifies me when someone orders. Site has pictures of all the products.


Skills Required

Wordpress Php Css Html Programming Webdevelop

Bids

i can create any kind of websites in wordpress or prestashop.

hi, i can send you the configured theme and scripts of one of these wordpress sites!
checkout:
- http://ividion.tk
- http://bassup.ml/

  • Media
    PKTG Level 1
  • order now!

    i am a wordpress developer and currently working on 3 websites of las vegas. i am fully suitable for this project.
    reliable and trustworthy. i can do this very efficiently having 2 years of working experience in a top software house.
    excellent experience on other freelancing sites 100% positive rating there
    thanks

    i have built this type of website some years back for one of my client. i will build it exactly they way you want it, if you hire me. thanks

    Bid On Listing Created 11 years ago in Programming

    Other jobs by Dilandiran

    Order Now
    Process Time: 0.1961190700531

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='29664' AND A.category=B.CATID AND A.USERID=C.USERID1SELECT A.*, B.name, B.seo, C.username, C.userlevel, C.footer_code, C.rating, C.ratingcount, C.googleplus_profile, C.total_recommendations, C.USERID, C.profilepicture, C.average_response_time, C.lastlogin, C.addtime FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='29664' AND A.category=B.CATID AND A.USERID=C.USERID

    /opt/clerks-staging/docroot/viewwant.php 163 () ()

    SELECT * FROM ratings_buyer WHERE USERID=300121SELECT sum(good) as thumbup, sum(bad) as thumbdown FROM ratings_buyer WHERE USERID=30012

    /opt/clerks-staging/docroot/include/functions/main.php 19523 GetRatingsAsBuyerTotal() ()

    SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 29664 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Wordpress Php Css Html Programming Webdevelop%' ) LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 29664 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Wordpress Php Css Html Programming Webdevelop%' ) LIMIT 4

    /opt/clerks-staging/docroot/viewwant.php 551 () ()

    SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 29664 AND A.category=B.CATID AND A.active=1 AND A.USERID=30012 LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 29664 AND A.category=B.CATID AND A.active=1 AND A.USERID=30012 LIMIT 4

    /opt/clerks-staging/docroot/viewwant.php 568 () ()

    SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='29664' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc1SELECT a.comment, a.USERID, a.CID, a.time_added, a.istranslated, a.parentid, b.username, b.profilepicture FROM wantcomments a, seoclerks.members b WHERE a.PID='29664' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc

    /opt/clerks-staging/docroot/viewwant.php 835 () ()

    UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='29664'1UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='29664'

    /opt/clerks-staging/docroot/include/functions/main.php 1729 update_wantviewcount() ()

    SELECT * FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='29664' ORDER BY w.bidid ASC 1SELECT w.bidid, w.PID, w.comment, w.title, w.pricepublic, w.USERID, w.adjustedprice, w.ip, m.profilepicture FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='29664' ORDER BY w.bidid ASC

    /opt/clerks-staging/docroot/viewwant.php 1192 () ()

    SELECT * FROM seoclerks.members as m WHERE m.USERID=3123101SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=312310

    /opt/clerks-staging/docroot/viewwant.php 1258 () ()

    SELECT * FROM seoclerks.members as m WHERE m.USERID=3317101SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=331710

    /opt/clerks-staging/docroot/viewwant.php 1258 () ()

    SELECT * FROM seoclerks.members as m WHERE m.USERID=3348461SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=334846

    /opt/clerks-staging/docroot/viewwant.php 1258 () ()

    SELECT * FROM seoclerks.members as m WHERE m.USERID=3697781SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=369778

    /opt/clerks-staging/docroot/viewwant.php 1258 () ()

    SELECT * FROM categories_wanttobuy1SELECT * FROM categories_wanttobuy

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

    SELECT * FROM posts WHERE USERID=300121SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=30012

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal()

    SELECT * FROM categories1SELECT * FROM categories

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

    select * from categories_software order by name asc1select * from categories_software order by name asc

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()

    select * from categories_wanttobuy order by name asc1select * from categories_wanttobuy order by name asc

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()

    select * from categories_wanttotrade order by name asc1select * from categories_wanttotrade order by name asc

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()

    SELECT * FROM seoclerks.members WHERE USERID='312310'1SELECT profilepicture FROM seoclerks.members WHERE USERID='312310'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='331710'1SELECT profilepicture FROM seoclerks.members WHERE USERID='331710'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='334846'1SELECT profilepicture FROM seoclerks.members WHERE USERID='334846'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='369778'1SELECT profilepicture FROM seoclerks.members WHERE USERID='369778'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='30012'1SELECT profile_data FROM seoclerks.members WHERE USERID='30012'

    /opt/clerks-staging/docroot/include/functions/main.php 1927 getUserBackground() include()

    Invalid SQL

    count(*)sql1error_msg

    Expensive SQL

    Tuning the following SQL could reduce the server load substantially
    LoadCountSQLMaxMin

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin
    0.4187581SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (72) AND gtags like'%Website%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4187580.418758
    0.1950591SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (88) AND gtags like'%authority%' AND type !=99 0.1950590.195059
    0.1913531SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (88) AND gtags like'%authority%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.1913530.191353
    0.1068121SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 29664 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Wordpress Php Css Html Programming Webdevelop%' ) LIMIT 40.1068120.106812