معرفی کتاب : خلاصه درس و تست های اصول بازاریابی کاتلر

معرفی کتاب : خلاصه درس و تست های اصول بازاریابی کاتلر
نویسنده کتاب : ونوس داور ، راحيل شمس ، پرچ مهرداد
ناشر کتاب : اسرار دانش
تعداد صفحات کتاب : 438

فهرست مطالب کتاب

پیشگفتار 5
فصل 1: معرفی بازاریابی 7
فصل 2: برنامه ریزی استراتژیک و نقش بازاریابی در سازمان 25
فصل 3: محیط بازاریابی 50
فصل 4: تحقیقات بازاریابی و سیستم های اطلاعاتی 60
فصل 5:عوامل موثر در رفتار مصرف کننده 74
فصل 6: فرآیند تصمیم گیری خریدار 91
فصل 7: بازارهای سازمانی و رفتار خرید سازمانی 109
فصل 8: اندازه گیری و پیش بینی تقاضا 126
فصل 9: تقسیم بازار هدف گیری و تعیین جایگاه در بازار 140
فصل 10: طراحی کالا: هدف گیری و تعیین جایگاه در بازار 167
فصل 11: طراحی کالاها: تولید کالاهای جدید و خط مشی های دوره عمر کالا 191
فصل 12: قیمت گذاری کالاها، روش ها و ملاحظات قیمت گذاری 212
فصل 13: خط مشی قیمت گذاری 226
فصل14: توزیع کالاها: کانال های توزیع و توزیع فیزیکی کالا 243
فصل 15: توزیع کالاها: خرده فروشی و عمده فروشی 266
فصل 16: پیشبرد کالاها: خط مشی های ارتباطی و ترکیب عناصر پیشبردی 292
فصل 17: پیشبرد کالاها: تبلیغات غیرشخصی 314
فصل 18: پیشبرد کالاها: مدیریت فروش و فروشندگی شخصی 336
فصل 19: تجزیه و تحلیل رقبا و خط مشی های بازاریابی رقابتی 351
فصل 20: برنامه ریزی، اجرا و کنترل برنامه های بازاریابی 373
فصل 21: بازاریابی بین المللی 390
فصل 22: خدمات و انواع بازاریابی 411
فصل 23: بازاریابی و جامعه: مسولیت اجتماعی و اصول اخلاقی در بازاریابی 424

