No execute query to MySQL Server.
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-30,
30' at line 72 in
select
SQL_CALC_FOUND_ROWS
Page.Id,
#Page.Name,
Page.Caption,
Page.Path,
Page.DateUpdate,
BMMark.Image,
BMMark.Preview,
#StatusPage.Caption as Status,
#VisiblePage.Caption as Visible,
#BMMark.DatePriority,
#BMMark.NumberDemand,
#BMMark.DateRegister,
#BMMark.NumberCertificate,
#ControllerPage.Caption as Controller,
TypePricePage.Caption as TypePrice,
BMMark.Price,
CurrencyPage.Caption as Currency,
BMCache.Classes,
BMCache.Groupes
from
Page
join BMMark on BMMark.Page = Page.Id
and BMMark.Visible != 4417
left join BMCache on BMCache.Page = Page.Id
left join Page RegistrationPage on RegistrationPage.ParentName = Page.Name
and RegistrationPage.Class = 428
and RegistrationPage.Site = '2421'
#left join BMRegistration on BMRegistration.Page = RegistrationPage.Id
#left join Page ClassPage on ClassPage.Id = BMRegistration.Classed
# and ClassPage.Class = 431
# and ClassPage.Site = '2421'
left join Page AccessoryPage on AccessoryPage.ParentName = Page.Name
and AccessoryPage.Class = 429
and AccessoryPage.Site = '2421'
#left join BMAccessory on BMAccessory.Page = AccessoryPage.Id
#left join Page ControllerPage on ControllerPage.Id = BMMark.Controller
# and ControllerPage.Class = 439
# and ControllerPage.Site = '2421'
#left join Page VisiblePage on VisiblePage.Id = BMMark.Visible
# and VisiblePage.Class = 7
# and VisiblePage.Site = '2421'
left join Page StatusPage on StatusPage.Id = BMMark.Status
and StatusPage.Class = 7
and StatusPage.Site = '2421'
left join Page TypePricePage on TypePricePage.Id = BMMark.TypePrice
and TypePricePage.Class = 7
and TypePricePage.Site = '2421'
left join Page CurrencyPage on CurrencyPage.Id = BMMark.Currency
and CurrencyPage.Class = 7
and CurrencyPage.Site = '2421'
where
Page.Class = 427
and Page.Site = '2421'
and BMMark.Visible = 4416
group by
Page.Caption,
Page.Name
order by
Page.DateCreate DESC
limit
-30,
30