SELECT i.id AS i__id, i.code AS i__code, i.category_id AS i__category_id, i.page_id AS i__page_id, i.name AS i__name, i.bonus AS i__bonus, i.action AS i__action, i.new AS i__new, i.top AS i__top, i.order AS i__order, i.image AS i__image, i.is_published AS i__is_published, i.pos AS i__pos, i.detailed_description AS i__detailed_description, i.brand_id AS i__brand_id, i.model AS i__model, i.created_at AS i__created_at, i.updated_at AS i__updated_at, c.id AS c__id, c.code AS c__code, c.parent_id AS c__parent_id, c.property_id AS c__property_id, c.name AS c__name, c.bonus AS c__bonus, c.image AS c__image, c.path AS c__path, c.spath AS c__spath, c.is_published AS c__is_published, c.pos AS c__pos, c.img AS c__img, p.id AS p__id, p.item_id AS p__item_id, p.type AS p__type, p.currency AS p__currency, p.value AS p__value, p.value_old AS p__value_old, p.date AS p__date, i2.id AS i2__id, i2.item_id AS i2__item_id, i2.term AS i2__term FROM item i INNER JOIN category c ON i.category_id = c.id INNER JOIN price p ON i.id = p.item_id INNER JOIN item_day i2 ON i.id = i2.item_id WHERE (i.is_published = 1 AND i.image IS NOT NULL)id code category_id page_id name bonus action new top order image is_published pos detailed_description brand_id model created_at updated_at