Portfolio

Restaurant Listing Websites

123

Dinemagic

A Restaurant directory website, focus on search & data mining.

Staging Server URL: http://dinemagic.codegenies.com/

Lets Eat Out

This website is for listing restaurants in the Jamaican region. The client already had a site in place and he wanted to redesign the site but the designing was cancelled and the client asked to do only the development part of the website.

Staging Server URL: http://letseatout.codegenies.com
Live URL: http://www.letseatoutguide.com/

BiteQuest

A restaurant listing website which is essentially a comprehensive search engine resource. This is a membership website where restaurants can sign up and get their restaurants listed, each restaurant gets a dedicated page and can showcase its quali.....

Staging Server URL: http://bitequest.codegenies.com
Live URL: http://www.bitequest.com

The restaurant listing websites act as search engines especially for the food lovers and for others as well. These enlist all the restaurants and food joints available in a specific region along with all contact details and often with maps to guide the users to the location.

 

The restaurants register themselves with these listing sites and are provided with a space to showcase their specialties and delicacies. Most of these provide the users with contact information for free home delivery at their location.

 

Another great feature of these sites are the lucrative deals offered to the users wherein a user can benefit greatly by patronizing these sites. These sites also offer you results based on your search parameters hence shortlisting venues for your favorite cuisines.

123

