Expression #1 of ORDER BY clause is not in SELECT list, references column 'salontocviet_vn.re.is_promoted' which is not in SELECT list; this is incompatible with DISTINCT in SELECT DISTINCT re.id AS rid, re.name AS res_name, re.logo , re.shortcut AS res_shortcut, fr.id, fr.rid, fr.name, fr.price, fr.image AS food_image FROM food_res fr, restaurant re WHERE re.object_type <> 1 AND fr.rid = re.id AND is_active = 1 ORDER BY is_promoted DESC, re.name ASC LIMIT 0, 18

array (
  0 => 
  array (
    'file' => '/data/html/salontocviet/public_html/salon/modules/ListProduct/forms/list.php',
    'line' => 150,
    'function' => 'query',
    'class' => 'DB',
    'type' => '::',
    'args' => 
    array (
      0 => 'SELECT DISTINCT re.id AS rid, re.name AS res_name, re.logo , re.shortcut AS res_shortcut, fr.id, fr.rid, fr.name, fr.price, fr.image AS food_image FROM food_res fr, restaurant re WHERE re.object_type <> 1 AND fr.rid = re.id AND is_active = 1 ORDER BY is_promoted DESC, re.name ASC LIMIT 0, 18',
    ),
  ),
  1 => 
  array (
    'file' => '/data/html/salontocviet/public_html/salon/core/Form.php',
    'line' => 187,
    'function' => 'draw',
    'class' => 'ListProductForm',
    'object' => 
    ListProductForm::__set_state(array(
       'district' => NULL,
       'name' => false,
       'error_messages' => false,
       'succes_messages' => false,
       'errNum' => 0,
    )),
    'type' => '->',
    'args' => 
    array (
    ),
  ),
  2 => 
  array (
    'file' => '/data/html/salontocviet/public_html/salon/core/Module.php',
    'line' => 27,
    'function' => 'on_draw',
    'class' => 'Form',
    'object' => 
    ListProductForm::__set_state(array(
       'district' => NULL,
       'name' => false,
       'error_messages' => false,
       'succes_messages' => false,
       'errNum' => 0,
    )),
    'type' => '->',
    'args' => 
    array (
    ),
  ),
  3 => 
  array (
    'file' => '/data/html/salontocviet/public_html/salon/core/Module.php',
    'line' => 33,
    'function' => 'draw',
    'class' => 'Module',
    'object' => 
    ListProduct::__set_state(array(
       'data' => 
      array (
        'id' => '49771',
        'module_id' => '5771',
        'region' => 'center',
        'module' => 
        array (
          'id' => '5771',
          'name' => 'ListProduct',
        ),
      ),
       'forms' => 
      array (
        0 => 
        ListProductForm::__set_state(array(
           'district' => NULL,
           'name' => false,
           'error_messages' => false,
           'succes_messages' => false,
           'errNum' => 0,
        )),
      ),
    )),
    'type' => '->',
    'args' => 
    array (
    ),
  ),
  4 => 
  array (
    'file' => '/data/html/salontocviet/public_html/salon/_cache/pages/list_product.php',
    'line' => 22,
    'function' => 'on_draw',
    'class' => 'Module',
    'object' => 
    ListProduct::__set_state(array(
       'data' => 
      array (
        'id' => '49771',
        'module_id' => '5771',
        'region' => 'center',
        'module' => 
        array (
          'id' => '5771',
          'name' => 'ListProduct',
        ),
      ),
       'forms' => 
      array (
        0 => 
        ListProductForm::__set_state(array(
           'district' => NULL,
           'name' => false,
           'error_messages' => false,
           'succes_messages' => false,
           'errNum' => 0,
        )),
      ),
    )),
    'type' => '->',
    'args' => 
    array (
    ),
  ),
  5 => 
  array (
    'file' => '/data/html/salontocviet/public_html/salon/core/EnBac.php',
    'line' => 33,
    'args' => 
    array (
      0 => '/data/html/salontocviet/public_html/salon/_cache/pages/list_product.php',
    ),
    'function' => 'require_once',
  ),
  6 => 
  array (
    'file' => '/data/html/salontocviet/public_html/salon/index.php',
    'line' => 47,
    'function' => 'Run',
    'class' => 'EnBac',
    'type' => '::',
    'args' => 
    array (
    ),
  ),
)