Еркин Татишев: про победу в конкурсе, январские события, образование и проблемы бизнеса
articles
date
data
obLevel
__env
app
errors
paginator
elements
__currentLoopData
item
key
loop
pub_date
author
count
corp_blogs
anounce
birthdays
editor_choise
video
most_shared
most_views
select count(*) as aggregate from `forbes_data` where `Date` <= '2025-07-26 19:29:43' and `finished` = '1' and `DataType` = 'articles' and `Date` >= '2024-01-01 00:00:00' and `Date` <= '2024-12-31 23:59:59'
select * from `forbes_data` where `Date` <= '2025-07-26 19:29:43' and `finished` = '1' and `DataType` = 'articles' and `Date` >= '2024-01-01 00:00:00' and `Date` <= '2024-12-31 23:59:59' order by `Date` asc limit 25 offset 1800
SELECT *
select * from `forbes_data_data` where `forbes_data_data`.`DataID` in ('320775', '320889', '320926', '321008', '321014', '321021', '321022', '321024', '321026', '321027', '321038', '321039', '321040', '321041', '321043', '321047', '321051', '321053', '321055', '321056', '321060', '321073', '321081', '321091', '321092')
select * from `forbes_data_images` where `forbes_data_images`.`ImageID` in ('159982', '160160', '160380', '160396', '160397', '160399', '160400', '160406', '160432', '160434', '160435', '160436', '160437', '160440', '160441', '160444', '160447', '160456', '160457', '160459', '160463', '160482', '160499', '160506', '160507')
select * from `forbes_images` where `forbes_images`.`ImageID` in ('159982', '160160', '160380', '160396', '160397', '160399', '160400', '160406', '160432', '160434', '160435', '160436', '160437', '160440', '160441', '160444', '160447', '160456', '160457', '160459', '160463', '160482', '160499', '160506', '160507')
select * from `forbes_data_authors` where `DataID` = '321014' order by `Position` asc
select * from `forbes_data_authors` where `DataID` = '320889' order by `Position` asc
select * from `forbes_authors` where `forbes_authors`.`AuthorID` in ('794')
select * from `forbes_images` where `forbes_images`.`ImageID` in ('58941')
select * from `forbes_data_authors` where `DataID` = '320926' order by `Position` asc
select * from `forbes_authors` where `forbes_authors`.`AuthorID` in ('940')
select * from `forbes_images` where `forbes_images`.`ImageID` in ('55865')
select * from `forbes_data_authors` where `DataID` = '321021' order by `Position` asc
select * from `forbes_data_authors` where `DataID` = '321022' order by `Position` asc
select * from `forbes_data_authors` where `DataID` = '321024' order by `Position` asc
select * from `forbes_authors` where `forbes_authors`.`AuthorID` in ('167')
select * from `forbes_images` where `forbes_images`.`ImageID` in ('')
select * from `forbes_data_authors` where `DataID` = '321027' order by `Position` asc
select * from `forbes_authors` where `forbes_authors`.`AuthorID` in ('1284')
select * from `forbes_images` where `forbes_images`.`ImageID` in ('131136')
select * from `forbes_data_authors` where `DataID` = '321038' order by `Position` asc
select * from `forbes_authors` where `forbes_authors`.`AuthorID` in ('553')
select * from `forbes_images` where `forbes_images`.`ImageID` in ('58940')
select * from `forbes_data_authors` where `DataID` = '321039' order by `Position` asc
select * from `forbes_authors` where `forbes_authors`.`AuthorID` in ('1044')
select * from `forbes_images` where `forbes_images`.`ImageID` in ('74536')
select * from `forbes_data_authors` where `DataID` = '321040' order by `Position` asc
select * from `forbes_authors` where `forbes_authors`.`AuthorID` in ('219')
select * from `forbes_images` where `forbes_images`.`ImageID` in ('125452')
select * from `forbes_data_authors` where `DataID` = '321026' order by `Position` asc
select * from `forbes_authors` where `forbes_authors`.`AuthorID` in ('70', '467', '907', '1361')
select * from `forbes_images` where `forbes_images`.`ImageID` in ('9741', '138379')
select * from `forbes_data_authors` where `DataID` = '321008' order by `Position` asc
select * from `forbes_data_authors` where `DataID` = '321047' order by `Position` asc
select * from `forbes_data_authors` where `DataID` = '321043' order by `Position` asc
select * from `forbes_authors` where `forbes_authors`.`AuthorID` in ('397')
select * from `forbes_images` where `forbes_images`.`ImageID` in ('146357')
select * from `forbes_data_authors` where `DataID` = '321041' order by `Position` asc
select * from `forbes_data_authors` where `DataID` = '321053' order by `Position` asc
select * from `forbes_data_authors` where `DataID` = '321055' order by `Position` asc
select * from `forbes_authors` where `forbes_authors`.`AuthorID` in ('381')
select * from `forbes_images` where `forbes_images`.`ImageID` in ('13262')
select * from `forbes_data_authors` where `DataID` = '320775' order by `Position` asc
select * from `forbes_authors` where `forbes_authors`.`AuthorID` in ('1280')
select * from `forbes_images` where `forbes_images`.`ImageID` in ('160461')
select * from `forbes_data_authors` where `DataID` = '321051' order by `Position` asc
select * from `forbes_data_authors` where `DataID` = '321056' order by `Position` asc
select * from `forbes_data_authors` where `DataID` = '321060' order by `Position` asc
select * from `forbes_data_authors` where `DataID` = '321073' order by `Position` asc
select * from `forbes_authors` where `forbes_authors`.`AuthorID` in ('1063')
select * from `forbes_images` where `forbes_images`.`ImageID` in ('95833')
select * from `forbes_data_authors` where `DataID` = '321081' order by `Position` asc
select * from `forbes_data_authors` where `DataID` = '321091' order by `Position` asc
select * from `forbes_data_authors` where `DataID` = '321092' order by `Position` asc
select * from `forbes_prteaser_group` where `url` not in ('sap') and `validfrom` <= '2025-07-26 19:29:43' and `validtill` >= '2025-07-26 19:29:43' limit 5
LIMIT
ORDER BY
select * from `forbes_anounces` order by `AnounceID` desc limit 1
SELECT
WHERE
select * from `forbes_images` where `forbes_images`.`ImageID` in ('160604')
select * from `forbes_bdays` where month(`Bday`) = '7' and day(`Bday`) = '26' order by `Bday` desc
select `forbes_data_tops`.`DataID`, `forbes_data`.`Date` from `forbes_data_tops` inner join `forbes_data` on `forbes_data_tops`.`DataID` = `forbes_data`.`DataID` and `forbes_data`.`finished` = '1' where `forbes_data_tops`.`StructureID` = '66' and `forbes_data`.`Date` <= '2025-07-26 19:29:43' order by `forbes_data_tops`.`Position` asc limit 1 offset 0
select * from `forbes_data_data` where `forbes_data_data`.`DataID` in ('320937')
select * from `forbes_data_images` where `forbes_data_images`.`ImageID` in ('160257')
select * from `forbes_images` where `forbes_images`.`ImageID` in ('160257')
select * from `forbes_video` where `isShow` = '1' and `project` = 'qna' order by RAND() limit 1
ORDER BY RAND()
select * from `forbes_data` inner join `forbes_data_social_stats2` on `forbes_data_social_stats2`.`DataID` = `forbes_data`.`DataID` where `Date` >= '2025-07-25 19:29:44' and `AnounceID` is null and `finished` = '1' order by `forbes_data_social_stats2`.`facebook` desc limit 7
select * from `forbes_data` inner join `forbes_data_data` on `forbes_data`.`DataID` = `forbes_data_data`.`DataID` where `Date` <= '2025-07-26 19:29:44' and `finished` = '1' and `DataType` = 'articles' and `Date` >= '2025-07-25 19:29:44' order by `forbes_data_data`.`Views` desc limit 7
select * from `forbes_video` where `isShow` = '1' and `addDate` >= '2025-07-25 19:29:44' order by `addDate` desc limit 1