Array
(
[0] => Varien_Object Object
(
[_data:protected] => Array
(
[label] =>
[category] => Mage_Catalog_Model_Category Object
(
[_eventPrefix:protected] => catalog_category
[_eventObject:protected] => category
[_cacheTag:protected] => catalog_category
[_useFlatResource:protected] =>
[_designAttributes:Mage_Catalog_Model_Category:private] => Array
(
[0] => custom_design
[1] => custom_design_from
[2] => custom_design_to
[3] => page_layout
[4] => custom_layout_update
[5] => custom_apply_to_products
)
[_treeModel:protected] =>
[_defaultValues:protected] => Array
(
)
[_storeValuesFlags:protected] => Array
(
)
[_lockedAttributes:protected] => Array
(
)
[_isDeleteable:protected] => 1
[_isReadonly:protected] =>
[_resourceName:protected] => catalog/category
[_resource:protected] =>
[_resourceCollectionName:protected] => catalog/category_collection
[_dataSaveAllowed:protected] => 1
[_isObjectNew:protected] =>
[_data:protected] => Array
(
[entity_id] => 3354
[entity_type_id] => 3
[attribute_set_id] => 3
[parent_id] => 2
[created_at] => 2021-02-02 10:05:20
[updated_at] => 2021-09-29 15:54:41
[path] => 1/2/3354
[position] => 166
[level] => 2
[children_count] => 0
[is_active] => 1
[name] => Newspaper
[url_key] => zeitschriften
)
[_hasDataChanges:protected] => 1
[_origData:protected] => Array
(
[entity_id] => 3354
[entity_type_id] => 3
[attribute_set_id] => 3
[parent_id] => 2
[created_at] => 2021-02-02 10:05:20
[updated_at] => 2021-09-29 15:54:41
[path] => 1/2/3354
[position] => 166
[level] => 2
[children_count] => 0
[is_active] => 1
[name] => Newspaper
[url_key] => zeitschriften
)
[_idFieldName:protected] => entity_id
[_isDeleted:protected] =>
)
[is_active] => 1
)
[_hasDataChanges:protected] => 1
[_origData:protected] =>
[_idFieldName:protected] =>
[_isDeleted:protected] =>
)
)
Newspaper
+++++ SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, IF(_table_status.value_id > 0, _table_status.value, _table_status_default.value) AS `status` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='4' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='3354' AND cat_index.is_parent=1
INNER JOIN `catalog_product_entity_int` AS `_table_status_default` ON (`_table_status_default`.`entity_id` = `e`.`entity_id`) AND (`_table_status_default`.`attribute_id` = '84') AND `_table_status_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_int` AS `_table_status` ON (`_table_status`.`entity_id` = `e`.`entity_id`) AND (`_table_status`.`attribute_id` = '84') AND (`_table_status`.`store_id` = '4') WHERE (IF(_table_status.value_id > 0, _table_status.value, _table_status_default.value) = 1) ORDER BY `cat_index_position` asc, `cat_index`.`product_id` asc LIMIT 25
Price: £ --.-- |
Ready for dispatch:
Sat, 13 Aug 2022
Date applies only if payment is complete and print-ready files are submitted (and approved) until 9 AM.
STANDARD production time can not be guaranteed. For time sensitive orders please select EXPRESS / URGENT turnaround.
Plus shipping:
- Standard Shipping: 2-3 business days (free)
- Express Shipping: 1 business day
Newspaper will be online soon.
- Products
-
- A
- Advertising systems
- Appointment cards
- B
- Bags
- Balloons
- Banners
- Boards
- Booklets
- Bookmarks
- Books
- Brochures
- Business Cards
- C
- Calendars
- Cards
- Catalogues
- Catering & Hospitality
- Certificates
- Coupons
- Cups
- D
- Desk pads
- Displays
- E
- Eco/natural products
- Envelopes
- Event Tickets
- Events
- Exhibition systems
- F
- Flags
- Flyers
- Folders
- Folding Cards
- Folding Rulers
- H
- Hardcover
- L
- Labels
- Leaflets
- Letterheads
- Loose-Leaf-Collection
- M
- Magazines
- Mailers
- N
- NCR pads
- Newspaper
- Notebooks
- Notepads
- O
- Office supplies
- P
- Packaging
- Pavement Signs
- Pens & Pencils
- Plastic Cards
- Postcards
- Posters
- R
- Roller Banners
- S
- Signs
- Stamps
- Stickers
- Sticky note pads
- Stretcher frame
- Sweets
- T
- Tarpaulins
- Trade shows
- W
- Wristbands
4.5
5
Newsletter