LEFT JOIN types_view AS t ON ( pa.types_id = t.id )
LEFT JOIN pubgroups AS pg ON ( pa.pubgroups_id = pg.id )
uos.hfu as uos_hfu, uos.name as uos_name
pt.name as ptname, pt.descr as ptdescr,
t.name typesname, t.tghfu tghfu, t.typesglobal_id typesglobal_id,
pg.name rubricname, pg.hfu rubrichfu,
u.user_hfu, u.user_first_name, u.user_last_name, u.username,
pa.id, pa.hfu, pa.name, pa.title, pa.photos_dir, pa.users_id, pa.types_id, pa.pubgroups_id, date_final, pa.flag_available,
`pg`.`name` ORDER BY `count` desc
LEFT JOIN `pubarticles` AS `pa` ON pa.pubgroups_id = pg.id WHERE (pg.pubtype_id = '3') GROUP BY `pg`.`id`,
SELECT `pubtype`.* FROM `pubtype` WHERE (types_id = '18') LIMIT 1SELECT `pubgroups`.* FROM `pubgroups` WHERE (hfu = 'conception') LIMIT 1SELECT `pg`.`id` AS `iid`, `pg`.`name`, `pg`.`hfu`, count(*) AS `count` FROM `pubgroups` AS `pg`
WHERE IP_FROM = inet_aton( '46.105.108.68' )
FROM a04004_market.IP_TO_COUNTRY
LEFT JOIN communityusers cu ON ( cu.communitymain_id = cm.id ) , uosreluostype urt
LEFT JOIN communitymain cm ON ( cm.id = cru.community_id )
LEFT JOIN comm_rel_uos cru ON ( uos.id = cru.uos_id )
SELECT DISTINCT uos.id AS uos_id, uos.name AS uos_name, uos.hfu AS uos_hfu, cm.name AS cm_name, cm.hfu AS cm_hfu
время обработки php (сек) 0,14536595344543connectSET NAMES CP1251
Разместите на Аденься афишу и фотоотчеты мероприятий, новости шоппинга, коллекции или товары
Модные советы: подбираем одежду для фигуры-«прямоугольник». Статьи на ADENSYA.RU
Комментариев нет:
Отправить комментарий