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) 511 queries took 499 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Language`.`code` FROM `languages` AS `Language` WHERE `status` = 1 LIMIT 1112
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 1117
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 1111
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) 110
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
21DESCRIBE `eav_values_varchar`4417
22DESCRIBE `eav_values_int`4434
23DESCRIBE `eav_values_text`4416
24DESCRIBE `eav_values_matrix`5521
25DESCRIBE `eav_values_other`4416
26SELECT `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) 222
27SELECT `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) 001
28SELECT `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
29SELECT `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
30SELECT 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
31SELECT `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 33311
32SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 51 113
33SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 51 LIMIT 1110
34SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 18 AND `Category`.`lft` > 17 ORDER BY `Category`.`lft` asc 000
35SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (51) 1113
36SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 51 LIMIT 1110
37SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 18 AND `Category`.`lft` > 17 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` = 'UrduRecipe' 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` = 'UrduRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
40SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (51) 110
41SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 51 LIMIT 1110
42SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 18 AND `Category`.`lft` > 17 ORDER BY `Category`.`lft` asc 000
43SELECT `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
44SELECT `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
45SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (51) 110
46SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 62 110
47SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 62 LIMIT 1110
48SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 42 AND `Category`.`lft` > 41 ORDER BY `Category`.`lft` asc 000
49SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (62) 1112
50SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 62 LIMIT 1110
51SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 42 AND `Category`.`lft` > 41 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` = 'UrduRecipe' 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` = 'UrduRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
54SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (62) 1110
55SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 62 LIMIT 1110
56SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 42 AND `Category`.`lft` > 41 ORDER BY `Category`.`lft` asc 000
57SELECT `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
58SELECT `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 001
59SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (62) 110
60SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 65 110
61SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 65 LIMIT 1111
62SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 48 AND `Category`.`lft` > 47 ORDER BY `Category`.`lft` asc 000
63SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (65) 1112
64SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 65 LIMIT 1110
65SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 48 AND `Category`.`lft` > 47 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` = 'UrduRecipe' 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` = 'UrduRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
68SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (65) 110
69SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 65 LIMIT 1110
70SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 48 AND `Category`.`lft` > 47 ORDER BY `Category`.`lft` asc 000
71SELECT `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
72SELECT `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
73SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (65) 110
74SELECT `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 (3228, 3227, 3226) 550
75SELECT `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 (3228, 3227, 3226) 000
76SELECT `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 (3228, 3227, 3226) AND `CookbookRecipe`.`cookbook_id` = `Cookbook`.`id`) WHERE 1 = 1 000
77SELECT `EavRecord`.`id`, `EavRecord`.`entity_id` FROM `eav_records` AS `EavRecord` WHERE `entity_id` IN (3228, 3227, 3226) AND `entity` = 'Recipe' 330
78SELECT `EavValuesInt`.`id`, `EavValuesInt`.`entity_field_id`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `eav_record_id` IN (5146, 5147, 5148) AND `entity_field_id` IN (1, 2, 3, 4) 660
79SELECT `EavValuesVarchar`.`id`, `EavValuesVarchar`.`entity_field_id`, `EavValuesVarchar`.`value`, `EavValuesVarchar`.`eav_record_id` FROM `eav_values_varchar` AS `EavValuesVarchar` WHERE `eav_record_id` IN (5146, 5147, 5148) AND `entity_field_id` IN (1, 2, 3, 4) 550
80SELECT `EavValuesOther`.`id`, `EavValuesOther`.`entity_field_id`, `EavValuesOther`.`value`, `EavValuesOther`.`eav_record_id` FROM `eav_values_other` AS `EavValuesOther` WHERE `eav_record_id` IN (5146, 5147, 5148) AND `entity_field_id` IN (1, 2, 3, 4) 000
81SELECT `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 (3228, 3227, 3226) AND `Asset`.`status` = 1 AND `type` = 'Recipe' 550
82SELECT *, 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 33312
83SELECT `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
84SELECT `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
85SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 1 110
86SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 1 LIMIT 1110
87SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 12 AND `Category`.`lft` > 11 ORDER BY `Category`.`lft` asc 000
88SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (1) 119
89SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 1 LIMIT 1110
90SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 12 AND `Category`.`lft` > 11 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` = 'UrduRecipe' 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` = 'UrduRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
93SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (1) 110
94SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 1 LIMIT 1110
95SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 12 AND `Category`.`lft` > 11 ORDER BY `Category`.`lft` asc 000
96SELECT `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
97SELECT `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
98SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (1) 110
99SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 67 110
100SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 67 LIMIT 1110
101SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 52 AND `Category`.`lft` > 51 ORDER BY `Category`.`lft` asc 000
102SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (67) 119
103SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 67 LIMIT 1110
104SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 52 AND `Category`.`lft` > 51 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` = 'UrduRecipe' 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` = 'UrduRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
107SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (67) 110
108SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 67 LIMIT 1110
109SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 52 AND `Category`.`lft` > 51 ORDER BY `Category`.`lft` asc 000
110SELECT `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
111SELECT `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
112SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (67) 110
113SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 56 110
114SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 56 LIMIT 1110
115SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 28 AND `Category`.`lft` > 27 ORDER BY `Category`.`lft` asc 000
116SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (56) 1110
117SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 56 LIMIT 1110
118SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 28 AND `Category`.`lft` > 27 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` = 'UrduRecipe' 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` = 'UrduRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
121SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (56) 110
122SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 56 LIMIT 1110
123SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 28 AND `Category`.`lft` > 27 ORDER BY `Category`.`lft` asc 000
124SELECT `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
125SELECT `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
126SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (56) 110
127SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 21 110
128SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 21 LIMIT 1110
129SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 14 AND `Category`.`lft` > 13 ORDER BY `Category`.`lft` asc 000
130SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (21) 110
131SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 21 LIMIT 1110
132SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 14 AND `Category`.`lft` > 13 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` = 'UrduRecipe' 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` = 'UrduRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
135SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (21) 110
136SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 21 LIMIT 1110
137SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 14 AND `Category`.`lft` > 13 ORDER BY `Category`.`lft` asc 000
138SELECT `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
139SELECT `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
140SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (21) 110
141SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 70 110
142SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 70 LIMIT 1110
143SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 58 AND `Category`.`lft` > 57 ORDER BY `Category`.`lft` asc 000
144SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (70) 119
145SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 70 LIMIT 1110
146SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 58 AND `Category`.`lft` > 57 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` = 'UrduRecipe' 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` = 'UrduRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
149SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (70) 110
150SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 70 LIMIT 1110
151SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 58 AND `Category`.`lft` > 57 ORDER BY `Category`.`lft` asc 000
152SELECT `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
153SELECT `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
154SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (70) 110
155SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 69 110
156SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 69 LIMIT 1110
157SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 56 AND `Category`.`lft` > 55 ORDER BY `Category`.`lft` asc 000
158SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (69) 119
159SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 69 LIMIT 1110
160SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 56 AND `Category`.`lft` > 55 ORDER BY `Category`.`lft` asc 000
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` = 'UrduRecipe' 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` = 'UrduRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
163SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (69) 110
164SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 69 LIMIT 1110
165SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 56 AND `Category`.`lft` > 55 ORDER BY `Category`.`lft` asc 000
166SELECT `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
167SELECT `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
168SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (69) 110
169SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 57 110
170SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 57 LIMIT 1110
171SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 30 AND `Category`.`lft` > 29 ORDER BY `Category`.`lft` asc 000
172SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (57) 119
173SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 57 LIMIT 1110
174SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 30 AND `Category`.`lft` > 29 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` = 'UrduRecipe' 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` = 'UrduRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
177SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` = (57) 110
178SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 57 LIMIT 1110
179SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 30 AND `Category`.`lft` > 29 ORDER BY `Category`.`lft` asc 000
180SELECT `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
181SELECT `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
182SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` = (57) 110
183SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 58 110
184SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 58 LIMIT 1110
185SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 38 AND `Category`.`lft` > 31 ORDER BY `Category`.`lft` asc 330
186SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` IN (90, 91, 92, 58) 1110
187SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 58 LIMIT 1110
188SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 38 AND `Category`.`lft` > 31 ORDER BY `Category`.`lft` asc 330
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` = 'UrduRecipe' 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` = 'UrduRecipe' AND `EntityField`.`entity_id` IS NULL ORDER BY `EntityField`.`order` ASC 000
191SELECT COUNT(*) AS `count` FROM `urdu_recipies` AS `UrduRecipe` WHERE `UrduRecipe`.`status` = 1 AND `UrduRecipe`.`category_id` IN (90, 91, 92, 58) 110
192SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 58 LIMIT 1110
193SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 38 AND `Category`.`lft` > 31 ORDER BY `Category`.`lft` asc 330
194SELECT `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
195SELECT `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
196SELECT COUNT(*) AS `count` FROM `video_recipes` AS `VideoRecipe` WHERE `VideoRecipe`.`status` = 1 AND `VideoRecipe`.`category_id` IN (90, 91, 92, 58) 110
197SELECT COUNT(*) AS `count` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 61 110
198SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 61 LIMIT 1110
199SELECT `Category`.`id` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 40 AND `Category`.`lft` > 39 ORDER BY `Category`.`lft` asc 000
200SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`category_id` = (61) 119