News | Business | Cricket | Showbiz | Pictures | Videos | Weather Blog | Forum




One Pakistan - Pakistan News & General Entertainment Web Portal

Mobile RSS / Alerts Sitemap
Get Social with Us!

Use of this site is governed by our Terms and Privacy Policy | About | Copyright | Contact

© Onepakistan.com 2012. All rights reserved.
(default) 85 queries took 82 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Language`.`code` FROM `languages` AS `Language` WHERE `status` = 1 LIMIT 1110
2SELECT `Recipe`.`id`, `Recipe`.`name`, `Recipe`.`slug`, `Recipe`.`main_ingredients`, `Recipe`.`method`, `Recipe`.`short_description`, `Recipe`.`ingredients`, `Recipe`.`user_id`, `Recipe`.`prepration_time`, `Recipe`.`cooking_time`, `Recipe`.`status`, `Recipe`.`count_search`, `Recipe`.`created`, `Recipe`.`view`, `Recipe`.`day`, `Recipe`.`step_by_step_instruction`, `Recipe`.`category_id`, `User`.`id`, `User`.`userType`, `User`.`fullname`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`postal_code`, `User`.`date_joined`, `User`.`lastLoginIpAddr`, `User`.`status`, `User`.`emailVerified`, `User`.`avatar`, `User`.`validateCode`, `User`.`deactivate`, `User`.`last_login_date`, `User`.`rank`, `User`.`blog_status`, `User`.`first_name`, `User`.`last_name`, `User`.`gender`, `User`.`self_intro`, `User`.`dob`, `User`.`cooking_level`, `User`.`hobbies`, `User`.`cooking_interest`, `User`.`do_not_like`, `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`slug`, `Category`.`image`, `Category`.`description` FROM `recipes` AS `Recipe` LEFT JOIN `users` AS `User` ON (`Recipe`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Recipe`.`category_id` = `Category`.`id`) WHERE `Recipe`.`day` = 1 AND `Recipe`.`status` = 1 LIMIT 1110
3SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 75 110
4SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 75 LIMIT 1110
5SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 68 AND `Category`.`lft` > 67 ORDER BY `Category`.`lft` asc 000
6SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (75) 1112
7SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 75 LIMIT 1110
8SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 68 AND `Category`.`lft` > 67 ORDER BY `Category`.`lft` asc 000
9SELECT `EntityField`.`id`, `EntityField`.`eav_field_id`, `EntityField`.`entity`, `EntityField`.`entity_id`, `EntityField`.`order`, `EntityField`.`showOnIndex`, `EntityField`.`searchable`, `EntityField`.`group`, `EavField`.`id`, `EavField`.`name`, `EavField`.`label`, `EavField`.`type`, `EavField`.`params`, `EavField`.`required`, `EavField`.`validation`, `EavField`.`value`, `EavField`.`tooltip`, `EavField`.`options`, `EavField`.`input_options`, `EavField`.`skip_logic`, `EavField`.`order` FROM `entity_fields` AS `EntityField` LEFT JOIN `eav_fields` AS `EavField` ON (`EntityField`.`eav_field_id` = `EavField`.`id`) WHERE `EntityField`.`entity` = 'UrduRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
10SELECT `EntityField`.`id`, `EntityField`.`eav_field_id`, `EntityField`.`entity`, `EntityField`.`entity_id`, `EntityField`.`order`, `EntityField`.`showOnIndex`, `EntityField`.`searchable`, `EntityField`.`group`, `EavField`.`id`, `EavField`.`name`, `EavField`.`label`, `EavField`.`type`, `EavField`.`params`, `EavField`.`required`, `EavField`.`validation`, `EavField`.`value`, `EavField`.`tooltip`, `EavField`.`options`, `EavField`.`input_options`, `EavField`.`skip_logic`, `EavField`.`order` FROM `entity_fields` AS `EntityField` LEFT JOIN `eav_fields` AS `EavField` ON (`EntityField`.`eav_field_id` = `EavField`.`id`) WHERE `EntityField`.`entity` = 'UrduRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
11SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (75) 119
12SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 75 LIMIT 1110
13SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 68 AND `Category`.`lft` > 67 ORDER BY `Category`.`lft` asc 000
14SELECT `EntityField`.`id`, `EntityField`.`eav_field_id`, `EntityField`.`entity`, `EntityField`.`entity_id`, `EntityField`.`order`, `EntityField`.`showOnIndex`, `EntityField`.`searchable`, `EntityField`.`group`, `EavField`.`id`, `EavField`.`name`, `EavField`.`label`, `EavField`.`type`, `EavField`.`params`, `EavField`.`required`, `EavField`.`validation`, `EavField`.`value`, `EavField`.`tooltip`, `EavField`.`options`, `EavField`.`input_options`, `EavField`.`skip_logic`, `EavField`.`order` FROM `entity_fields` AS `EntityField` LEFT JOIN `eav_fields` AS `EavField` ON (`EntityField`.`eav_field_id` = `EavField`.`id`) WHERE `EntityField`.`entity` = 'VideoRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
15SELECT `EntityField`.`id`, `EntityField`.`eav_field_id`, `EntityField`.`entity`, `EntityField`.`entity_id`, `EntityField`.`order`, `EntityField`.`showOnIndex`, `EntityField`.`searchable`, `EntityField`.`group`, `EavField`.`id`, `EavField`.`name`, `EavField`.`label`, `EavField`.`type`, `EavField`.`params`, `EavField`.`required`, `EavField`.`validation`, `EavField`.`value`, `EavField`.`tooltip`, `EavField`.`options`, `EavField`.`input_options`, `EavField`.`skip_logic`, `EavField`.`order` FROM `entity_fields` AS `EntityField` LEFT JOIN `eav_fields` AS `EavField` ON (`EntityField`.`eav_field_id` = `EavField`.`id`) WHERE `EntityField`.`entity` = 'VideoRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
16SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (75) 110
17SELECT `Asset`.`id`, `Asset`.`item_id`, `Asset`.`user_id`, `Asset`.`type`, `Asset`.`name`, `Asset`.`time`, `Asset`.`description`, `Asset`.`upload_type`, `Asset`.`status` FROM `assets` AS `Asset` WHERE `type` = 'Recipe' AND `Asset`.`item_id` = (5) 110
18SELECT `Review`.`id`, `Review`.`title`, `Review`.`body`, `Review`.`status`, `Review`.`user_id`, `Review`.`review_type`, `Review`.`item_id`, `Review`.`date_time`, `Review`.`type`, `Review`.`rating` FROM `reviews` AS `Review` WHERE `type` = 'Recipe' AND `Review`.`item_id` = (5) 000
19SELECT `Cookbook`.`id`, `Cookbook`.`title`, `Cookbook`.`description`, `Cookbook`.`pic`, `Cookbook`.`user_id`, `Cookbook`.`view`, `Cookbook`.`featured`, `Cookbook`.`block_status`, `Cookbook`.`created`, `CookbookRecipe`.`id`, `CookbookRecipe`.`recipe_id`, `CookbookRecipe`.`cookbook_id` FROM `cookbooks` AS `Cookbook` JOIN `cookbook_recipes` AS `CookbookRecipe` ON (`CookbookRecipe`.`recipe_id` = 5 AND `CookbookRecipe`.`cookbook_id` = `Cookbook`.`id`) WHERE 1 = 1 000
20SELECT `EavRecord`.`id`, `EavRecord`.`entity_id` FROM `eav_records` AS `EavRecord` WHERE `entity_id` = (5) AND `entity` = 'Recipe' 110
21SELECT `EavValuesInt`.`id`, `EavValuesInt`.`entity_field_id`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `eav_record_id` = (12) AND `entity_field_id` IN (1, 2, 3, 4) 220
22SELECT `EavValuesVarchar`.`id`, `EavValuesVarchar`.`entity_field_id`, `EavValuesVarchar`.`value`, `EavValuesVarchar`.`eav_record_id` FROM `eav_values_varchar` AS `EavValuesVarchar` WHERE `eav_record_id` = (12) AND `entity_field_id` IN (1, 2, 3, 4) 000
23SELECT `EavValuesOther`.`id`, `EavValuesOther`.`entity_field_id`, `EavValuesOther`.`value`, `EavValuesOther`.`eav_record_id` FROM `eav_values_other` AS `EavValuesOther` WHERE `eav_record_id` = (12) AND `entity_field_id` IN (1, 2, 3, 4) 000
24SELECT `Asset`.`id`, `Asset`.`item_id`, `Asset`.`user_id`, `Asset`.`type`, `Asset`.`name`, `Asset`.`time`, `Asset`.`description`, `Asset`.`upload_type`, `Asset`.`status` FROM `assets` AS `Asset` WHERE `item_id` = (5) AND `Asset`.`status` = 1 AND `type` = 'Recipe' 110
25SELECT Avg(rating) as avg FROM `reviews` AS `Review` WHERE `item_id` = 5 AND `type` = 'Recipe' AND `Review`.`status` = 1 GROUP BY item_id LIMIT 1000
26SELECT `Recipe`.`id`, `Recipe`.`name`, `Recipe`.`slug`, `Recipe`.`main_ingredients`, `Recipe`.`method`, `Recipe`.`short_description`, `Recipe`.`ingredients`, `Recipe`.`user_id`, `Recipe`.`prepration_time`, `Recipe`.`cooking_time`, `Recipe`.`status`, `Recipe`.`count_search`, `Recipe`.`created`, `Recipe`.`view`, `Recipe`.`day`, `Recipe`.`step_by_step_instruction`, `Recipe`.`category_id`, `User`.`id`, `User`.`userType`, `User`.`fullname`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`postal_code`, `User`.`date_joined`, `User`.`lastLoginIpAddr`, `User`.`status`, `User`.`emailVerified`, `User`.`avatar`, `User`.`validateCode`, `User`.`deactivate`, `User`.`last_login_date`, `User`.`rank`, `User`.`blog_status`, `User`.`first_name`, `User`.`last_name`, `User`.`gender`, `User`.`self_intro`, `User`.`dob`, `User`.`cooking_level`, `User`.`hobbies`, `User`.`cooking_interest`, `User`.`do_not_like`, `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`slug`, `Category`.`image`, `Category`.`description` FROM `recipes` AS `Recipe` LEFT JOIN `users` AS `User` ON (`Recipe`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Recipe`.`category_id` = `Category`.`id`) WHERE `Recipe`.`status` = 1 ORDER BY `created` DESC LIMIT 3330
27SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 62 110
28SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 62 LIMIT 1110
29SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 42 AND `Category`.`lft` > 41 ORDER BY `Category`.`lft` asc 000
30SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (62) 117
31SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 62 LIMIT 1110
32SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 42 AND `Category`.`lft` > 41 ORDER BY `Category`.`lft` asc 000
33SELECT `EntityField`.`id`, `EntityField`.`eav_field_id`, `EntityField`.`entity`, `EntityField`.`entity_id`, `EntityField`.`order`, `EntityField`.`showOnIndex`, `EntityField`.`searchable`, `EntityField`.`group`, `EavField`.`id`, `EavField`.`name`, `EavField`.`label`, `EavField`.`type`, `EavField`.`params`, `EavField`.`required`, `EavField`.`validation`, `EavField`.`value`, `EavField`.`tooltip`, `EavField`.`options`, `EavField`.`input_options`, `EavField`.`skip_logic`, `EavField`.`order` FROM `entity_fields` AS `EntityField` LEFT JOIN `eav_fields` AS `EavField` ON (`EntityField`.`eav_field_id` = `EavField`.`id`) WHERE `EntityField`.`entity` = 'UrduRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
34SELECT `EntityField`.`id`, `EntityField`.`eav_field_id`, `EntityField`.`entity`, `EntityField`.`entity_id`, `EntityField`.`order`, `EntityField`.`showOnIndex`, `EntityField`.`searchable`, `EntityField`.`group`, `EavField`.`id`, `EavField`.`name`, `EavField`.`label`, `EavField`.`type`, `EavField`.`params`, `EavField`.`required`, `EavField`.`validation`, `EavField`.`value`, `EavField`.`tooltip`, `EavField`.`options`, `EavField`.`input_options`, `EavField`.`skip_logic`, `EavField`.`order` FROM `entity_fields` AS `EntityField` LEFT JOIN `eav_fields` AS `EavField` ON (`EntityField`.`eav_field_id` = `EavField`.`id`) WHERE `EntityField`.`entity` = 'UrduRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
35SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (62) 118
36SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 62 LIMIT 1110
37SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 42 AND `Category`.`lft` > 41 ORDER BY `Category`.`lft` asc 000
38SELECT `EntityField`.`id`, `EntityField`.`eav_field_id`, `EntityField`.`entity`, `EntityField`.`entity_id`, `EntityField`.`order`, `EntityField`.`showOnIndex`, `EntityField`.`searchable`, `EntityField`.`group`, `EavField`.`id`, `EavField`.`name`, `EavField`.`label`, `EavField`.`type`, `EavField`.`params`, `EavField`.`required`, `EavField`.`validation`, `EavField`.`value`, `EavField`.`tooltip`, `EavField`.`options`, `EavField`.`input_options`, `EavField`.`skip_logic`, `EavField`.`order` FROM `entity_fields` AS `EntityField` LEFT JOIN `eav_fields` AS `EavField` ON (`EntityField`.`eav_field_id` = `EavField`.`id`) WHERE `EntityField`.`entity` = 'VideoRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
39SELECT `EntityField`.`id`, `EntityField`.`eav_field_id`, `EntityField`.`entity`, `EntityField`.`entity_id`, `EntityField`.`order`, `EntityField`.`showOnIndex`, `EntityField`.`searchable`, `EntityField`.`group`, `EavField`.`id`, `EavField`.`name`, `EavField`.`label`, `EavField`.`type`, `EavField`.`params`, `EavField`.`required`, `EavField`.`validation`, `EavField`.`value`, `EavField`.`tooltip`, `EavField`.`options`, `EavField`.`input_options`, `EavField`.`skip_logic`, `EavField`.`order` FROM `entity_fields` AS `EntityField` LEFT JOIN `eav_fields` AS `EavField` ON (`EntityField`.`eav_field_id` = `EavField`.`id`) WHERE `EntityField`.`entity` = 'VideoRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
40SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (62) 110
41SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 65 110
42SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 65 LIMIT 1110
43SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 48 AND `Category`.`lft` > 47 ORDER BY `Category`.`lft` asc 000
44SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (65) 119
45SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 65 LIMIT 1110
46SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 48 AND `Category`.`lft` > 47 ORDER BY `Category`.`lft` asc 000
47SELECT `EntityField`.`id`, `EntityField`.`eav_field_id`, `EntityField`.`entity`, `EntityField`.`entity_id`, `EntityField`.`order`, `EntityField`.`showOnIndex`, `EntityField`.`searchable`, `EntityField`.`group`, `EavField`.`id`, `EavField`.`name`, `EavField`.`label`, `EavField`.`type`, `EavField`.`params`, `EavField`.`required`, `EavField`.`validation`, `EavField`.`value`, `EavField`.`tooltip`, `EavField`.`options`, `EavField`.`input_options`, `EavField`.`skip_logic`, `EavField`.`order` FROM `entity_fields` AS `EntityField` LEFT JOIN `eav_fields` AS `EavField` ON (`EntityField`.`eav_field_id` = `EavField`.`id`) WHERE `EntityField`.`entity` = 'UrduRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
48SELECT `EntityField`.`id`, `EntityField`.`eav_field_id`, `EntityField`.`entity`, `EntityField`.`entity_id`, `EntityField`.`order`, `EntityField`.`showOnIndex`, `EntityField`.`searchable`, `EntityField`.`group`, `EavField`.`id`, `EavField`.`name`, `EavField`.`label`, `EavField`.`type`, `EavField`.`params`, `EavField`.`required`, `EavField`.`validation`, `EavField`.`value`, `EavField`.`tooltip`, `EavField`.`options`, `EavField`.`input_options`, `EavField`.`skip_logic`, `EavField`.`order` FROM `entity_fields` AS `EntityField` LEFT JOIN `eav_fields` AS `EavField` ON (`EntityField`.`eav_field_id` = `EavField`.`id`) WHERE `EntityField`.`entity` = 'UrduRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
49SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (65) 1110
50SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 65 LIMIT 1110
51SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 48 AND `Category`.`lft` > 47 ORDER BY `Category`.`lft` asc 000
52SELECT `EntityField`.`id`, `EntityField`.`eav_field_id`, `EntityField`.`entity`, `EntityField`.`entity_id`, `EntityField`.`order`, `EntityField`.`showOnIndex`, `EntityField`.`searchable`, `EntityField`.`group`, `EavField`.`id`, `EavField`.`name`, `EavField`.`label`, `EavField`.`type`, `EavField`.`params`, `EavField`.`required`, `EavField`.`validation`, `EavField`.`value`, `EavField`.`tooltip`, `EavField`.`options`, `EavField`.`input_options`, `EavField`.`skip_logic`, `EavField`.`order` FROM `entity_fields` AS `EntityField` LEFT JOIN `eav_fields` AS `EavField` ON (`EntityField`.`eav_field_id` = `EavField`.`id`) WHERE `EntityField`.`entity` = 'VideoRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
53SELECT `EntityField`.`id`, `EntityField`.`eav_field_id`, `EntityField`.`entity`, `EntityField`.`entity_id`, `EntityField`.`order`, `EntityField`.`showOnIndex`, `EntityField`.`searchable`, `EntityField`.`group`, `EavField`.`id`, `EavField`.`name`, `EavField`.`label`, `EavField`.`type`, `EavField`.`params`, `EavField`.`required`, `EavField`.`validation`, `EavField`.`value`, `EavField`.`tooltip`, `EavField`.`options`, `EavField`.`input_options`, `EavField`.`skip_logic`, `EavField`.`order` FROM `entity_fields` AS `EntityField` LEFT JOIN `eav_fields` AS `EavField` ON (`EntityField`.`eav_field_id` = `EavField`.`id`) WHERE `EntityField`.`entity` = 'VideoRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
54SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (65) 110
55SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 66 110
56SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 66 LIMIT 1110
57SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 50 AND `Category`.`lft` > 49 ORDER BY `Category`.`lft` asc 000
58SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (66) 118
59SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 66 LIMIT 1110
60SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 50 AND `Category`.`lft` > 49 ORDER BY `Category`.`lft` asc 000
61SELECT `EntityField`.`id`, `EntityField`.`eav_field_id`, `EntityField`.`entity`, `EntityField`.`entity_id`, `EntityField`.`order`, `EntityField`.`showOnIndex`, `EntityField`.`searchable`, `EntityField`.`group`, `EavField`.`id`, `EavField`.`name`, `EavField`.`label`, `EavField`.`type`, `EavField`.`params`, `EavField`.`required`, `EavField`.`validation`, `EavField`.`value`, `EavField`.`tooltip`, `EavField`.`options`, `EavField`.`input_options`, `EavField`.`skip_logic`, `EavField`.`order` FROM `entity_fields` AS `EntityField` LEFT JOIN `eav_fields` AS `EavField` ON (`EntityField`.`eav_field_id` = `EavField`.`id`) WHERE `EntityField`.`entity` = 'UrduRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
62SELECT `EntityField`.`id`, `EntityField`.`eav_field_id`, `EntityField`.`entity`, `EntityField`.`entity_id`, `EntityField`.`order`, `EntityField`.`showOnIndex`, `EntityField`.`searchable`, `EntityField`.`group`, `EavField`.`id`, `EavField`.`name`, `EavField`.`label`, `EavField`.`type`, `EavField`.`params`, `EavField`.`required`, `EavField`.`validation`, `EavField`.`value`, `EavField`.`tooltip`, `EavField`.`options`, `EavField`.`input_options`, `EavField`.`skip_logic`, `EavField`.`order` FROM `entity_fields` AS `EntityField` LEFT JOIN `eav_fields` AS `EavField` ON (`EntityField`.`eav_field_id` = `EavField`.`id`) WHERE `EntityField`.`entity` = 'UrduRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
63SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (66) 118
64SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 66 LIMIT 1110
65SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 50 AND `Category`.`lft` > 49 ORDER BY `Category`.`lft` asc 000
66SELECT `EntityField`.`id`, `EntityField`.`eav_field_id`, `EntityField`.`entity`, `EntityField`.`entity_id`, `EntityField`.`order`, `EntityField`.`showOnIndex`, `EntityField`.`searchable`, `EntityField`.`group`, `EavField`.`id`, `EavField`.`name`, `EavField`.`label`, `EavField`.`type`, `EavField`.`params`, `EavField`.`required`, `EavField`.`validation`, `EavField`.`value`, `EavField`.`tooltip`, `EavField`.`options`, `EavField`.`input_options`, `EavField`.`skip_logic`, `EavField`.`order` FROM `entity_fields` AS `EntityField` LEFT JOIN `eav_fields` AS `EavField` ON (`EntityField`.`eav_field_id` = `EavField`.`id`) WHERE `EntityField`.`entity` = 'VideoRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
67SELECT `EntityField`.`id`, `EntityField`.`eav_field_id`, `EntityField`.`entity`, `EntityField`.`entity_id`, `EntityField`.`order`, `EntityField`.`showOnIndex`, `EntityField`.`searchable`, `EntityField`.`group`, `EavField`.`id`, `EavField`.`name`, `EavField`.`label`, `EavField`.`type`, `EavField`.`params`, `EavField`.`required`, `EavField`.`validation`, `EavField`.`value`, `EavField`.`tooltip`, `EavField`.`options`, `EavField`.`input_options`, `EavField`.`skip_logic`, `EavField`.`order` FROM `entity_fields` AS `EntityField` LEFT JOIN `eav_fields` AS `EavField` ON (`EntityField`.`eav_field_id` = `EavField`.`id`) WHERE `EntityField`.`entity` = 'VideoRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
68SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (66) 110
69SELECT `Asset`.`id`, `Asset`.`item_id`, `Asset`.`user_id`, `Asset`.`type`, `Asset`.`name`, `Asset`.`time`, `Asset`.`description`, `Asset`.`upload_type`, `Asset`.`status` FROM `assets` AS `Asset` WHERE `type` = 'Recipe' AND `Asset`.`item_id` IN (3227, 3226, 3225) 550
70SELECT `Review`.`id`, `Review`.`title`, `Review`.`body`, `Review`.`status`, `Review`.`user_id`, `Review`.`review_type`, `Review`.`item_id`, `Review`.`date_time`, `Review`.`type`, `Review`.`rating` FROM `reviews` AS `Review` WHERE `type` = 'Recipe' AND `Review`.`item_id` IN (3227, 3226, 3225) 000
71SELECT `Cookbook`.`id`, `Cookbook`.`title`, `Cookbook`.`description`, `Cookbook`.`pic`, `Cookbook`.`user_id`, `Cookbook`.`view`, `Cookbook`.`featured`, `Cookbook`.`block_status`, `Cookbook`.`created`, `CookbookRecipe`.`id`, `CookbookRecipe`.`recipe_id`, `CookbookRecipe`.`cookbook_id` FROM `cookbooks` AS `Cookbook` JOIN `cookbook_recipes` AS `CookbookRecipe` ON (`CookbookRecipe`.`recipe_id` IN (3227, 3226, 3225) AND `CookbookRecipe`.`cookbook_id` = `Cookbook`.`id`) WHERE 1 = 1 000
72SELECT `EavRecord`.`id`, `EavRecord`.`entity_id` FROM `eav_records` AS `EavRecord` WHERE `entity_id` IN (3227, 3226, 3225) AND `entity` = 'Recipe' 332
73SELECT `EavValuesInt`.`id`, `EavValuesInt`.`entity_field_id`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `eav_record_id` IN (5145, 5146, 5147) AND `entity_field_id` IN (1, 2, 3, 4) 660
74SELECT `EavValuesVarchar`.`id`, `EavValuesVarchar`.`entity_field_id`, `EavValuesVarchar`.`value`, `EavValuesVarchar`.`eav_record_id` FROM `eav_values_varchar` AS `EavValuesVarchar` WHERE `eav_record_id` IN (5145, 5146, 5147) AND `entity_field_id` IN (1, 2, 3, 4) 440
75SELECT `EavValuesOther`.`id`, `EavValuesOther`.`entity_field_id`, `EavValuesOther`.`value`, `EavValuesOther`.`eav_record_id` FROM `eav_values_other` AS `EavValuesOther` WHERE `eav_record_id` IN (5145, 5146, 5147) AND `entity_field_id` IN (1, 2, 3, 4) 000
76SELECT `Asset`.`id`, `Asset`.`item_id`, `Asset`.`user_id`, `Asset`.`type`, `Asset`.`name`, `Asset`.`time`, `Asset`.`description`, `Asset`.`upload_type`, `Asset`.`status` FROM `assets` AS `Asset` WHERE `item_id` IN (3227, 3226, 3225) AND `Asset`.`status` = 1 AND `type` = 'Recipe' 550
77SELECT *, count(Review.id) as count FROM `reviews` AS `Review` LEFT JOIN `users` AS `User` ON (`Review`.`user_id` = `User`.`id`) LEFT JOIN `recipes` AS `Recipe` ON (`Review`.`item_id` = `Recipe`.`id`) WHERE 1 = 1 GROUP BY item_id ORDER BY `count` DESC LIMIT 3330
78SELECT `Review`.`id`, `Review`.`title`, `Review`.`body`, `Review`.`status`, `Review`.`user_id`, `Review`.`review_type`, `Review`.`item_id`, `Review`.`date_time`, `Review`.`type`, `Review`.`rating`, `User`.`id`, `User`.`userType`, `User`.`fullname`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`postal_code`, `User`.`date_joined`, `User`.`lastLoginIpAddr`, `User`.`status`, `User`.`emailVerified`, `User`.`avatar`, `User`.`validateCode`, `User`.`deactivate`, `User`.`last_login_date`, `User`.`rank`, `User`.`blog_status`, `User`.`first_name`, `User`.`last_name`, `User`.`gender`, `User`.`self_intro`, `User`.`dob`, `User`.`cooking_level`, `User`.`hobbies`, `User`.`cooking_interest`, `User`.`do_not_like`, `Recipe`.`id`, `Recipe`.`name`, `Recipe`.`slug`, `Recipe`.`main_ingredients`, `Recipe`.`method`, `Recipe`.`short_description`, `Recipe`.`ingredients`, `Recipe`.`user_id`, `Recipe`.`prepration_time`, `Recipe`.`cooking_time`, `Recipe`.`status`, `Recipe`.`count_search`, `Recipe`.`created`, `Recipe`.`view`, `Recipe`.`day`, `Recipe`.`step_by_step_instruction`, `Recipe`.`category_id` FROM `reviews` AS `Review` LEFT JOIN `users` AS `User` ON (`Review`.`user_id` = `User`.`id`) LEFT JOIN `recipes` AS `Recipe` ON (`Review`.`item_id` = `Recipe`.`id`) WHERE NOT (`Review`.`body` = '') ORDER BY `date_time` DESC LIMIT 3330
79SELECT `Ad`.`title`, `Ad`.`id`, `Ad`.`placement`, `Ad`.`code`, `Ad`.`published`, `Ad`.`created` FROM `ads` AS `Ad` WHERE `Ad`.`placement` = 'header' LIMIT 1110
80SELECT `Ad`.`title`, `Ad`.`id`, `Ad`.`placement`, `Ad`.`code`, `Ad`.`published`, `Ad`.`created` FROM `ads` AS `Ad` WHERE `Ad`.`placement` = 'left_column' LIMIT 1110
81SELECT COUNT(*) AS `count` FROM `tags` AS `Tag` WHERE 1 = 1 110
82SELECT `Tag`.`tag`, `Tag`.`slug`, Count(`TaggedItem`.`id`) as count FROM `tagged_items` AS `TaggedItem` LEFT JOIN `tags` AS `Tag` ON (`TaggedItem`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 GROUP BY tag_id ORDER BY `Tag`.`tag` ASC 61610
83SELECT `Ad`.`title`, `Ad`.`id`, `Ad`.`placement`, `Ad`.`code`, `Ad`.`published`, `Ad`.`created` FROM `ads` AS `Ad` WHERE `Ad`.`placement` = 'right_column' LIMIT 1110
84SELECT `Ad`.`title`, `Ad`.`id`, `Ad`.`placement`, `Ad`.`code`, `Ad`.`published`, `Ad`.`created` FROM `ads` AS `Ad` WHERE `Ad`.`placement` = 'right_column' ORDER BY RAND() ASC LIMIT 1119
85SELECT COUNT(*) AS `count` FROM `subscribers` AS `Subscriber` WHERE `Subscriber`.`entity_id` IS NULL 110