MindGenies is an Internet services and solutions company with interests in website development – web application development - E-commerce applications– domain name registrations - web hosting– Live chat solution for online sales support and live customer support – Web services. MindGenies offers lucrative reseller programs and affiliate programs.
(default) 59 queries took 14 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `projects`22221
2DESCRIBE `project_categories`330
3DESCRIBE `project_select_categories`440
4DESCRIBE `project_urls`441
5DESCRIBE `category_descriptions`661
6SELECT `ProjectCategory`.`id`, `ProjectCategory`.`name`, `ProjectCategory`.`display_order` FROM `project_categories` AS `ProjectCategory` WHERE `ProjectCategory`.`id` = "30" 110
7SELECT `ProjectSelectCategory`.`id`, `ProjectSelectCategory`.`project_id`, `ProjectSelectCategory`.`category_id`, `ProjectSelectCategory`.`pro_cat_order` FROM `project_select_categories` AS `ProjectSelectCategory` WHERE `ProjectSelectCategory`.`category_id` = "30" 771
8SELECT COUNT(*) AS `count` FROM `projects` AS `Project` inner JOIN project_select_categories AS `PSC` ON (`PSC`.`project_id` = `Project`.`id`) WHERE `Project`.`id` IN (194,197,189,195,190,300,395) AND `Project`.`mindgenies_display_status`="1" AND `Project`.`status` = "active" AND `PSC`.`category_id` = "30" 111
9SELECT `Project`.*, `PSC`.`pro_cat_order`, `PSC`.`category_id` FROM `projects` AS `Project` inner JOIN project_select_categories AS `PSC` ON (`PSC`.`project_id` = `Project`.`id`) WHERE `Project`.`id` IN (194,197,189,195,190,300,395) AND `Project`.`mindgenies_display_status`="1" AND `Project`.`status` = "active" AND `PSC`.`category_id` = "30" ORDER BY `PSC`.`pro_cat_order` ASC, `PSC`.`id` ASC LIMIT 3332
10SELECT `CategoryDescription`.`id`, `CategoryDescription`.`catid`, `CategoryDescription`.`description`, `CategoryDescription`.`title`, `CategoryDescription`.`meta_description`, `CategoryDescription`.`meta_keyword` FROM `category_descriptions` AS `CategoryDescription` WHERE `CategoryDescription`.`catid` = "30" 110
11DESCRIBE `project_images`771
12SELECT `ProjectImage`.`id`, `ProjectImage`.`project_id`, `ProjectImage`.`large_image`, `ProjectImage`.`thumb_image`, `ProjectImage`.`created`, `ProjectImage`.`modified`, `ProjectImage`.`status` FROM `project_images` AS `ProjectImage` WHERE `ProjectImage`.`project_id` = 194 221
13DESCRIBE `project_users`771
14SELECT `ProjectUser`.`id`, `ProjectUser`.`user_name`, `ProjectUser`.`password`, `ProjectUser`.`url`, `ProjectUser`.`user_type`, `ProjectUser`.`project_id`, `ProjectUser`.`user_type_flag` FROM `project_users` AS `ProjectUser` WHERE project_id = 194 and user_type_flag = 2 111
15SELECT `ProjectImage`.`id`, `ProjectImage`.`project_id`, `ProjectImage`.`large_image`, `ProjectImage`.`thumb_image`, `ProjectImage`.`created`, `ProjectImage`.`modified`, `ProjectImage`.`status` FROM `project_images` AS `ProjectImage` WHERE `ProjectImage`.`project_id` = 197 221
16SELECT `ProjectUser`.`id`, `ProjectUser`.`user_name`, `ProjectUser`.`password`, `ProjectUser`.`url`, `ProjectUser`.`user_type`, `ProjectUser`.`project_id`, `ProjectUser`.`user_type_flag` FROM `project_users` AS `ProjectUser` WHERE project_id = 197 and user_type_flag = 2 111
17SELECT `ProjectImage`.`id`, `ProjectImage`.`project_id`, `ProjectImage`.`large_image`, `ProjectImage`.`thumb_image`, `ProjectImage`.`created`, `ProjectImage`.`modified`, `ProjectImage`.`status` FROM `project_images` AS `ProjectImage` WHERE `ProjectImage`.`project_id` = 189 220
18SELECT `ProjectUser`.`id`, `ProjectUser`.`user_name`, `ProjectUser`.`password`, `ProjectUser`.`url`, `ProjectUser`.`user_type`, `ProjectUser`.`project_id`, `ProjectUser`.`user_type_flag` FROM `project_users` AS `ProjectUser` WHERE project_id = 189 and user_type_flag = 2 110
19SELECT `ProjectCategory`.*, count(`PSC`.`project_id`) as totalProjects FROM `project_categories` AS `ProjectCategory` left JOIN project_select_categories AS `PSC` ON (`PSC`.`category_id` = `ProjectCategory`.`id`) WHERE 1 = 1 GROUP BY `ProjectCategory`.`id` ORDER BY `ProjectCategory`.`display_order` ASC 38380
20SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "42" 110
21SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "6" 110
22SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "2" 110
23SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "41" 110
24SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "16" 110
25SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "5" 110
26SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "3" 110
27SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "26" 110
28SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "25" 110
29SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "24" 110
30SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "23" 110
31SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "22" 110
32SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "21" 110
33SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "20" 110
34SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "27" 110
35SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "18" 110
36SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "15" 110
37SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "14" 110
38SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "13" 110
39SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "12" 110
40SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "11" 110
41SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "10" 110
42SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "8" 110
43SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "7" 110
44SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "4" 110
45SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "35" 110
46SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "37" 110
47SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "38" 110
48SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "39" 110
49SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "40" 110
50SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "28" 110
51SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "32" 110
52SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "31" 110
53SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "29" 110
54SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "30" 110
55SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "17" 110
56SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "43" 110
57SELECT count(`ProjectSelectCategory`.`project_id`) as totalProjects FROM `project_select_categories` AS `ProjectSelectCategory` left JOIN projects AS `PRO` ON (`ProjectSelectCategory`.`project_id` = `PRO`.`id` AND `PRO`.`mindgenies_display_status` = '1') WHERE status = "active" AND `ProjectSelectCategory`.`category_id` = "44" 110
58DESCRIBE `keywords`331
59SELECT `Tag`.*, count(`PST`.`project_id`) as totalProjects FROM `keywords` AS `Tag` inner JOIN project_select_keywords AS `PST` ON (`Tag`.`id` = `PST`.`keyword_id`) WHERE 1 = 1 GROUP BY `Tag`.`id` ORDER BY `Tag`.`id` ASC 26260