نماد اعتماد
logo-samandehi
(default) 77 queries took 78 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `libraries`29291
2SELECT `Library`.`id`, `Library`.`metakey`, `Library`.`metadesc`, `Library`.`widget_id`, `Library`.`title`, `Library`.`author`, `Library`.`alias`, `Library`.`publisher`, `Library`.`sources`, `Library`.`table_of_content`, `Library`.`language`, `Library`.`ISBN`, `Library`.`paperback`, `Library`.`date`, `Library`.`description`, `Library`.`price`, `Library`.`picture`, `Library`.`dir`, `Library`.`mimetype`, `Library`.`filesize`, `Library`.`hits`, `Library`.`url`, `Library`.`publish`, `Library`.`created`, `Library`.`access`, `Library`.`modified`, `Library`.`deleted`, `Library`.`created_by`, `Library`.`modified_by` FROM `libraries` AS `Library` WHERE ((`Library`.`id` = 235) AND (`Library`.`publish` = 1)) AND `Library`.`deleted` != 1 110
3UPDATE `libraries` AS `Library` SET `Library`.`hits` = 22696 WHERE `Library`.`id` = 23510
4DESCRIBE `settings`11111
5SELECT `Setting`.`id`, `Setting`.`title`, `Setting`.`slogan`, `Setting`.`email`, `Setting`.`metakey`, `Setting`.`created`, `Setting`.`access`, `Setting`.`modified`, `Setting`.`metadesc`, `Setting`.`created_by`, `Setting`.`modified_by` FROM `settings` AS `Setting` WHERE 1 = 1 LIMIT 1110
6DESCRIBE `groups`13131
7DESCRIBE `users`16161
8DESCRIBE `stars`27271
9SELECT `Group`.`id`, `Group`.`created`, `Group`.`access`, `Group`.`modified`, `Group`.`deleted_date`, `Group`.`deleted`, `Group`.`name`, `Group`.`description`, `Group`.`parent_id`, `Group`.`lft`, `Group`.`rght`, `Group`.`created_by`, `Group`.`modified_by` FROM `groups` AS `Group` WHERE 1 = 1 440
10SELECT `User`.`id`, `User`.`created`, `User`.`access`, `User`.`modified`, `User`.`deleted_date`, `User`.`deleted`, `User`.`group_id`, `User`.`name`, `User`.`field`, `User`.`grade`, `User`.`email`, `User`.`password`, `User`.`picture`, `User`.`active`, `User`.`created_by`, `User`.`modified_by` FROM `users` AS `User` WHERE `User`.`group_id` IN (1, 2, 4, 5) 120801208026
11DESCRIBE `seos`440
12SELECT `Seo`.`id`, `Seo`.`word`, `Seo`.`link`, `Seo`.`deleted` FROM `seos` AS `Seo` WHERE 1 = 1 000
13DESCRIBE `tell_firends`880
14SELECT `TellFirend`.`id`, `TellFirend`.`title`, `TellFirend`.`picture`, `TellFirend`.`picture_dir`, `TellFirend`.`url` FROM `tell_firends` AS `TellFirend` WHERE `TellFirend`.`deleted` != 1 LIMIT 6440
15DESCRIBE `categories`32321
16DESCRIBE `site_layouts`10100
17DESCRIBE `templates`880
18DESCRIBE `positions`11110
19DESCRIBE `widgets`11110
20DESCRIBE `menus`19190
21SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 187 ORDER BY `Menu`.`lft` asc 24240
22SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 1244 ORDER BY `Menu`.`lft` asc 000
23SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 512 ORDER BY `Menu`.`lft` asc 440
24SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 1346 ORDER BY `Menu`.`lft` asc 000
25SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 498 ORDER BY `Menu`.`lft` asc 880
26SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 505 ORDER BY `Menu`.`lft` asc 880
27SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 1227 ORDER BY `Menu`.`lft` asc 330
28SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 1244 ORDER BY `Menu`.`lft` asc 000
29SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 512 ORDER BY `Menu`.`lft` asc 440
30SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 1346 ORDER BY `Menu`.`lft` asc 000
31SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 498 ORDER BY `Menu`.`lft` asc 880
32SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 505 ORDER BY `Menu`.`lft` asc 880
33SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 1227 ORDER BY `Menu`.`lft` asc 330
34SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 1296 ORDER BY `Menu`.`lft` asc 000
35SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 1245 ORDER BY `Menu`.`lft` asc 770
36SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 1281 ORDER BY `Menu`.`lft` asc 12120
37SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 326 ORDER BY `Menu`.`lft` asc 770
38SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 644 ORDER BY `Menu`.`lft` asc 550
39SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 750 ORDER BY `Menu`.`lft` asc 660
40SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 1296 ORDER BY `Menu`.`lft` asc 000
41SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 1245 ORDER BY `Menu`.`lft` asc 770
42SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 1281 ORDER BY `Menu`.`lft` asc 12120
43SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 326 ORDER BY `Menu`.`lft` asc 770
44SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 644 ORDER BY `Menu`.`lft` asc 550
45SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 750 ORDER BY `Menu`.`lft` asc 660
46SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 902 ORDER BY `Menu`.`lft` asc 660
47SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 332 ORDER BY `Menu`.`lft` asc 330
48SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 1243 ORDER BY `Menu`.`lft` asc 000
49SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 1123 ORDER BY `Menu`.`lft` asc 000
50SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 1242 ORDER BY `Menu`.`lft` asc 000
51SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 1361 ORDER BY `Menu`.`lft` asc 000
52SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 902 ORDER BY `Menu`.`lft` asc 660
53SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 332 ORDER BY `Menu`.`lft` asc 330
54SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 1243 ORDER BY `Menu`.`lft` asc 000
55SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 1123 ORDER BY `Menu`.`lft` asc 000
56SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 1242 ORDER BY `Menu`.`lft` asc 000
57SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef` FROM `menus` AS `Menu` WHERE 1 = 1 AND `Menu`.`parent_id` = 1361 ORDER BY `Menu`.`lft` asc 000
58SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`widget_id`, `Category`.`site_layout_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`title`, `Category`.`alias`, `Category`.`metakey`, `Category`.`metadesc`, `Category`.`description`, `Category`.`access`, `Category`.`publish`, `Category`.`deleted`, `Category`.`content`, `Category`.`hits`, `Category`.`file`, `Category`.`file_dir`, `Category`.`file_filesize`, `Category`.`file_mimetype`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by`, `Category`.`cat_type`, `Category`.`widgetset`, `Category`.`link`, `Category`.`noindex`, `Category`.`nofollow`, `Category`.`picture`, `Category`.`picture_dir`, `Category`.`header`, `SiteLayout`.`id`, `SiteLayout`.`template_id`, `SiteLayout`.`name`, `SiteLayout`.`publish`, `SiteLayout`.`deleted`, `SiteLayout`.`created`, `SiteLayout`.`access`, `SiteLayout`.`modified`, `SiteLayout`.`created_by`, `SiteLayout`.`modified_by`, `Widget`.`id`, `Widget`.`name`, `Widget`.`deleted`, `Widget`.`publish`, `Widget`.`type`, `Widget`.`option`, `Widget`.`created`, `Widget`.`access`, `Widget`.`modified`, `Widget`.`created_by`, `Widget`.`modified_by` FROM `categories` AS `Category` LEFT JOIN `site_layouts` AS `SiteLayout` ON (`Category`.`site_layout_id` = `SiteLayout`.`id`) LEFT JOIN `widgets` AS `Widget` ON (`Category`.`widget_id` = `Widget`.`id`) WHERE `widget_id` = 107 ORDER BY `Category`.`created` desc 111
59SELECT `Widget`.`id`, `Widget`.`name`, `Widget`.`deleted`, `Widget`.`publish`, `Widget`.`type`, `Widget`.`option`, `Widget`.`created`, `Widget`.`access`, `Widget`.`modified`, `Widget`.`created_by`, `Widget`.`modified_by` FROM `widgets` AS `Widget` WHERE `id` = 107 110
60SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`widget_id`, `Category`.`site_layout_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`title`, `Category`.`alias`, `Category`.`metakey`, `Category`.`metadesc`, `Category`.`description`, `Category`.`access`, `Category`.`publish`, `Category`.`deleted`, `Category`.`content`, `Category`.`hits`, `Category`.`file`, `Category`.`file_dir`, `Category`.`file_filesize`, `Category`.`file_mimetype`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by`, `Category`.`cat_type`, `Category`.`widgetset`, `Category`.`link`, `Category`.`noindex`, `Category`.`nofollow`, `Category`.`picture`, `Category`.`picture_dir`, `Category`.`header` FROM `categories` AS `Category` WHERE `Category`.`widget_id` = (107) 111
61SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`title`, `Menu`.`publish`, `Menu`.`deleted`, `Menu`.`description`, `Menu`.`alias`, `Menu`.`menu`, `Menu`.`category_id`, `Menu`.`created_by`, `Menu`.`modified_by`, `Menu`.`created`, `Menu`.`access`, `Menu`.`modified`, `Menu`.`menu_type`, `Menu`.`link`, `Menu`.`sef`, `Category`.`id`, `Category`.`parent_id`, `Category`.`widget_id`, `Category`.`site_layout_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`title`, `Category`.`alias`, `Category`.`metakey`, `Category`.`metadesc`, `Category`.`description`, `Category`.`access`, `Category`.`publish`, `Category`.`deleted`, `Category`.`content`, `Category`.`hits`, `Category`.`file`, `Category`.`file_dir`, `Category`.`file_filesize`, `Category`.`file_mimetype`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by`, `Category`.`cat_type`, `Category`.`widgetset`, `Category`.`link`, `Category`.`noindex`, `Category`.`nofollow`, `Category`.`picture`, `Category`.`picture_dir`, `Category`.`header` FROM `menus` AS `Menu` LEFT JOIN `categories` AS `Category` ON (`Menu`.`category_id` = `Category`.`id`) WHERE `Menu`.`category_id` = 438 ORDER BY `Menu`.`lft` ASC LIMIT 1110
62DESCRIBE `advertisements`30301
63DESCRIBE `advertisement_places`11111
64SELECT Advertisement.file, Advertisement.file_dir, Advertisement.file_mimetype, Advertisement.position, Advertisement.height, Advertisement.link_url, `Advertisement`.`id` FROM `advertisements` AS `Advertisement` WHERE `Advertisement`.`publish` = 1 AND `Advertisement`.`position` = 'A2' AND `Advertisement`.`deleted` != 1 ORDER BY RAND() ASC LIMIT 6000
65DESCRIBE `downloads`32321
66DESCRIBE `downloadtags`220
67DESCRIBE `downloads_downloadtags`330
68SELECT Download.id, Download.title, Download.hits FROM `downloads` AS `Download` WHERE `Download`.`widget_id` IN (89, 209, 225) AND `Download`.`publish` = 1 AND `Download`.`deleted` != 1 ORDER BY RAND() ASC LIMIT 10101010
69SELECT `Downloadtag`.`id`, `Downloadtag`.`downloadtag`, `DownloadsDownloadtag`.`id`, `DownloadsDownloadtag`.`download_id`, `DownloadsDownloadtag`.`downloadtag_id` FROM `downloadtags` AS `Downloadtag` JOIN `downloads_downloadtags` AS `DownloadsDownloadtag` ON (`DownloadsDownloadtag`.`download_id` IN (4365, 4032, 3970, 4606, 3228, 4138, 3213, 3199, 4569, 4362) AND `DownloadsDownloadtag`.`downloadtag_id` = `Downloadtag`.`id`) WHERE 1 = 1 37371
70SELECT Download.id, Download.title, Download.hits FROM `downloads` AS `Download` WHERE `Download`.`widget_id` = (210) AND `Download`.`deleted` != 1 ORDER BY RAND() ASC LIMIT 9999
71SELECT `Downloadtag`.`id`, `Downloadtag`.`downloadtag`, `DownloadsDownloadtag`.`id`, `DownloadsDownloadtag`.`download_id`, `DownloadsDownloadtag`.`downloadtag_id` FROM `downloadtags` AS `Downloadtag` JOIN `downloads_downloadtags` AS `DownloadsDownloadtag` ON (`DownloadsDownloadtag`.`download_id` IN (3304, 3297, 3302, 4869, 3299, 3293, 3308, 3307, 3300) AND `DownloadsDownloadtag`.`downloadtag_id` = `Downloadtag`.`id`) WHERE 1 = 1 49491
72SELECT Download.id, Download.title, Download.hits FROM `downloads` AS `Download` WHERE `Download`.`widget_id` = (245) AND `Download`.`deleted` != 1 ORDER BY RAND() ASC LIMIT 9779
73SELECT `Downloadtag`.`id`, `Downloadtag`.`downloadtag`, `DownloadsDownloadtag`.`id`, `DownloadsDownloadtag`.`download_id`, `DownloadsDownloadtag`.`downloadtag_id` FROM `downloadtags` AS `Downloadtag` JOIN `downloads_downloadtags` AS `DownloadsDownloadtag` ON (`DownloadsDownloadtag`.`download_id` IN (4844, 4846, 4845, 4847, 4843, 4841, 4842) AND `DownloadsDownloadtag`.`downloadtag_id` = `Downloadtag`.`id`) WHERE 1 = 1 57571
74SELECT Download.id, Download.title, Download.hits FROM `downloads` AS `Download` WHERE `Download`.`widget_id` IN (79, 81, 82, 99, 117, 80) AND `Download`.`deleted` != 1 ORDER BY RAND() ASC LIMIT 9999
75SELECT `Downloadtag`.`id`, `Downloadtag`.`downloadtag`, `DownloadsDownloadtag`.`id`, `DownloadsDownloadtag`.`download_id`, `DownloadsDownloadtag`.`downloadtag_id` FROM `downloadtags` AS `Downloadtag` JOIN `downloads_downloadtags` AS `DownloadsDownloadtag` ON (`DownloadsDownloadtag`.`download_id` IN (124, 3333, 316, 825, 3328, 3761, 3690, 1349, 251) AND `DownloadsDownloadtag`.`downloadtag_id` = `Downloadtag`.`id`) WHERE 1 = 1 22221
76SELECT Advertisement.file, Advertisement.file_dir, Advertisement.file_mimetype, Advertisement.position, Advertisement.height, Advertisement.link_url, `Advertisement`.`id` FROM `advertisements` AS `Advertisement` WHERE `Advertisement`.`publish` = 1 AND `Advertisement`.`position` = 'D2' AND `Advertisement`.`deleted` != 1 ORDER BY RAND() ASC LIMIT 6000
77SELECT Advertisement.file, Advertisement.file_dir, Advertisement.file_mimetype,Advertisement.position, Advertisement.height, Advertisement.link_url, `Advertisement`.`id` FROM `advertisements` AS `Advertisement` WHERE `Advertisement`.`publish` = 1 AND `Advertisement`.`position` = 'E2' AND `Advertisement`.`deleted` != 1 ORDER BY RAND() ASC LIMIT 6000