Likouté Moharane - Enseignement n°247

Likouté Kama - Enseignement n°247

רמז - "תיקו" - הוא בחינת מחסר תקון

אִיתָא בַּזּהַר הַקָּדוֹשׁ (רַעֲיָא מְהֵימְנָא צַו כ"ז:) : שֶׁ "תֵּיקוּ" הַנֶּאֱמַר בַּשַּׁ"ס הוּא בְּחִינַת מְחֻסַּר תִּקּוּן דְּהַיְנוּ שֶׁנֶּחְסָר הַנּוּן שֶׁל תִּיקּוּן וְנַעֲשֶׂה תֵּיקוּ וְדַע שֶׁ זּאת הַנּוּן פְּשׁוּטָה כְּשֶׁנֶּחְסֶרֶת מֵהַתִּיקּוּן וְנַעֲשֶׂה בְּחִינַת תֵּיקוּ כַּנַּ"ל אֲזַי הִיא נִשְׁפֶּלֶת וְנִכְפֶּפֶת וְנַעֲשֶׂה מִזֶּה בְּחִינַת קִינוֹת שֶׁהוּא אוֹתִיּוֹת תִּיקּוּן, רַק שֶׁהַנּוּן נִכְפֶּפֶת כַּנַּ"ל ה יִגְאָלֵנוּ וְיִתְהַפְּכוּ הַקִּינוֹת לְתִּיקּוּן, וְיִתְתַּקֵּן הַתֵּיקוּ הַנַּ"ל

Soyez le premier à commenter ce cours !

04-08-2026 03:01 | 0.1594s | 4.54Mo | PAGE 57 | VILLE 197799 | MYSQL:321 | URL:0

209 => SELECT source_fichier FROM moussar_fichier WHERE id_article = :id_article AND SUBSTRING_INDEX(source_fichier, '.', -1) = 'pdf' LIMIT 1

103 => SELECT c.*, a.*, (SELECT COUNT(*) FROM moussar_chapitre WHERE id_parent = c.id_chapitre) as sous_chapitre, (SELECT MIN(numero_chapitre) FROM moussar_chapitre WHERE id_livre = c.id_livre) as min_numero_chapitre, IF(c.id_parent > 0, (SELECT nom_chapitre FROM moussar_chapitre WHERE id_chapitre = c.id_parent), null) as nom_chapitre_parent, IF(c.id_parent > 0, (SELECT numero_chapitre FROM moussar_chapitre WHERE id_chapitre = c.id_parent), null) as numero_chapitre_parent FROM moussar_chapitre c LEFT JOIN moussar_livre a ON a.id_livre = c.id_livre WHERE c.active = 1 AND c.id_chapitre = '6205' ORDER BY c.numero_chapitre ASC

1 => SELECT a.*, b.pays_id FROM torahboxbeta.ville a LEFT JOIN torahboxbeta.pays b ON b.pays_iso2 = a.pays_iso_ville WHERE a.id_ville = :id_ville LIMIT 1

1 => SELECT id_dedicace as id, description_dedicace as texte FROM dedicace WHERE id_table = :id_table AND active = 1 AND ((date_debut = :date AND date_fin = '0000-00-00') OR (:date BETWEEN date_debut AND date_fin)) LIMIT 1

1 => SELECT a.*, (SELECT COUNT(*) FROM moussar_chapitre WHERE id_livre = a.id_livre AND id_parent > 0) as sous_chapitre, (SELECT DATE(MAX(time_upd)) FROM moussar_chapitre WHERE id_livre = a.id_livre) as max_time_upd FROM moussar_livre a WHERE a.active = 1 AND a.date_pub <= CURRENT_DATE AND a.alias_livre = 'likoute-moharane' ORDER BY a.date_pub DESC, a.nom_livre ASC

1 => SELECT c.*, a.*, (SELECT COUNT(*) FROM moussar_chapitre WHERE id_parent = c.id_chapitre) as sous_chapitre, (SELECT MIN(numero_chapitre) FROM moussar_chapitre WHERE id_livre = c.id_livre) as min_numero_chapitre, IF(c.id_parent > 0, (SELECT nom_chapitre FROM moussar_chapitre WHERE id_chapitre = c.id_parent), null) as nom_chapitre_parent, IF(c.id_parent > 0, (SELECT numero_chapitre FROM moussar_chapitre WHERE id_chapitre = c.id_parent), null) as numero_chapitre_parent FROM moussar_chapitre c LEFT JOIN moussar_livre a ON a.id_livre = c.id_livre WHERE c.active = 1 AND c.id_livre = '83' AND c.id_parent = '0' ORDER BY c.numero_chapitre ASC

1 => SELECT a.id_categorie, a.id_parent, a.nom_categorie, (SELECT COUNT(*) FROM moussar_categorie b WHERE b.id_parent = a.id_categorie) as count_children FROM moussar_categorie a WHERE a.id_parent = :id_parent ORDER BY a.id_categorie ASC

1 => SELECT a.*, (SELECT taille_fichier FROM moussar_fichier WHERE id_article = a.id_article AND source_fichier = replace(a.source_fichier,'.mp4','.mp3')) as taille_fichier_mp3 FROM moussar_fichier a WHERE a.id_article = :id_article AND SUBSTRING_INDEX(a.source_fichier, '.', -1) = 'mp4' ORDER BY a.id_fichier ASC