CakePHP: the rapid development php framework: Errors

Warning (2): Undefined array key "Category" [APP/Controller/Component/CcontentComponent.php, line 150]

<?php             return $filters;
<?php         } else {
<?php             if (is_numeric($current_category['Category']['parent_id']) && $current_category['Category']['parent_id'] > 0) {

CcontentComponent::get_filter_hang() - APP/Controller/Component/CcontentComponent.php, line 150
CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 272
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 75
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 699
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 213

Warning (2): Trying to access array offset on null [APP/Controller/Component/CcontentComponent.php, line 150]

Code Context

<?php             return $filters;
<?php         } else {
<?php             if (is_numeric($current_category['Category']['parent_id']) && $current_category['Category']['parent_id'] > 0) {

CcontentComponent::get_filter_hang() - APP/Controller/Component/CcontentComponent.php, line 150
CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 272
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 75
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 699
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 213

Warning (2): Undefined array key "Category" [APP/Controller/Component/CcontentComponent.php, line 277]

Code Context

<?php         $this->Controller->currentCategory = $currentCategory;
<?php 
<?php         $node_type = $this->Controller->currentCategory['Category']['ctype'];

CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 277
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 75
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 699
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 213

Warning (2): Trying to access array offset on null [APP/Controller/Component/CcontentComponent.php, line 277]

Code Context

<?php         $this->Controller->currentCategory = $currentCategory;
<?php 
<?php         $node_type = $this->Controller->currentCategory['Category']['ctype'];

CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 277
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 75
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 699
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 213

Warning (2): Undefined array key "Category" [APP/Controller/Component/CcontentComponent.php, line 310]

Code Context

<?php         // else
<?php 
<?php         $this->Controller->paginate = $this->Controller->Node->getPaginate($this->Controller->currentCategory['Category']['id'], $node_type, $limit, $this->Controller->sort, 'desc', $this->Controller->filter_price);

CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 310
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 75
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 699
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 213

Warning (2): Trying to access array offset on null [APP/Controller/Component/CcontentComponent.php, line 310]

Code Context

<?php         // else
<?php 
<?php         $this->Controller->paginate = $this->Controller->Node->getPaginate($this->Controller->currentCategory['Category']['id'], $node_type, $limit, $this->Controller->sort, 'desc', $this->Controller->filter_price);

CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 310
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 75
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 699
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 213

Warning (2): Undefined array key "Category" [APP/Plugin/Default/Model/Node.php, line 150]

Code Context

<?php             $list = $this->Category->find('all', array(

<?php                 'conditions'=>array(

<?php                     'Category.lft >=' => $check['Category']['lft'],

Node::getCategoryTree() - APP/Plugin/Default/Model/Node.php, line 150
Node::getPaginate() - APP/Plugin/Default/Model/Node.php, line 22
CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 310
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 75
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 699
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 213

Warning (2): Trying to access array offset on null [APP/Plugin/Default/Model/Node.php, line 150]

Code Context

<?php             $list = $this->Category->find('all', array(

<?php                 'conditions'=>array(

<?php                     'Category.lft >=' => $check['Category']['lft'],

Node::getCategoryTree() - APP/Plugin/Default/Model/Node.php, line 150
Node::getPaginate() - APP/Plugin/Default/Model/Node.php, line 22
CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 310
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 75
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 699
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 213

Warning (2): Undefined array key "Category" [APP/Plugin/Default/Model/Node.php, line 151]

Code Context

<?php                 'conditions'=>array(

<?php                     'Category.lft >=' => $check['Category']['lft'],

<?php                     'Category.rght <=' => $check['Category']['rght']

Node::getCategoryTree() - APP/Plugin/Default/Model/Node.php, line 151
Node::getPaginate() - APP/Plugin/Default/Model/Node.php, line 22
CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 310
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 75
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 699
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 213

Warning (2): Trying to access array offset on null [APP/Plugin/Default/Model/Node.php, line 151]

Code Context

<?php                 'conditions'=>array(

<?php                     'Category.lft >=' => $check['Category']['lft'],

<?php                     'Category.rght <=' => $check['Category']['rght']

Node::getCategoryTree() - APP/Plugin/Default/Model/Node.php, line 151
Node::getPaginate() - APP/Plugin/Default/Model/Node.php, line 22
CcontentComponent::getArchive() - APP/Controller/Component/CcontentComponent.php, line 310
CcontentComponent::getContent() - APP/Controller/Component/CcontentComponent.php, line 75
NodeController::index() - APP/Plugin/Default/Controller/NodeController.php, line 699
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 213

Database Error

Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '* FROM `mogxvnlv_mogxvnlv`.`nodes` AS `Node` INNER JOIN ON (`Node`.`id`=.no...' at line 1

SQL Query: SELECT `Node`.*, .* FROM `mogxvnlv_mogxvnlv`.`nodes` AS `Node` INNER JOIN ON (`Node`.`id`=.node_id) INNER JOIN `mogxvnlv_mogxvnlv`.`category_linkeds` AS `CategoryLinked` ON (`Node`.`id` = `CategoryLinked`.`node_id`) WHERE `Node`.`status` = 1 AND `Node`.`type` IS NULL AND `CategoryLinked`.`category_id` IS NULL GROUP BY `CategoryLinked`.`node_id` ORDER BY `Node`.`pos` desc, `Node`.`id` desc LIMIT 10

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace

CORE/Cake/Model/Datasource/DboSource.php line 502 → PDOStatement->execute()

<?php         try {

<?php             $query = $this->_connection->prepare($sql, $prepareOptions);

<?php             $query->setFetchMode(PDO::FETCH_LAZY);

<?php             if (!$query->execute($params)) {

<?php                 $this->_result = $query;

CORE/Cake/Model/Datasource/DboSource.php line 468 → DboSource->_execute()

<?php         $options += array('log' => $this->fullDebug);

<?php 

<?php         $t = microtime(true);

<?php         $this->_result = $this->_execute($sql, $params);

<?php

CORE/Cake/Model/Datasource/DboSource.php line 715 → DboSource->execute()

<?php         if ($cache && ($cached = $this->getQueryCache($sql, $params)) !== false) {

<?php             return $cached;

<?php         }

<?php         $result = $this->execute($sql, array(), $params);

<?php         if ($result) {

CORE/Cake/Model/Datasource/DboSource.php line 1226 → DboSource->fetchAll()

<?php         // Build SQL statement with the primary model, plus hasOne and belongsTo associations

<?php         $query = $this->buildAssociationQuery($Model, $queryData);

<?php 

<?php         $resultSet = $this->fetchAll($query, $Model->cacheQueries);

<?php         unset($query);

CORE/Cake/Model/Model.php line 3053 → DboSource->read()

<?php  * @return array

<?php  */

<?php     protected function _readDataSource($type, $query) {

<?php         $results = $this->getDataSource()->read($this, $query);

<?php         $this->resetAssociations();

CORE/Cake/Model/Model.php line 3025 → Model->_readDataSource()

<?php             return null;

<?php         }

<?php 

<?php         return $this->_readDataSource($type, $query);

<?php     }

CORE/Cake/Controller/Component/PaginatorComponent.php line 212 → Model->find()

<?php             if ($recursive != $object->recursive) {

<?php                 $parameters['recursive'] = $recursive;

<?php             }

<?php             $results = $object->find($type, array_merge($parameters, $extra));

<?php         }

CORE/Cake/Controller/Controller.php line 1107 → PaginatorComponent->paginate()

<?php  * @link https://book.cakephp.org/2.0/en/controllers.html#Controller::paginate

<?php  */

<?php     public function paginate($object = null, $scope = array(), $whitelist = array()) {

<?php         return $this->Components->load('Paginator', $this->paginate)->paginate($object, $scope, $whitelist);

<?php     }

APP/Controller/Component/CcontentComponent.php line 322 → Controller->paginate()

<?php             $this->Controller->paginate = $this->Controller->{$mdl}->hook($this->Controller->currentCategory, $limit);
<?php         }
<?php 
<?php         $data = $this->Controller->paginate('Node');
<?php

APP/Controller/Component/CcontentComponent.php line 75 → CcontentComponent->getArchive()

<?php             return $data;
<?php         }
<?php 
<?php         return $this->getArchive($node_id, $limit);
<?php     }

APP/Plugin/Default/Controller/NodeController.php line 699 → CcontentComponent->getContent()

<?php         // if (!is_array($this->nodeData) || count($this->nodeData) <= 0) return $this->redirect(DOMAIN . '404.html');
<?php         if (!is_array($this->nodeData) || count($this->nodeData) <= 0) return $this->redirect(DOMAIN . '404.html');
<?php 
<?php         $this->data = $this->Ccontent->getContent($this->nodeData['Node']['type'], $this->nodeData['Node']['id']);
<?php

[internal function] → NodeController->index()

CORE/Cake/Controller/Controller.php line 499 → ReflectionMethod->invokeArgs()

<?php                     'action' => $request->params['action']

<?php                 ));

<?php             }

<?php             return $method->invokeArgs($this, $request->params['pass']);

<?php

CORE/Cake/Routing/Dispatcher.php line 193 → Controller->invokeAction()

<?php 

<?php         $response = $controller->response;

<?php         $render = true;

<?php         $result = $controller->invokeAction($request);

<?php         if ($result instanceof CakeResponse) {

CORE/Cake/Routing/Dispatcher.php line 167 → Dispatcher->_invoke()

<?php             ));

<?php         }

<?php 

<?php         $response = $this->_invoke($controller, $request);

<?php         if (isset($request->params['return'])) {

APP/webroot/index.php line 213 → Dispatcher->dispatch()

<?php 

<?php $Dispatcher = new Dispatcher();

<?php 

<?php $Dispatcher->dispatch(

<?php

(default) 19 queries took 12 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Hang`.`id`, `Hang`.`title`, `Hang`.`slug`, `Hang`.`image`, `Hang`.`description`, `Hang`.`content`, `Hang`.`website`, `Hang`.`featured`, `Hang`.`status`, `Hang`.`pos`, `Hang`.`test2`, `Hang`.`test_field` FROM `mogxvnlv_mogxvnlv`.`hangs` AS `Hang` WHERE `Hang`.`status` = 1 ORDER BY `Hang`.`pos` desc, `Hang`.`id` desc	3	3	1
2	SELECT `Lang`.`id`, `Lang`.`key`, `Lang`.`vi`, `Lang`.`en`, `Lang`.`jp`, `Lang`.`cn`, `Lang`.`kr`, `Lang`.`pos` FROM `mogxvnlv_mogxvnlv`.`langs` AS `Lang` WHERE 1 = 1	75	75	1
3	SELECT Setting.name, Setting.value FROM `mogxvnlv_mogxvnlv`.`settings` AS `Setting` WHERE 1 = 1	38	38	0
4	SELECT `Node`., `Category`. FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` INNER JOIN `mogxvnlv_mogxvnlv`.`nodes` AS `Node` ON (`Node`.`id` = `Category`.`node_id`) WHERE `Node`.`status` = 1 AND `Category`.`parent_id` IS NULL AND `Category`.`menu` = 1 ORDER BY `Node`.`pos` DESC, `Node`.`id` DESC	8	8	1
5	SELECT `Node`., `Category`. FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` INNER JOIN `mogxvnlv_mogxvnlv`.`nodes` AS `Node` ON (`Node`.`id` = `Category`.`node_id`) WHERE `Node`.`status` = 1 AND `Category`.`navbar` = 1 ORDER BY `Node`.`pos` desc, `Node`.`id` desc	0	0	1
6	SELECT `Node`., `Category`. FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` INNER JOIN `mogxvnlv_mogxvnlv`.`nodes` AS `Node` ON (`Node`.`id` = `Category`.`node_id`) WHERE `Node`.`status` = 1 AND `Category`.`sidebar` = 1 ORDER BY `Node`.`pos` desc, `Node`.`id` desc	3	3	1
7	SELECT `Node`., `Category`. FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` INNER JOIN `mogxvnlv_mogxvnlv`.`nodes` AS `Node` ON (`Node`.`id` = `Category`.`node_id`) WHERE `Node`.`status` = 1 AND `Category`.`home_menu` = 1 ORDER BY `Node`.`pos` desc, `Node`.`id` desc	5	5	1
8	SELECT `Node`., `Category`. FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` INNER JOIN `mogxvnlv_mogxvnlv`.`nodes` AS `Node` ON (`Node`.`id` = `Category`.`node_id`) WHERE `Node`.`status` = 1 AND `Category`.`dropdown` = 1 ORDER BY `Node`.`pos` desc, `Node`.`id` desc	0	0	1
9	SELECT `Node`., `Category`. FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` INNER JOIN `mogxvnlv_mogxvnlv`.`nodes` AS `Node` ON (`Node`.`id` = `Category`.`node_id`) WHERE `Node`.`status` = 1 AND `Category`.`footer_1` = 1 ORDER BY `Node`.`pos` desc, `Node`.`id` desc	3	3	1
10	SELECT `Node`., `Category`. FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` INNER JOIN `mogxvnlv_mogxvnlv`.`nodes` AS `Node` ON (`Node`.`id` = `Category`.`node_id`) WHERE `Node`.`status` = 1 AND `Category`.`footer_2` = 1 ORDER BY `Node`.`pos` desc, `Node`.`id` desc	3	3	1
11	SELECT `Node`., `Category`. FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` INNER JOIN `mogxvnlv_mogxvnlv`.`nodes` AS `Node` ON (`Node`.`id` = `Category`.`node_id`) WHERE `Node`.`status` = 1 AND `Category`.`footer_3` = 1 ORDER BY `Node`.`pos` desc, `Node`.`id` desc	4	4	1
12	SELECT `Node`., `Category`. FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` INNER JOIN `mogxvnlv_mogxvnlv`.`nodes` AS `Node` ON (`Node`.`id` = `Category`.`node_id`) WHERE `Node`.`status` = 1 AND `Category`.`footer_4` = 1 ORDER BY `Node`.`pos` desc, `Node`.`id` desc	3	3	1
13	SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`description`, `Banner`.`image`, `Banner`.`images`, `Banner`.`link`, `Banner`.`type`, `Banner`.`category_id`, `Banner`.`collection_id`, `Banner`.`pos`, `Banner`.`status` FROM `mogxvnlv_mogxvnlv`.`banners` AS `Banner` WHERE `Banner`.`status` = 1 ORDER BY `Banner`.`pos` DESC, `Banner`.`id` DESC	20	20	0
14	SELECT `Size`.* FROM `mogxvnlv_mogxvnlv`.`sizes` AS `Size` WHERE `Size`.`status` = 1 ORDER BY `Size`.`pos` desc, `Size`.`id` desc	0	0	1
15	SELECT `Color`.* FROM `mogxvnlv_mogxvnlv`.`colors` AS `Color` WHERE `Color`.`status` = 1 ORDER BY `Color`.`pos` desc, `Color`.`id` desc	0	0	0
16	SELECT `Node`.`id`, `Node`.`title`, `Node`.`slug`, `Node`.`link`, `Node`.`type`, `Node`.`pos`, `Node`.`robots`, `Node`.`views`, `Node`.`lang`, `Node`.`lang_node_id`, `Node`.`is_ai_content`, `Node`.`created`, `Node`.`modified`, `Node`.`status` FROM `mogxvnlv_mogxvnlv`.`nodes` AS `Node` WHERE `Node`.`slug` = 'hau' LIMIT 1	1	1	0
17	SELECT `Node`., `Category`. FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` INNER JOIN `mogxvnlv_mogxvnlv`.`nodes` AS `Node` ON (`Node`.`id`=`Category`.`node_id`) WHERE `Node`.`id` = 28 LIMIT 1	0	0	0
18	SELECT `Category`.`id`, `Category`.`title`, `Category`.`description`, `Category`.`page_title`, `Category`.`content`, `Category`.`node_id`, `Category`.`parent_id`, `Category`.`link`, `Category`.`image`, `Category`.`image2`, `Category`.`images`, `Category`.`lft`, `Category`.`rght`, `Category`.`seo_title`, `Category`.`seo_keyword`, `Category`.`seo_description`, `Category`.`menu`, `Category`.`sidebar`, `Category`.`footer_1`, `Category`.`footer_2`, `Category`.`footer_3`, `Category`.`footer_4`, `Category`.`ctype`, `Category`.`navbar`, `Category`.`dropdown`, `Category`.`home_menu`, `Category`.`word_count`, `Category`.`template`, `Category`.`hang_id_list`, `Category`.`filter_id_list`, `Category`.`filter_price`, `Category`.`robots` FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` WHERE `Category`.`id` IS NULL LIMIT 1	0	0	0
19	SELECT `Category`.`id`, `Category`.`title`, `Category`.`description`, `Category`.`page_title`, `Category`.`content`, `Category`.`node_id`, `Category`.`parent_id`, `Category`.`link`, `Category`.`image`, `Category`.`image2`, `Category`.`images`, `Category`.`lft`, `Category`.`rght`, `Category`.`seo_title`, `Category`.`seo_keyword`, `Category`.`seo_description`, `Category`.`menu`, `Category`.`sidebar`, `Category`.`footer_1`, `Category`.`footer_2`, `Category`.`footer_3`, `Category`.`footer_4`, `Category`.`ctype`, `Category`.`navbar`, `Category`.`dropdown`, `Category`.`home_menu`, `Category`.`word_count`, `Category`.`template`, `Category`.`hang_id_list`, `Category`.`filter_id_list`, `Category`.`filter_price`, `Category`.`robots` FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` WHERE `Category`.`lft` >= NULL AND `Category`.`rght` <= NULL	0	0	0

(default) 19 queries took 12 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Hang`.`id`, `Hang`.`title`, `Hang`.`slug`, `Hang`.`image`, `Hang`.`description`, `Hang`.`content`, `Hang`.`website`, `Hang`.`featured`, `Hang`.`status`, `Hang`.`pos`, `Hang`.`test2`, `Hang`.`test_field` FROM `mogxvnlv_mogxvnlv`.`hangs` AS `Hang` WHERE `Hang`.`status` = 1 ORDER BY `Hang`.`pos` desc, `Hang`.`id` desc

SELECT `Lang`.`id`, `Lang`.`key`, `Lang`.`vi`, `Lang`.`en`, `Lang`.`jp`, `Lang`.`cn`, `Lang`.`kr`, `Lang`.`pos` FROM `mogxvnlv_mogxvnlv`.`langs` AS `Lang` WHERE 1 = 1

SELECT Setting.name, Setting.value FROM `mogxvnlv_mogxvnlv`.`settings` AS `Setting` WHERE 1 = 1

SELECT `Node`.*, `Category`.* FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` INNER JOIN `mogxvnlv_mogxvnlv`.`nodes` AS `Node` ON (`Node`.`id` = `Category`.`node_id`) WHERE `Node`.`status` = 1 AND `Category`.`parent_id` IS NULL AND `Category`.`menu` = 1 ORDER BY `Node`.`pos` DESC, `Node`.`id` DESC

SELECT `Node`.*, `Category`.* FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` INNER JOIN `mogxvnlv_mogxvnlv`.`nodes` AS `Node` ON (`Node`.`id` = `Category`.`node_id`) WHERE `Node`.`status` = 1 AND `Category`.`navbar` = 1 ORDER BY `Node`.`pos` desc, `Node`.`id` desc

SELECT `Node`.*, `Category`.* FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` INNER JOIN `mogxvnlv_mogxvnlv`.`nodes` AS `Node` ON (`Node`.`id` = `Category`.`node_id`) WHERE `Node`.`status` = 1 AND `Category`.`sidebar` = 1 ORDER BY `Node`.`pos` desc, `Node`.`id` desc

SELECT `Node`.*, `Category`.* FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` INNER JOIN `mogxvnlv_mogxvnlv`.`nodes` AS `Node` ON (`Node`.`id` = `Category`.`node_id`) WHERE `Node`.`status` = 1 AND `Category`.`home_menu` = 1 ORDER BY `Node`.`pos` desc, `Node`.`id` desc

SELECT `Node`.*, `Category`.* FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` INNER JOIN `mogxvnlv_mogxvnlv`.`nodes` AS `Node` ON (`Node`.`id` = `Category`.`node_id`) WHERE `Node`.`status` = 1 AND `Category`.`dropdown` = 1 ORDER BY `Node`.`pos` desc, `Node`.`id` desc

SELECT `Node`.*, `Category`.* FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` INNER JOIN `mogxvnlv_mogxvnlv`.`nodes` AS `Node` ON (`Node`.`id` = `Category`.`node_id`) WHERE `Node`.`status` = 1 AND `Category`.`footer_1` = 1 ORDER BY `Node`.`pos` desc, `Node`.`id` desc

SELECT `Node`.*, `Category`.* FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` INNER JOIN `mogxvnlv_mogxvnlv`.`nodes` AS `Node` ON (`Node`.`id` = `Category`.`node_id`) WHERE `Node`.`status` = 1 AND `Category`.`footer_2` = 1 ORDER BY `Node`.`pos` desc, `Node`.`id` desc

SELECT `Node`.*, `Category`.* FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` INNER JOIN `mogxvnlv_mogxvnlv`.`nodes` AS `Node` ON (`Node`.`id` = `Category`.`node_id`) WHERE `Node`.`status` = 1 AND `Category`.`footer_3` = 1 ORDER BY `Node`.`pos` desc, `Node`.`id` desc

SELECT `Node`.*, `Category`.* FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` INNER JOIN `mogxvnlv_mogxvnlv`.`nodes` AS `Node` ON (`Node`.`id` = `Category`.`node_id`) WHERE `Node`.`status` = 1 AND `Category`.`footer_4` = 1 ORDER BY `Node`.`pos` desc, `Node`.`id` desc

SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`description`, `Banner`.`image`, `Banner`.`images`, `Banner`.`link`, `Banner`.`type`, `Banner`.`category_id`, `Banner`.`collection_id`, `Banner`.`pos`, `Banner`.`status` FROM `mogxvnlv_mogxvnlv`.`banners` AS `Banner` WHERE `Banner`.`status` = 1 ORDER BY `Banner`.`pos` DESC, `Banner`.`id` DESC

SELECT `Size`.* FROM `mogxvnlv_mogxvnlv`.`sizes` AS `Size` WHERE `Size`.`status` = 1 ORDER BY `Size`.`pos` desc, `Size`.`id` desc

SELECT `Color`.* FROM `mogxvnlv_mogxvnlv`.`colors` AS `Color` WHERE `Color`.`status` = 1 ORDER BY `Color`.`pos` desc, `Color`.`id` desc

SELECT `Node`.`id`, `Node`.`title`, `Node`.`slug`, `Node`.`link`, `Node`.`type`, `Node`.`pos`, `Node`.`robots`, `Node`.`views`, `Node`.`lang`, `Node`.`lang_node_id`, `Node`.`is_ai_content`, `Node`.`created`, `Node`.`modified`, `Node`.`status` FROM `mogxvnlv_mogxvnlv`.`nodes` AS `Node` WHERE `Node`.`slug` = 'hau' LIMIT 1

SELECT `Node`.*, `Category`.* FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` INNER JOIN `mogxvnlv_mogxvnlv`.`nodes` AS `Node` ON (`Node`.`id`=`Category`.`node_id`) WHERE `Node`.`id` = 28 LIMIT 1

SELECT `Category`.`id`, `Category`.`title`, `Category`.`description`, `Category`.`page_title`, `Category`.`content`, `Category`.`node_id`, `Category`.`parent_id`, `Category`.`link`, `Category`.`image`, `Category`.`image2`, `Category`.`images`, `Category`.`lft`, `Category`.`rght`, `Category`.`seo_title`, `Category`.`seo_keyword`, `Category`.`seo_description`, `Category`.`menu`, `Category`.`sidebar`, `Category`.`footer_1`, `Category`.`footer_2`, `Category`.`footer_3`, `Category`.`footer_4`, `Category`.`ctype`, `Category`.`navbar`, `Category`.`dropdown`, `Category`.`home_menu`, `Category`.`word_count`, `Category`.`template`, `Category`.`hang_id_list`, `Category`.`filter_id_list`, `Category`.`filter_price`, `Category`.`robots` FROM `mogxvnlv_mogxvnlv`.`categories` AS `Category` WHERE `Category`.`id` IS NULL LIMIT 1