Warning: Trying to access array offset on value of type null in C:\Apache24\htdocs\assets\routes-old\get_tags.php on line 4
Warning: Undefined variable $profileid in C:\Apache24\htdocs\assets\routes-old\get_tags.php on line 86
[{"Message":"Error found...","error":{},"profileid":null,"sql_":"select aa.id,aa.page_name,aa.TagName1 as TagName,aa.Tag,aa.Tag_count, @counter1 := @counter1 + 1 AS counter from\r\n (\r\n select a.id, a.page_name, a.TagName1, a.Tag1 as Tag, count(a.Tag1) as Tag_count from\r\n (\r\n select pg.id, pg.page_name, p.Tag1, pg.TagName1 from\r\n pages pg, posts p\r\n where pg.id = and\r\n p.page_id = pg.id and \r\n pg.TagName1 <> '' and \r\n pg.TagChoice1_1 <> '') a\r\n group by a.id, a.page_name, a.Tag1) aa\r\n CROSS JOIN (SELECT @counter1 := 0) AS init\r\n union\r\n select aa.id,aa.page_name,aa.TagName2 as TagName,aa.Tag,aa.Tag_count, @counter2 := @counter2 + 1 AS counter from\r\n (\r\n select a.id, a.page_name, a.TagName2, a.Tag2 as Tag, count(a.Tag2) as Tag_count from\r\n (\r\n select pg.id, pg.page_name, p.Tag2, pg.TagName2 from\r\n pages pg, posts p\r\n where pg.id = and\r\n p.page_id = pg.id and \r\n pg.TagName2 <> '' and \r\n pg.TagChoice2_1 <> '') a\r\n group by a.id, a.page_name, a.Tag2) aa\r\n CROSS JOIN (SELECT @counter2 := 0) AS init\r\n union\r\n select aa.id,aa.page_name,aa.TagName3 as TagName,aa.Tag,aa.Tag_count, @counter3 := @counter3 + 1 AS counter from\r\n (\r\n select a.id, a.page_name, a.TagName3, a.Tag3 as Tag, count(a.Tag3) as Tag_count from\r\n (\r\n select pg.id, pg.page_name, p.Tag3, pg.TagName3 from\r\n pages pg, posts p\r\n where pg.id = and\r\n p.page_id = pg.id and \r\n pg.TagName3 <> '' and \r\n pg.TagChoice3_1 <> '') a\r\n group by a.id, a.page_name, a.Tag3) aa\r\n CROSS JOIN (SELECT @counter3 := 0) AS init\r\n union\r\n select aa.id,aa.page_name,aa.TagName4 as TagName,aa.Tag,aa.Tag_count, @counter4 := @counter4 + 1 AS counter from\r\n (\r\n select a.id, a.page_name, a.TagName4, a.Tag4 as Tag, count(a.Tag4) as Tag_count from\r\n (\r\n select pg.id, pg.page_name, p.Tag4, pg.TagName4 from\r\n pages pg, posts p\r\n where pg.id = and\r\n p.page_id = pg.id and \r\n pg.TagName4 <> '' and \r\n pg.TagChoice4_1 <> '') a\r\n group by a.id, a.page_name, a.Tag4) aa\r\n CROSS JOIN (SELECT @counter4 := 0) AS init\r\n union\r\n select aa.id,aa.page_name,aa.TagName5 as TagName,aa.Tag,aa.Tag_count, @counter5 := @counter5 + 1 AS counter from\r\n (\r\n select a.id, a.page_name, a.TagName5, a.Tag5 as Tag, count(a.Tag5) as Tag_count from\r\n (\r\n select pg.id, pg.page_name, p.Tag5, pg.TagName5 from\r\n pages pg, posts p\r\n where pg.id = and\r\n p.page_id = pg.id and \r\n pg.TagName5 <> '' and \r\n pg.TagChoice5_1 <> '') a\r\n group by a.id, a.page_name, a.Tag5) aa\r\n CROSS JOIN (SELECT @counter5 := 0) AS init"}]