SQL

DB::query
?
1
$meta_optimization = DB::query(Database::SELECT, "SELECT optimization.id, optimization_name.title, optimization_name.description, optimization_name.keywords, optimization_name.text, optimization_name.textseo FROM `optimization` LEFT JOIN `optimization_name` ON `optimization`.id=`optimization_name`.optimization_id WHERE optimization.name='".$cururl."' AND optimization_name.lang='".General::$lang."' AND optimization.visible = 1 AND optimization._status = 1;")->execute()->as_array();
DB::select
?
1
2
3
4
5
6
7
$current = DB::select($table_name.'.picture_icon', $table_name.'.picture_text', $table_name.'_name.name', $table_name.'_name.service')
              ->from($table_name)
              ->with_name()
              ->check_all()
              ->where($table_name.'.id', '=', General::$info['structure'][2]['id'])
              ->execute()
              ->as_array();