Back MENU

• Overview
• Law Reform Pipeline
• Bookshop
• Legal letters
• Rights education
• Alcohol Licensing

Back

• col-split
  • Auckland
  • CBD
  • Māngere
  • South Auckland
  • Waitematā
  • Auckland Disability Law
  • Blenheim
  • Canterbury & West Coast
  • Gisborne & Wairoa
  • Hawkes Bay
  • Māori Land
  • Manawatū
• col-split
  • Nelson Bays
  • Otago
  • Porirua Kāpiti
  • Rotorua
  • Southland
  • Taranaki
  • Tauranga & Whakatāne
  • Waikato
  • Wairarapa
  • Wellington & Hutt Valley
  • Whanganui
  • Taitokerau

Community Law
Free Legal Help throughout New Zealand

• About Us
• Hide my visit

• Free legal help
  • Free legal help
    • Overview
    • How does it work?
    • Am I eligible?
    • Who are our lawyers?
• Our Law Centres
• Resources
  • Resources
    • Overview
    • Law Reform Pipeline
    • Bookshop
    • Legal letters
    • Rights education
    • Alcohol Licensing
• |
• Law Manual Online
• Browse Topics

UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'upoko-1-te-reo-maori') WHERE ID = 44883;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'upoko-1-te-reo-maori') WHERE ID = 44112;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'upoko-1-te-reo-maori') WHERE ID = 44113;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'upoko-1-te-reo-maori') WHERE ID = 44114;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'upoko-1-te-reo-maori') WHERE ID = 44115;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-1-te-reo-maori-in-english') WHERE ID = 44885;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-1-te-reo-maori-in-english') WHERE ID = 44116;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-1-te-reo-maori-in-english') WHERE ID = 44117;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-1-te-reo-maori-in-english') WHERE ID = 44118;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-1-te-reo-maori-in-english') WHERE ID = 44119;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44889;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44120;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44121;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44122;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44123;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44124;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44125;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44126;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44127;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44128;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44129;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44130;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44131;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44132;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44133;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44134;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44135;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44136;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44137;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44138;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44139;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44140;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44141;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44142;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44143;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44144;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44145;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44146;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44147;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44148;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44149;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44150;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44151;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44152;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44153;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44154;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44155;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44156;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44157;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-2-maori-land') WHERE ID = 44158;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-3-dealing-with-government-agencies') WHERE ID = 44894;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-3-dealing-with-government-agencies') WHERE ID = 44159;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-3-dealing-with-government-agencies') WHERE ID = 44160;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-3-dealing-with-government-agencies') WHERE ID = 44161;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-3-dealing-with-government-agencies') WHERE ID = 44162;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-3-dealing-with-government-agencies') WHERE ID = 44163;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-3-dealing-with-government-agencies') WHERE ID = 44164;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-3-dealing-with-government-agencies') WHERE ID = 44165;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-3-dealing-with-government-agencies') WHERE ID = 44166;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-3-dealing-with-government-agencies') WHERE ID = 44167;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44896;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44168;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44169;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44170;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44171;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44172;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44173;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44174;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44175;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44176;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44177;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44178;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44179;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44180;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44181;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44182;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44183;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44184;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44185;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44186;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-4-activism') WHERE ID = 44187;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-5-legal-aid-and-other-legal-help') WHERE ID = 44898;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-5-legal-aid-and-other-legal-help') WHERE ID = 44188;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-5-legal-aid-and-other-legal-help') WHERE ID = 44189;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-5-legal-aid-and-other-legal-help') WHERE ID = 44190;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-5-legal-aid-and-other-legal-help') WHERE ID = 44191;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-5-legal-aid-and-other-legal-help') WHERE ID = 44192;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-5-legal-aid-and-other-legal-help') WHERE ID = 44193;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-5-legal-aid-and-other-legal-help') WHERE ID = 44194;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-5-legal-aid-and-other-legal-help') WHERE ID = 44195;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-5-legal-aid-and-other-legal-help') WHERE ID = 44196;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-5-legal-aid-and-other-legal-help') WHERE ID = 44197;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-5-legal-aid-and-other-legal-help') WHERE ID = 44198;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-5-legal-aid-and-other-legal-help') WHERE ID = 44199;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-5-legal-aid-and-other-legal-help') WHERE ID = 44200;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-5-legal-aid-and-other-legal-help') WHERE ID = 44201;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-6-the-disputes-tribunal') WHERE ID = 44900;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-6-the-disputes-tribunal') WHERE ID = 44202;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-6-the-disputes-tribunal') WHERE ID = 44203;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-6-the-disputes-tribunal') WHERE ID = 44204;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-6-the-disputes-tribunal') WHERE ID = 44205;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-6-the-disputes-tribunal') WHERE ID = 44206;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-6-the-disputes-tribunal') WHERE ID = 44207;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-6-the-disputes-tribunal') WHERE ID = 44208;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-6-the-disputes-tribunal') WHERE ID = 44209;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-6-the-disputes-tribunal') WHERE ID = 44210;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-6-the-disputes-tribunal') WHERE ID = 44211;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-6-the-disputes-tribunal') WHERE ID = 44212;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-6-the-disputes-tribunal') WHERE ID = 44213;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-6-the-disputes-tribunal') WHERE ID = 44214;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-7-discrimination') WHERE ID = 44902;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-7-discrimination') WHERE ID = 44215;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-7-discrimination') WHERE ID = 44216;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-7-discrimination') WHERE ID = 44217;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-7-discrimination') WHERE ID = 44218;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-7-discrimination') WHERE ID = 44219;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-7-discrimination') WHERE ID = 44220;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-7-discrimination') WHERE ID = 44221;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-7-discrimination') WHERE ID = 44222;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-7-discrimination') WHERE ID = 44223;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-7-discrimination') WHERE ID = 44224;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-7-discrimination') WHERE ID = 44225;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-7-discrimination') WHERE ID = 44226;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-7-discrimination') WHERE ID = 44227;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-7-discrimination') WHERE ID = 44228;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-7-discrimination') WHERE ID = 44229;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-7-discrimination') WHERE ID = 44230;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-8-gender-and-sexuality') WHERE ID = 44904;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-8-gender-and-sexuality') WHERE ID = 44231;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-8-gender-and-sexuality') WHERE ID = 49887;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-8-gender-and-sexuality') WHERE ID = 49890;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-8-gender-and-sexuality') WHERE ID = 49892;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-8-gender-and-sexuality') WHERE ID = 49894;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-8-gender-and-sexuality') WHERE ID = 49898;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-8-gender-and-sexuality') WHERE ID = 44236;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-8-gender-and-sexuality') WHERE ID = 44237;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-8-gender-and-sexuality') WHERE ID = 44238;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-8-gender-and-sexuality') WHERE ID = 44240;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-8-gender-and-sexuality') WHERE ID = 44242;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-8-gender-and-sexuality') WHERE ID = 44243;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-8-gender-and-sexuality') WHERE ID = 49906;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-8-gender-and-sexuality') WHERE ID = 49907;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-9-privacy-and-information') WHERE ID = 44906;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-8-gender-and-sexuality') WHERE ID = 44246;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-9-privacy-and-information') WHERE ID = 44247;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-9-privacy-and-information') WHERE ID = 44248;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-9-privacy-and-information') WHERE ID = 44249;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-9-privacy-and-information') WHERE ID = 44250;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-9-privacy-and-information') WHERE ID = 44251;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-9-privacy-and-information') WHERE ID = 44252;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-9-privacy-and-information') WHERE ID = 44253;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-9-privacy-and-information') WHERE ID = 44254;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-9-privacy-and-information') WHERE ID = 44255;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-9-privacy-and-information') WHERE ID = 44256;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-10-decision-making-and-powers-of-attorney') WHERE ID = 44907;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-10-decision-making-and-powers-of-attorney') WHERE ID = 44257;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-10-decision-making-and-powers-of-attorney') WHERE ID = 44258;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-10-decision-making-and-powers-of-attorney') WHERE ID = 44259;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-10-decision-making-and-powers-of-attorney') WHERE ID = 44260;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-10-decision-making-and-powers-of-attorney') WHERE ID = 44261;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-10-decision-making-and-powers-of-attorney') WHERE ID = 44262;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-10-decision-making-and-powers-of-attorney') WHERE ID = 44263;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-10-decision-making-and-powers-of-attorney') WHERE ID = 44264;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-10-decision-making-and-powers-of-attorney') WHERE ID = 44265;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-10-decision-making-and-powers-of-attorney') WHERE ID = 44266;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-10-decision-making-and-powers-of-attorney') WHERE ID = 44267;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-10-decision-making-and-powers-of-attorney') WHERE ID = 44268;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-10-decision-making-and-powers-of-attorney') WHERE ID = 44269;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-10-decision-making-and-powers-of-attorney') WHERE ID = 45415;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-10-decision-making-and-powers-of-attorney') WHERE ID = 44270;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-11-wills') WHERE ID = 44909;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-11-wills') WHERE ID = 44271;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-11-wills') WHERE ID = 44272;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-11-wills') WHERE ID = 44273;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-11-wills') WHERE ID = 44274;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-11-wills') WHERE ID = 44275;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-11-wills') WHERE ID = 44276;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-11-wills') WHERE ID = 44277;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-11-wills') WHERE ID = 44278;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-11-wills') WHERE ID = 44279;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-11-wills') WHERE ID = 44280;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-11-wills') WHERE ID = 44281;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-11-wills') WHERE ID = 44282;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-11-wills') WHERE ID = 44283;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-11-wills') WHERE ID = 44284;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44911;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44285;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44286;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44287;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44288;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44289;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44290;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44291;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44292;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44293;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44294;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44295;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44296;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44297;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44298;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44299;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44300;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44301;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44302;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44303;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-12-relationships-and-break-ups') WHERE ID = 44304;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44913;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44305;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44306;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44307;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44308;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44309;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44310;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44311;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44312;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44313;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44314;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44315;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44316;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44317;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44318;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44319;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44320;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44321;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44322;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44323;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44324;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44325;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44326;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44327;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-13-dealing-with-oranga-tamariki-ministry-for-children') WHERE ID = 44328;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44914;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44334;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44335;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44336;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44337;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44338;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44329;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44331;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44332;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44333;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 46364;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44339;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44340;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44341;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44351;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44352;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44353;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44354;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44355;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44356;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44357;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44358;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44359;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44360;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44361;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44362;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44363;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44364;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44342;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44343;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44344;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44347;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44345;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44346;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44348;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44349;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44350;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 46388;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-14-parents-guardians-and-caregivers') WHERE ID = 44365;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44916;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44366;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44367;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44368;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44369;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44370;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44371;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44372;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44373;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44374;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44375;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44376;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44377;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44378;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44379;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44380;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44381;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44382;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44383;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44384;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44385;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44386;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44387;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44388;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44389;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44390;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44391;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44392;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44393;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44394;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44395;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44396;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44397;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-15-family-violence-and-elder-abuse') WHERE ID = 44398;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44918;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44399;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44400;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44401;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44402;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44403;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44404;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44405;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44406;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44407;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44408;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44409;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44410;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44411;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44412;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44413;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44414;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44415;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44416;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44417;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44418;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44419;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44420;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44421;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 44422;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44921;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44423;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44424;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44425;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44426;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-16-a-death-in-the-family') WHERE ID = 45186;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44427;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44428;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44429;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44430;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44431;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44432;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44433;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44434;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44435;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44436;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44437;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44438;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44439;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44440;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44441;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44442;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44443;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44444;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44445;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44446;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44447;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44448;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44449;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44450;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44451;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44452;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44453;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44454;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44455;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44456;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44457;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44458;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44459;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-17-disability-rights') WHERE ID = 44460;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44924;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44461;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44462;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44463;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44464;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44465;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44466;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44467;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44468;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44469;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44470;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44471;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44472;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44473;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44474;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44475;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44476;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44477;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44478;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44479;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-18-mental-health') WHERE ID = 44480;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44926;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44481;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44482;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44483;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44484;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44485;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44486;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44487;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44488;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44489;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44490;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44491;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44492;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44493;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44494;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44495;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44496;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44497;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44498;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44499;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44500;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44501;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44502;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44503;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-19-accident-compensation-acc') WHERE ID = 44504;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44928;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44506;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44507;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44508;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44509;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44510;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44511;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44512;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44513;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44514;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44515;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44516;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44517;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44518;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44519;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44520;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44521;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44522;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44523;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44524;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44525;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44526;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44527;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44528;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44529;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44530;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44531;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44532;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44533;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44534;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44535;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44536;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-20-starting-and-leaving-a-job') WHERE ID = 44537;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44930;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44538;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44539;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44540;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44541;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44542;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44543;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44544;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44545;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44546;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44547;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44548;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44549;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44550;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44551;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44552;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44553;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44554;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44555;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44556;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44557;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44558;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44559;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44560;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44561;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44562;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44563;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44564;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44565;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44566;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 45495;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44567;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-21-employment-conditions-and-protections') WHERE ID = 44568;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44932;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44569;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44570;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44571;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44572;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44573;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44574;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44575;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44576;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44577;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44578;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44579;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44580;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44581;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44582;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44583;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44584;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44585;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44586;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44587;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-22-resolving-employment-problems') WHERE ID = 44588;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44934;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44589;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44590;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44591;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44592;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44593;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44594;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44595;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44596;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44597;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44598;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44599;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44600;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44601;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44602;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44603;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44604;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44605;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44606;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44607;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44608;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44609;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44610;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44611;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44612;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44613;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44614;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44615;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44616;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44617;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44618;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-23-dealing-with-work-and-income') WHERE ID = 44619;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44936;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44620;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44621;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44622;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44623;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44624;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44625;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44626;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44627;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44628;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44629;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44630;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44631;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44632;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44633;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44634;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44636;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44635;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44637;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44638;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44639;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44640;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44641;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44642;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44643;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44644;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44645;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44646;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44647;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44648;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44649;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-24-tenancy-and-housing') WHERE ID = 44650;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44939;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44651;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44652;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44653;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44654;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44655;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44656;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44657;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44658;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44659;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44660;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44661;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44662;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44663;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44664;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44665;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44666;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44667;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44668;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44669;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44670;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44671;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-25-consumer-protection') WHERE ID = 44672;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44941;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44673;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44674;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44675;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44676;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44677;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44678;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44679;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44680;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44681;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44682;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44683;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44684;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44685;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44686;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44687;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 45182;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44688;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44689;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44690;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44691;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44692;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44693;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44694;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44695;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44696;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44697;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44698;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44699;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44700;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-26-credit-and-debt') WHERE ID = 44701;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-27-neighbourhood-life') WHERE ID = 44944;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-27-neighbourhood-life') WHERE ID = 44702;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-27-neighbourhood-life') WHERE ID = 44703;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-27-neighbourhood-life') WHERE ID = 44704;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-27-neighbourhood-life') WHERE ID = 44705;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-27-neighbourhood-life') WHERE ID = 44706;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-27-neighbourhood-life') WHERE ID = 44707;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-27-neighbourhood-life') WHERE ID = 44708;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-27-neighbourhood-life') WHERE ID = 44709;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-27-neighbourhood-life') WHERE ID = 44710;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-27-neighbourhood-life') WHERE ID = 44711;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44946;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44712;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44713;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44714;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44715;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44716;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44717;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44718;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44719;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44720;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44721;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44722;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44723;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44724;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44725;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44726;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44727;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44728;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44729;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44730;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-28-harassment-and-bullying') WHERE ID = 44731;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44949;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44732;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44733;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44734;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44735;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44736;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44737;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44738;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44739;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44740;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44741;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44742;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44743;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44744;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44745;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44746;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44747;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44748;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 45190;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44749;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44750;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44751;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44752;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44753;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44754;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44755;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44756;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44757;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44758;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44759;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44760;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-29-immigration') WHERE ID = 44761;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-30-refugees') WHERE ID = 44951;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-30-refugees') WHERE ID = 44762;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-30-refugees') WHERE ID = 44763;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-30-refugees') WHERE ID = 44764;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-30-refugees') WHERE ID = 44765;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-30-refugees') WHERE ID = 44766;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-30-refugees') WHERE ID = 44767;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-30-refugees') WHERE ID = 44768;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-30-refugees') WHERE ID = 44769;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-30-refugees') WHERE ID = 44770;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44953;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44771;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44772;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44773;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44774;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44775;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44776;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44777;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44778;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44779;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44780;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44781;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44782;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44783;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44784;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44785;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44786;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44787;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44788;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44789;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44790;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44791;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44792;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-31-police-powers') WHERE ID = 44793;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44956;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44794;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44795;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44796;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44797;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44798;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44799;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44800;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44801;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44802;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44803;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44804;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44805;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44806;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44807;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44808;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44809;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44810;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44811;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44812;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44813;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44814;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44815;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44816;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44817;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44818;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44819;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44820;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44821;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44822;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44823;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44824;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44825;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44826;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44827;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44828;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44829;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-32-driving-and-traffic-law') WHERE ID = 44830;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44958;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44831;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44832;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44833;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44834;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44835;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44836;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44837;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44838;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44839;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44840;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44841;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44842;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44843;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44844;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44845;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44846;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44847;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44848;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44849;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44850;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44851;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44852;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44853;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44854;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44855;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44856;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44857;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44858;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44859;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44860;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44861;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-33-the-criminal-courts') WHERE ID = 44862;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-34-common-crimes') WHERE ID = 44960;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-34-common-crimes') WHERE ID = 44863;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-34-common-crimes') WHERE ID = 44864;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-34-common-crimes') WHERE ID = 44865;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-34-common-crimes') WHERE ID = 44866;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-34-common-crimes') WHERE ID = 44867;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-34-common-crimes') WHERE ID = 44868;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-34-common-crimes') WHERE ID = 44869;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-34-common-crimes') WHERE ID = 44870;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-34-common-crimes') WHERE ID = 44871;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-34-common-crimes') WHERE ID = 44872;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-34-common-crimes') WHERE ID = 44875;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-34-common-crimes') WHERE ID = 44876;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-34-common-crimes') WHERE ID = 44873;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-34-common-crimes') WHERE ID = 44874;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-34-common-crimes') WHERE ID = 44877;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-34-common-crimes') WHERE ID = 44878;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-34-common-crimes') WHERE ID = 44879;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'chapter-34-common-crimes') WHERE ID = 44880;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-1-before-prison-the-criminal-court-process') WHERE ID = 48633;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-1-before-prison-the-criminal-court-process') WHERE ID = 48634;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-1-before-prison-the-criminal-court-process') WHERE ID = 48635;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-1-before-prison-the-criminal-court-process') WHERE ID = 48636;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-1-before-prison-the-criminal-court-process') WHERE ID = 49104;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-1-before-prison-the-criminal-court-process') WHERE ID = 48638;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-1-before-prison-the-criminal-court-process') WHERE ID = 48637;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-1-before-prison-the-criminal-court-process') WHERE ID = 48639;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-1-before-prison-the-criminal-court-process') WHERE ID = 48640;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-1-before-prison-the-criminal-court-process') WHERE ID = 48641;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-1-before-prison-the-criminal-court-process') WHERE ID = 48642;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-1-before-prison-the-criminal-court-process') WHERE ID = 48643;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-1-before-prison-the-criminal-court-process') WHERE ID = 48644;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-1-before-prison-the-criminal-court-process') WHERE ID = 48645;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-2-housing-and-debt') WHERE ID = 48646;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-2-housing-and-debt') WHERE ID = 48647;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-2-housing-and-debt') WHERE ID = 48648;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-2-housing-and-debt') WHERE ID = 48649;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-2-housing-and-debt') WHERE ID = 48650;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-2-housing-and-debt') WHERE ID = 48652;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-2-housing-and-debt') WHERE ID = 48651;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-3-family-matters') WHERE ID = 48653;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-3-family-matters') WHERE ID = 48654;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-3-family-matters') WHERE ID = 48655;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-3-family-matters') WHERE ID = 48656;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-3-family-matters') WHERE ID = 48657;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-3-family-matters') WHERE ID = 48658;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-3-family-matters') WHERE ID = 48659;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-3-family-matters') WHERE ID = 48660;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-4-starting-your-sentence') WHERE ID = 48661;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-4-starting-your-sentence') WHERE ID = 48662;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-4-starting-your-sentence') WHERE ID = 48663;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-4-starting-your-sentence') WHERE ID = 48664;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-4-starting-your-sentence') WHERE ID = 48665;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-4-starting-your-sentence') WHERE ID = 48666;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-4-starting-your-sentence') WHERE ID = 48667;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-4-starting-your-sentence') WHERE ID = 48668;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-4-starting-your-sentence') WHERE ID = 48669;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-4-starting-your-sentence') WHERE ID = 48670;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-4-starting-your-sentence') WHERE ID = 48671;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-4-starting-your-sentence') WHERE ID = 48672;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-4-starting-your-sentence') WHERE ID = 48673;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-4-starting-your-sentence') WHERE ID = 48674;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-5-working-studying-and-other-activities-on-the-inside') WHERE ID = 48675;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-5-working-studying-and-other-activities-on-the-inside') WHERE ID = 48676;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-5-working-studying-and-other-activities-on-the-inside') WHERE ID = 48677;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-5-working-studying-and-other-activities-on-the-inside') WHERE ID = 48678;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-5-working-studying-and-other-activities-on-the-inside') WHERE ID = 48679;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-5-working-studying-and-other-activities-on-the-inside') WHERE ID = 48680;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-5-working-studying-and-other-activities-on-the-inside') WHERE ID = 48681;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-6-visits-phone-calls-and-mail-communicating-with-people-outside-prison') WHERE ID = 48682;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-6-visits-phone-calls-and-mail-communicating-with-people-outside-prison') WHERE ID = 48683;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-6-visits-phone-calls-and-mail-communicating-with-people-outside-prison') WHERE ID = 48684;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-6-visits-phone-calls-and-mail-communicating-with-people-outside-prison') WHERE ID = 48685;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-7-health-and-disability') WHERE ID = 48686;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-7-health-and-disability') WHERE ID = 48687;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-7-health-and-disability') WHERE ID = 48688;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-7-health-and-disability') WHERE ID = 49119;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-7-health-and-disability') WHERE ID = 49121;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-7-health-and-disability') WHERE ID = 48690;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-7-health-and-disability') WHERE ID = 48691;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-7-health-and-disability') WHERE ID = 48692;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-8-discipline-and-punishments-inside-prison') WHERE ID = 48693;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-8-discipline-and-punishments-inside-prison') WHERE ID = 48694;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-8-discipline-and-punishments-inside-prison') WHERE ID = 48695;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-8-discipline-and-punishments-inside-prison') WHERE ID = 48696;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-8-discipline-and-punishments-inside-prison') WHERE ID = 48697;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-8-discipline-and-punishments-inside-prison') WHERE ID = 48698;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-8-discipline-and-punishments-inside-prison') WHERE ID = 48699;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-9-making-complaints-about-your-treatment') WHERE ID = 48700;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-9-making-complaints-about-your-treatment') WHERE ID = 48701;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-9-making-complaints-about-your-treatment') WHERE ID = 48702;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-9-making-complaints-about-your-treatment') WHERE ID = 48703;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-9-making-complaints-about-your-treatment') WHERE ID = 48704;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-9-making-complaints-about-your-treatment') WHERE ID = 48705;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-9-making-complaints-about-your-treatment') WHERE ID = 48706;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-10-transfers') WHERE ID = 48707;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-10-transfers') WHERE ID = 48708;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-10-transfers') WHERE ID = 48709;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-10-transfers') WHERE ID = 48710;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-11-release-from-prison') WHERE ID = 48711;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-11-release-from-prison') WHERE ID = 48712;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-11-release-from-prison') WHERE ID = 48713;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-11-release-from-prison') WHERE ID = 48714;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-11-release-from-prison') WHERE ID = 48715;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-11-release-from-prison') WHERE ID = 48716;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-11-release-from-prison') WHERE ID = 48717;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-11-release-from-prison') WHERE ID = 48718;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-11-release-from-prison') WHERE ID = 48719;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-11-release-from-prison') WHERE ID = 48720;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-12-support') WHERE ID = 48721;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-12-support') WHERE ID = 48722;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-12-support') WHERE ID = 48723;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'prisoners-rights-chapter-12-support') WHERE ID = 48724;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-1-te-tiriti-o-waitangi-in-schools') WHERE ID = 49318;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-1-te-tiriti-o-waitangi-in-schools') WHERE ID = 49360;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-1-te-tiriti-o-waitangi-in-schools') WHERE ID = 49359;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-2-enrolment-attendance-and-the-school-system') WHERE ID = 49319;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-2-enrolment-attendance-and-the-school-system') WHERE ID = 48856;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-2-enrolment-attendance-and-the-school-system') WHERE ID = 48857;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-2-enrolment-attendance-and-the-school-system') WHERE ID = 49320;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-2-enrolment-attendance-and-the-school-system') WHERE ID = 49321;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-2-enrolment-attendance-and-the-school-system') WHERE ID = 49322;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-2-enrolment-attendance-and-the-school-system') WHERE ID = 49323;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-2-enrolment-attendance-and-the-school-system') WHERE ID = 48859;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-2-enrolment-attendance-and-the-school-system') WHERE ID = 48860;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-2-enrolment-attendance-and-the-school-system') WHERE ID = 48858;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-3-school-governance-and-management') WHERE ID = 48861;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-3-school-governance-and-management') WHERE ID = 48862;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-3-school-governance-and-management') WHERE ID = 49325;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-3-school-governance-and-management') WHERE ID = 49326;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-4-health-safety-and-wellbeing') WHERE ID = 49327;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-4-health-safety-and-wellbeing') WHERE ID = 49328;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-4-health-safety-and-wellbeing') WHERE ID = 49329;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-4-health-safety-and-wellbeing') WHERE ID = 48868;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-4-health-safety-and-wellbeing') WHERE ID = 49330;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-4-health-safety-and-wellbeing') WHERE ID = 49331;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-4-health-safety-and-wellbeing') WHERE ID = 48871;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-4-health-safety-and-wellbeing') WHERE ID = 48872;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-5-discipline-and-rules') WHERE ID = 49332;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-5-discipline-and-rules') WHERE ID = 49333;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-5-discipline-and-rules') WHERE ID = 49334;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-5-discipline-and-rules') WHERE ID = 49335;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-5-discipline-and-rules') WHERE ID = 49336;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-5-discipline-and-rules') WHERE ID = 49337;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-5-discipline-and-rules') WHERE ID = 49338;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-5-discipline-and-rules') WHERE ID = 49339;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-5-discipline-and-rules') WHERE ID = 49340;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-6-stand-downs-suspensions-exclusions-and-expulsions') WHERE ID = 49341;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-6-stand-downs-suspensions-exclusions-and-expulsions') WHERE ID = 49342;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-6-stand-downs-suspensions-exclusions-and-expulsions') WHERE ID = 49343;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-6-stand-downs-suspensions-exclusions-and-expulsions') WHERE ID = 49344;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-6-stand-downs-suspensions-exclusions-and-expulsions') WHERE ID = 49345;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-6-stand-downs-suspensions-exclusions-and-expulsions') WHERE ID = 49346;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-6-stand-downs-suspensions-exclusions-and-expulsions') WHERE ID = 49347;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-6-stand-downs-suspensions-exclusions-and-expulsions') WHERE ID = 49348;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-7-information-and-privacy') WHERE ID = 49349;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-7-information-and-privacy') WHERE ID = 49350;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-7-information-and-privacy') WHERE ID = 49351;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-8-whanau-and-schools') WHERE ID = 49352;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-8-whanau-and-schools') WHERE ID = 49353;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-8-whanau-and-schools') WHERE ID = 49354;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-9-raising-concerns-and-making-complaints') WHERE ID = 49355;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-9-raising-concerns-and-making-complaints') WHERE ID = 49356;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-9-raising-concerns-and-making-complaints') WHERE ID = 49357;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'schools-kura-chapter-9-raising-concerns-and-making-complaints') WHERE ID = 49358;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48576;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48577;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48578;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48579;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48580;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48581;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48582;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48583;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48584;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48585;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48586;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48587;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48846;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48588;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48589;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48590;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48591;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48592;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48593;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48594;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48595;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48596;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48597;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48598;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48599;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48848;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48850;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48600;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'pregnancy-rights') WHERE ID = 48601;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'disaster-relief') WHERE ID = 49822;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'disaster-relief') WHERE ID = 49812;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'disaster-relief') WHERE ID = 49817;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'disaster-relief') WHERE ID = 49824;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'disaster-relief') WHERE ID = 49827;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'disaster-relief') WHERE ID = 49829;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'disaster-relief') WHERE ID = 50004;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'disaster-relief') WHERE ID = 49833;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'disaster-relief') WHERE ID = 50006;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'disaster-relief') WHERE ID = 50029;
UPDATE `wp_posts` SET guid = REPLACE(guid, 'not-rated', 'disaster-relief') WHERE ID = 50009;

• Our Local centres - (Overview)

  • Auckland
  • – CBD
  • – Māngere
  • – South Auckland
  • – Waitematā
  • Auckland Disability Law
  • Blenheim
  • Canterbury & West Coast
  • Gisborne & Wairoa
  • Hawkes Bay
  • Manawatū
  • Māori Land
  • Nelson Bays
  • Otago
  • Porirua Kāpiti
  • Rotorua
  • Taitokerau
  • Taranaki
  • Tauranga & Whakatāne
  • Southland
  • Waikato
  • Wairarapa
  • Wellington & Hutt Valley
  • Whanganui

  Specialist centres

  • Auckland Disability Law
  • Māori Land
  • Youthlaw

• Donate
  to the manual

  Law Manual Online

  • Community life
  • Consumer rights & money
  • Criminal & traffic law
  • Family law
  • Government & legal system
  • Health & disability
  • Immigration & refugees
  • Individual rights & freedoms
  • Jobs, benefits & flats
  • Prisoner's rights
  • Schools & kura
  • Taonga Māori
  • Disaster Relief

back to top