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) 464 queries took 485 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 1115
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) 117
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) 117
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 33310
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) 116
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) 117
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) 118
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) 119
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) 116
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' 330
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 3339
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 3331
79SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`slug`, `Category`.`image`, `Category`.`description` FROM `categories` AS `Category` WHERE `parent_id` IS NULL 34340
80SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 67 110
81SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 67 LIMIT 1110
82SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 52 AND `Category`.`lft` > 51 ORDER BY `Category`.`lft` asc 000
83SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (67) 117
84SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 67 LIMIT 1110
85SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 52 AND `Category`.`lft` > 51 ORDER BY `Category`.`lft` asc 000
86SELECT `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
87SELECT `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
88SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (67) 117
89SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 67 LIMIT 1110
90SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 52 AND `Category`.`lft` > 51 ORDER BY `Category`.`lft` asc 000
91SELECT `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
92SELECT `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
93SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (67) 110
94SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 56 110
95SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 56 LIMIT 1110
96SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 28 AND `Category`.`lft` > 27 ORDER BY `Category`.`lft` asc 000
97SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (56) 117
98SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 56 LIMIT 1110
99SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 28 AND `Category`.`lft` > 27 ORDER BY `Category`.`lft` asc 000
100SELECT `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
101SELECT `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
102SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (56) 117
103SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 56 LIMIT 1110
104SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 28 AND `Category`.`lft` > 27 ORDER BY `Category`.`lft` asc 000
105SELECT `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
106SELECT `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
107SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (56) 110
108SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 21 110
109SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 21 LIMIT 1110
110SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 14 AND `Category`.`lft` > 13 ORDER BY `Category`.`lft` asc 000
111SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (21) 118
112SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 21 LIMIT 1110
113SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 14 AND `Category`.`lft` > 13 ORDER BY `Category`.`lft` asc 000
114SELECT `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
115SELECT `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
116SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (21) 116
117SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 21 LIMIT 1110
118SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 14 AND `Category`.`lft` > 13 ORDER BY `Category`.`lft` asc 000
119SELECT `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
120SELECT `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
121SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (21) 110
122SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 70 110
123SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 70 LIMIT 1110
124SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 58 AND `Category`.`lft` > 57 ORDER BY `Category`.`lft` asc 000
125SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (70) 118
126SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 70 LIMIT 1110
127SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 58 AND `Category`.`lft` > 57 ORDER BY `Category`.`lft` asc 000
128SELECT `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
129SELECT `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
130SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (70) 116
131SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 70 LIMIT 1110
132SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 58 AND `Category`.`lft` > 57 ORDER BY `Category`.`lft` asc 000
133SELECT `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
134SELECT `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
135SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (70) 110
136SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 69 110
137SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 69 LIMIT 1110
138SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 56 AND `Category`.`lft` > 55 ORDER BY `Category`.`lft` asc 000
139SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (69) 117
140SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 69 LIMIT 1110
141SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 56 AND `Category`.`lft` > 55 ORDER BY `Category`.`lft` asc 000
142SELECT `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
143SELECT `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
144SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (69) 117
145SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 69 LIMIT 1110
146SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 56 AND `Category`.`lft` > 55 ORDER BY `Category`.`lft` asc 000
147SELECT `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
148SELECT `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
149SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (69) 110
150SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 58 110
151SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 58 LIMIT 1110
152SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 38 AND `Category`.`lft` > 31 ORDER BY `Category`.`lft` asc 330
153SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` IN (90, 91, 92, 58) 118
154SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 58 LIMIT 1110
155SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 38 AND `Category`.`lft` > 31 ORDER BY `Category`.`lft` asc 330
156SELECT `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
157SELECT `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
158SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` IN (90, 91, 92, 58) 117
159SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 58 LIMIT 1110
160SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 38 AND `Category`.`lft` > 31 ORDER BY `Category`.`lft` asc 330
161SELECT `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
162SELECT `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
163SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` IN (90, 91, 92, 58) 110
164SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 61 110
165SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 61 LIMIT 1110
166SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 40 AND `Category`.`lft` > 39 ORDER BY `Category`.`lft` asc 000
167SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (61) 118
168SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 61 LIMIT 1110
169SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 40 AND `Category`.`lft` > 39 ORDER BY `Category`.`lft` asc 000
170SELECT `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
171SELECT `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
172SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (61) 117
173SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 61 LIMIT 1110
174SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 40 AND `Category`.`lft` > 39 ORDER BY `Category`.`lft` asc 000
175SELECT `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
176SELECT `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
177SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (61) 110
178SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 63 110
179SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 63 LIMIT 1110
180SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 44 AND `Category`.`lft` > 43 ORDER BY `Category`.`lft` asc 000
181SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (63) 117
182SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 63 LIMIT 1110
183SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 44 AND `Category`.`lft` > 43 ORDER BY `Category`.`lft` asc 000
184SELECT `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
185SELECT `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
186SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (63) 116
187SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 63 LIMIT 1110
188SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 44 AND `Category`.`lft` > 43 ORDER BY `Category`.`lft` asc 000
189SELECT `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
190SELECT `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
191SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (63) 110
192SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 64 110
193SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 64 LIMIT 1110
194SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 46 AND `Category`.`lft` > 45 ORDER BY `Category`.`lft` asc 000
195SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (64) 117
196SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 64 LIMIT 1110
197SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 46 AND `Category`.`lft` > 45 ORDER BY `Category`.`lft` asc 000
198SELECT `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
199SELECT `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
200SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (64) 116