Unnamed

SELECT $db_tables[categories].category_id, $db_tables[categories].parent_id, $db_tables[categories].id_path, $db_tables[category_descriptions].category, $db_tables[categories].position FROM $db_tables[categories] LEFT JOIN $db_tables[category_descriptions] ON $db_tables[categories].category_id = $db_tables[category_descriptions].category_id AND $db_tables[category_descriptions].lang_code='$lang_code' $conditions", 'category_id'