2hufters.be

Als ge altijd op dezelfde bugs stuit en ge wilt minder tijd spenderen aan al die shit, fix die zaken dan.
Wat zijn de makkelijkste manieren om gelijk wat te fixen. Ik som ze even op:

• position: fixed;
• background-attachment: fixed;
• etc … : fixed;

Dus gewoon fixen wat mis is… lijkt me logisch

Vooral de muziek is vet!

Wat krijg je als je een catalogus met 7 talen moet maken?

SELECT

 `p_launchDate` AS `launchDate`,

 `p_articleId` AS `articleId`,

 `p_image` AS `image`,

 `p_pType` AS `pType`,

 `nl`.`p_productName` AS `productName_nl`,

 `nl`.`p_description` AS `description_nl`,

 `nl`.`p_availableIn` AS `availableIn_nl`,

 `nl`.`p_extraInfo` AS `extraInfo_nl`,

 `en`.`p_productName` AS `productName_en`,

 `en`.`p_description` AS `description_en`,

 `en`.`p_availableIn` AS `availableIn_en`,

 `en`.`p_extraInfo` AS `extraInfo_en`,

 `fr`.`p_productName` AS `productName_fr`,

 `fr`.`p_description` AS `description_fr`,

 `fr`.`p_availableIn` AS `availableIn_fr`,

 `fr`.`p_extraInfo` AS `extraInfo_fr`,

 `de`.`p_productName` AS `productName_de`,

 `de`.`p_description` AS `description_de`,

 `de`.`p_availableIn` AS `availableIn_de`,

 `de`.`p_extraInfo` AS `extraInfo_de`,

 `it`.`p_productName` AS `productName_it`,

 `it`.`p_description` AS `description_it`,

 `it`.`p_availableIn` AS `availableIn_it`,

 `it`.`p_extraInfo` AS `extraInfo_it`,

 `es`.`p_productName` AS `productName_es`,

 `es`.`p_description` AS `description_es`,

 `es`.`p_availableIn` AS `availableIn_es`,

 `es`.`p_extraInfo` AS `extraInfo_es`,

 `pt`.`p_productName` AS `productName_pt`,

 `pt`.`p_description` AS `description_pt`,

 `pt`.`p_availableIn` AS `availableIn_pt`,

 `pt`.`p_extraInfo` AS `extraInfo_pt`

FROM

 `products`

LEFT JOIN `products_desc` `nl` ON `products`.`p_id` = `nl`.`pd_p_id` AND `nl`.`pd_lang` = 'nl'

LEFT JOIN `products_desc` `en` ON `products`.`p_id` = `en`.`pd_p_id` AND `en`.`pd_lang` = 'en'

LEFT JOIN `products_desc` `fr` ON `products`.`p_id` = `fr`.`pd_p_id` AND `fr`.`pd_lang` = 'fr'

LEFT JOIN `products_desc` `de` ON `products`.`p_id` = `de`.`pd_p_id` AND `de`.`pd_lang` = 'de'

LEFT JOIN `products_desc` `it` ON `products`.`p_id` = `it`.`pd_p_id` AND `it`.`pd_lang` = 'it'

LEFT JOIN `products_desc` `es` ON `products`.`p_id` = `es`.`pd_p_id` AND `es`.`pd_lang` = 'es'

LEFT JOIN `products_desc` `pt` ON `products`.`p_id` = `pt`.`pd_p_id` AND `pt`.`pd_lang` = 'pt'